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