Space problem due to reporting

Options
johan.marketoft
johan.marketoft Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Frequent Contributor
in Planning & Modeling

Hi,

 

I have a calculation module that has 6 dimensions as well as by month. This one is then referenced by a reporting module without time (instead a list for MTD, QTD, YTD).

 

The problem is that in order to get the numbers in for QTD and YTD I need to do a TIMESUM in the Reporting module, and since it doesn't allow SUMS/LOOKUPS within it I have resorted to subsidiary views in the Calculation module. This greatly increases the Calculation module. Is there a good way around this? The only reason I am doing those subsidiary views is because of that TIMESUM, not used otherwise.

 

Best regards,

Johan

Tagged:

Categories