Which is more efficient, TIMESUM( ) or [SELECT:Time.All Periods]

Options

If I'm trying to accumulate all time periods from a source module with time dimension to a target module with no time dimension, which option is more efficient? Should I use TIMESUM with no start or end date, or a hard-coded select clause for all periods?

Answers

  • The SELECT will be quicker; the aggregation is pre-done and you are just grabbing that total. The TIMESUM is having to do all that calculation.

  • @clarissa

    Hope all is well, good to see you one the Community!

    As @MarkWarren said, the Select would be better IF the All Time Periods has been checked.

  • As note nice thing regarding Timesum is that then you don't need to have All Time Periods in your model.