...
Original cube calculation:
([ACC].[ACC].[OperatingIncome]
...
+
...
[ACC].[ACC].[TotalDeprAmort])
New cube calculation:
SUM({[ACC].[ACC].[OperatingIncome], [ACC].[ACC].[TotalDeprAmort]})...
Original cube calculation:
([ACC].[ACC]. [OperatingExpenses] + [ACC].[ACC]. [Administrative] - [ACC].[ACC]. [Depreciation] - [ACC].[ACC]. [Amortization])
New cube calculation:
SUM({[ACC].[ACC]. [OperatingExpenses], [ACC].[ACC]. [Administrative]}) –SUM({[ACC].[ACC]. [Depreciation], [ACC].[ACC]. [Amortization]})Example 3 Calculation with multiple dimensions
...
Instr([Time].[H1].currentmember.name,”2017”“2017”) <>0
New cube calculation:
...