Code: Select all
FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([Accounts Master].[Hier.001]), 0),
[Account Mapping].([Version].[Active_02],
[sys.Websheet Control].[Input],
[Geography].[All Geography],
[HR Level].[All HR Levels],
[Organization].[Function Support],
[lookup.Measure].[CalcFlag2]) > 0)
- Version
- sys.Websheet Control
- Geography
- HR Level
- Organization
- Accounts Master
- lookup.Measure
Code: Select all
FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([Accounts Master].[Hier.001]), 0),
[Account Mapping].([Version].[Active_02],
[sys.Websheet Control].[Input],
[Geography].[All Geography],
[HR Level].[All HR Levels],
[Organization].[Function Support],
[Accounts Master].[Hier.001].currentmember,
[lookup.Measure].[CalcFlag2]) > 0)
The real problem is the query is failing to return the desired members in a TI. We use MDX for virtually everything and this type of filtering is quite common. What strange evil magic is at work here?