April 18, 2012 at 11:32 am
The cube developed is for an origanization that manages and conducts huge projects.
All project calculations are based on the life of a project, in other words beginning of time to date.
In other words:
Revenue Recognition to Date = Actual Cost to Date / Budget Cost to Date * Budget Revenue To Date
Revenue Recognition for Current Period =
([Time].[Year - Month].CurrentMember,[Measures].[Revenue Recognition to Date])-
([Year - Month].PrevMember,[Measures].[Revenue Recognition to Date])
This gives current period accurately, but when a user selects inidividual periods, say January 2012, March 2012, April 2012, the sum (Grand Total) of the report does not properly add up. It still reflects the total as the "To Date" value.
Any ideas how this behaviour can be changed?
April 18, 2012 at 1:14 pm
is the hierarchy properly designed to ensure SSAS knows what the current and premembers are?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 18, 2012 at 1:32 pm
Here is some background:
1. its at the scope of the projects only.
2. the Time.[Year - Month] hierarchy is used
3. the ClosingPeriod calculation is used to arrive at a to date value for each project
I am not sure what more information to supply. There is no hierarchy to consider other than the time dimension's above.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply