August 17, 2010 at 3:09 pm
Greetings all,
I am having an issue with my Data Cubes ( or I should say our end users have a requirement that I can not find a solution too!) where date ranges are necessary. From my research I have determined that a time dimension may have calculations in it that would allow me to use date ranges, but I am not 100% sure of that. Additionally we have a very non-standardized fiscal calendar, so from what I can see in the time dimension wizard, building this off of an existing table does not seem plausible.
Any thoughts on this?
Link to my blog http://notyelf.com/
August 18, 2010 at 9:38 am
First off, you will probably have to build a physical date dimension to hold your unusual fiscal date information, then create your Analysis Services dimension from that. Make sure you correctly the dimension type to 'Time', and set the type on all the attributes (i.e. date, year, month, month of year, etc.). Then, set up hierarchies - create at least one so that you can navigate it. This will give you the dimension you need.
For creating your ranges of dates, look at named sets. This is where your hierarchy/hierarchies will come into play - you can define ranges of dates based on their position in the hierarchy - for example, all the months in this year = the set of all months which have the same parent (year) as the current month.
Hope this helps put you in the right track.
Duncan
August 18, 2010 at 10:53 am
Thank you for your response!
This does help me in the right direction however, while I do have a physical date dimension built that contains all our fiscal calendar and its corresponding types (month, week, year, quarter, etc), I do not know how to build a time dimension from this table.
In regards to named sets...would this be dynamic? for instance, say I wanted to look at a date range of 03/03/2009 to 05/02/2010?
Link to my blog http://notyelf.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply