In this article you will find examples of original cube calculations as well as new cube calculations that generally will improve performance.
Using SUM ({ [ ] , [ ] }) instead of [ ] + [ ]
| Info | ||
|---|---|---|
| ||
The SUM function can only be used on the summation of members or tuples not on substractions. The SUM function can only be used on tuples with the same dimensions. |
...
The InStr statement is used frequently at customers that have split dimensions (SAP, Essbase).
Example 4 InStr on Time dimension
...
Instr([Time].[H1].currentmember.name,“2017”) <>0
New When the Properties of the Year dimension are properly populated, the above cube calculation can be replaced by the following cube calculation:
[Time].[H1].currentmember.Properties(”Year”) = “2017”
...