Cube Calculations To Date behaviour

View previous topic View next topic Go down

Cube Calculations To Date behaviour

Post  reportshack on Wed Apr 18, 2012 1:28 pm

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?

reportshack

Posts : 2
Join date : 2011-10-06

View user profile

Back to top Go down

Re: Cube Calculations To Date behaviour

Post  Mike Honey on Fri Apr 20, 2012 12:31 am

How have you defined [Measures].[Revenue Recognition to Date] ?
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re: Cube Calculations To Date behaviour

Post  reportshack on Fri Apr 20, 2012 9:16 am

I actually show it in the post:

Revenue Recognition to Date = Actual Cost to Date / Budget Cost to Date * Budget Revenue To Date

mdx = [Measures].[Actual Cost to Date /([Measures].[Budget Cost to Date] * [Measures].[Budget Revenue To Date].

the problem is not the accuracy of the calculation or even the inidividual months, it is how it behaves when only certain months are selected.

If if every month is shown, it shows an accurate grand total, if only some months are selected, it still shows the same grand total as that of all the months added together.

reportshack

Posts : 2
Join date : 2011-10-06

View user profile

Back to top Go down

Re: Cube Calculations To Date behaviour

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum