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

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?

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

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.

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In