Calculates the value only once per report execution and stores it as one value per report in the cache. It can be useful when one value should be used in several calculations in the same report.
This function is available on eazyBI Cloud and starting from the eazyBI version 6.5.
|Expression||MDX expression that typically returns a measure, a tuple, or a string.|
A report has a measure that should calculate one common value and then reuse it for different other formulas. For example, the report calculates a start date of the report and then uses this start date for different cases - to show periods, calculate predictions, etc.
The formula example below calculates the start date of the report based on the individual version start date or the first date when an issue was moved to in progress. This calculation will be applied only once (first context) per report execution. It should be used in other calculations to get value out of caching those results.
ConstantValue( Case when Not isempty([Fix Version].CurrentHierarchyMember.get('Start date')) Then -- Selected fix versions has Start Date, this date is used as Start Date [Fix Version].CurrentHierarchyMember.getDate('Start date') Else -- the first date when an issue in version moved to any in progress status DateParse(([Measures].[Transition to status first date], [Transition Status.Category].[In Progress], [Time].CurrentHierarchy.Defaultmember)) End)
- Function ConstantColumnValue() works similarly. It should be used if context changes in columns.
- Function Cache()