Your answer will be to make the hierarchies STORED
No score for this post
May 2 2012, 2:33 PM
Data Retrieval buffers and ASO caches are NOT going to be your answer.
Only stored hierarchies are truly ASO - if you converted from BSO I bet you have mostly Dynamic hierarchies.
In accounts if you have any true calculated values ($ per unit or Gross Proffit percentage etc) enable multiple hierarchies and put those in a separate dynamic hierarchy from the main P&L outline. Speaking of P&L the entire P&L must be additive consolidation in order to make the hierarchy stored. I know you have to subtract expenses from sales to get profit but let the positive data values of sales and the negative values for expenses handle that.
Then if your client wants to see positive values for expenses create a dynamic formula in a small dimension such as scenario such that [Actual] is a dynamic formula that multiplies values in its child [Actual loaded] by *-1 if there is a uda indicating that the account is an expense.
You need to make your time dimension stored also.
Stored is your answer.
Scoring disabled. You must be logged in to score posts.