September 29, 2008 at 11:55 pm
Hi
We have some SSAS developers putting together a cube for us and i have asked for certain functionality that they said can't be done, this may be the case but i thought i would try and find a way anyway.
We have 3 budget releases per year, we'll call them 1,2 and 3. The year 2007 has budget's 1,2,3 and the year 2008 has only 1 and 2.
What we want to do is view the budget components by year and budget ID, this is fine BUT when i remove Budget ID from the query and view data at year level i want to see the last budget ID figures for each year.(it currently shows the first BudgetID's figures)
The developer said what i wanted was this:
"[Budget].[3] for [Time].[2007] but [Budget].[2] for [Time].[2008]"
Could anyone give me a thubs up ar down for this.
Cheers
September 30, 2008 at 5:21 am
Your developers are wrong. This can be done.
You could either create individual calculated measures or create member calculations similar to how the time intelligence wizard handles "Prior Year" type calculations.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply