SSAS Current Fiscal Period

• Chris Schmidt

  Say Hey Kid

  Points: 686

  More actions

  April 25, 2013 at 8:33 am

  #273274

  I would like to add the concept of a Current Fiscal Period into an existing cube that already has a time dimension. Within the SSAS Database, there already exists a cube called "Current Fiscal Period" that has 1 measure group and 1 dimension. The one value consists of a six character string such as "201304".

  I plan to include the "Current Fiscal Period" cube as a linked object in my larger cube.

  The Million dollar question is: Do I want to use the Current Fiscal Period as a dimension or a measure?

  Instinctively I want to use it as a dimesnion, but when I look at some other applications in my shop from the past it seems they used it as a measure instead. Why?

  What is the best way to implement this?

  Please give me your opinion.

  Thanks!