Her er et eksempel på hvordan man beregner den absolutte værdi af et givent Measure.
Code Block
WITH
MEMBER [Measures].[Neg Profit] AS ‘-1 * [Measures].[Profit]’
MEMBER [Measures].[Abs Profit] AS ‘ABS([Measures].[Neg Profit])’
SELECT
{[Measures].[Neg Profit], [Measures].[Abs Profit]} ON COLUMNS,
NON EMPTY DESCENDANTS( [Customers] ) ON ROWS
FROM
[Sales]
