April 25, 2013 at 8:33 am
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!
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy