Space problem due to reporting

johan.marketoft
johan.marketoft
in 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:

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @johan.marketoft 

     

    Instead of using TimeSum() with Time in the Applies, which is not good for performance reasons, think about using the functions MonthToDate, QuarterToDate, and YearToDate.

     

    Link to MonthToDate()

     

    Then, you can reference these in the reporting module.

     

    Does that help?

     

    Rob

Answers

  • JaredDolich
    JaredDolich

    @rob_marshall 

    this is why I never miss one of your responses Rob. I couldn't think of another way except TIMESUM. But, the period to date functions are brilliant and easier on the calculation engine. Lesson learned.

Categories