Welcome to Salvo(z)

Roughly a year ago, I decided to enroll in an adult ballet class.  I have no prior dance experience, so I wasn’t really sure what to expect.  My reasons for taking ballet are to improve strength and flexibility as well as obtain a cardio workout.

A common request from business users is ‘Time Intelligence’ functionality in an SSAS cube.  For example, users may wish to compare current year sales with the prior year or calculate sales year-to-date.  DAX includes a wide range of time intelligence functions to perform these types of calculations.  We can create measures in a tabular cube for the various time intelligence formulas, such as Sales Year-Over-Year or Sales Year-to-Date.  An alternative to exposing individual measures for the various time intelligence formulas is to create a ‘Time Calculations’ dimension.

SQL Server BCP is a command line utility that bulk copies data between instances of SQL Server and data files.  Data can be imported into SQL Server tables or exported to a data file.  The BCP utility can also be used to generate format files which specify the number and type of data columns.  The BCP utility can quickly transfer large amounts of data.

Update: 3/17/2017

PerformancePoint provides several options to create filters.  One of the options available is ‘Named Set’.  Within SSAS cubes we can define ‘Named Sets’, which are MDX expressions that return a set of dimension members.  These ‘Named Sets’ can be used to populate filters within PerformancePoint.