Cache

Caches the result of the calculation in memory for query in execution. Can be useful when same calculation is repeated during the report more than once.

Syntax

Cache(Expression)

Examples

A report has a measure that for calculation uses the result of a previously calculated measure. Using cache would store the first time calculation result in memory and for the next measure would be used to optimize the performance of the report.

Open issues are calculated much faster using the cache function as the query should go through all time members and repeat the mathematical expression to each of them.

Cache(
  NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
  Cache([Measures].[Issues created]
    - [Measures].[Issues resolved])
  ))
  + [Measures].[Issues created]
  - [Measures].[Issues resolved]
 )