Problem in CM with 2 hierarchy of Date dimention, calculaiting remainder of quantity -
11-17-2004
, 02:32 AM
CM expressions:
Iif([Date].[YWD].CurrentMember is [Date].[YWD].DefaultMember,
-- in YQMD hierarchy
Sum(Ascendants([Date].[YQMD].CurrentMember),
Sum([Date].[YQMD].FirstSibling : [Date].[YQMD].CurrentMember,
[Measures].[change of quantity]) - [Measures].[change of quantity]),
-- in YWD hierarchy
Sum(Ascendants(LinkMember(OpeningPeriod[Date].[YWD].[Day],
[Date].[YWD].CurrentMember), [Date].[YQMD])),
Sum([Date].[YQMD].FirstSibling : [Date].[YQMD].CurrentMember,
[Measures].[change of quantity]) - [Measures].[change of quantity]))
If I don't use LinkMember - just change an hierarchy in CM - all ok.
But I want use YQMD hierarchy because of aggregations and as a result
more faster computing. |