Match
Type
Boolean
Since
1.2
Description
With the Fact-property you can define which fact a formula will calculate. If you only define the fact of a formula, it will calculate this fact for the complete cube (for all elements of all dimensions). But if you want the formula to only calculate a part of the cube (maybe only a special level of one dimension), you can add a match-expression to the formula with this property.
The match-expression limits the usage of this formula to all coordinates for which the expression returns "true" (the match-expression is a Boolean-Expression). The match-expression could for example test the current coordinate for a level of for the occurrence of a special key. Match-expression in formulas are similar to the match-expression in cubes or caches.
Examples
Match = "HASLEVEL( Time, 1 )"
Only calculate the level 1 of the Time-dimension
Match = "HASKEYS( Product:A )"
Only calculate for Product "A"
See also
Fact
