i got stuck in a mdx statement, first the MDX Code:
Code: Select all
{Filter(
{TM1FILTERBYLEVEL({
DESCENDANTS(Planungseinheit.[Leistungsspektrum]) }, 0)},
[Mengen-Planung Tag Mandant].([Mengen].CurrentMember, [Kontaktart].CurrentMember, [Version].CurrentMember, [Planungseinheit].CurrentMember, [Mandant].CurrentMember, [Tag].[2022], [Kennzahlen Mengen-Planung Mandant].[LMin]) > 0
and
[MA-Pool Zuordnung Menge].([Jahre].[2022], [Monat].CurrentMember, [Version].CurrentMember, [Mengen].CurrentMember, [Kontaktart].CurrentMember, [MA-Pool].[MA-Pool Gesamt], [Planungseinheit].CurrentMember, [MA-Pool Zuordnung].[Zuordnung (%)]) = 0 )
}
"Tag" element should match the Current Member from Year Dimension in the Cube.
Thanks for your help!
BR