1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| CREATE MEMBER CURRENTCUBE.[Measures].[Val] AS
NULL, FORMAT_STRING = "#0.00", VISIBLE = 1,
NON_EMPTY_BEHAVIOR= [Measures].[Val_Currency];
SCOPE [Measures].[Val];
SCOPE [STR CURRENCY].[L1].[All];
THIS =
IIF
(
ISEMPTY(([Measures].[Val_Currency], [REST CURRENCY].[REST CURRENCY_KEY].&[-9])),
NULL,
SUM
(
NonEmpty
(
existing [STR CURRENCY].[L1].Members,
([Measures].[Val_Currency], [REST CURRENCY].[REST CURRENCY].[REST CURRENCY].&[-9])
),
[Measures].[Val]
)
);
END SCOPE;
END SCOPE; |
Partager