Help with a Maxl Query
Hello,
I am having difficulty modifying a maxl query, and hope that someone can help me. I have included the entire contents of the mxl file below, but the line I want to modify is this one:
CrossJoin(Descendants([Financial_Statement_Detail],[Financial_Statement_Detail].Levels(0)),
I want to add the level zero members of the Non_Agg_IS_Detail, and am unable to get this to work.
Thank you, Kevin
POV "
Crossjoin({[<SOURCESCEN>]},
Crossjoin({[<SOURCEVERS>]},
Crossjoin({[<SOURCEYEAR>]},
Crossjoin(Descendants([ICP], [ICP].Levels(0)),
Crossjoin({<PERIODS>},
Crossjoin({[No_Type]},
Crossjoin(Descendants([Total_Source], [Source].Levels(0)),
Crossjoin(Descendants([<ENTITY>],[Entity].Levels(0)),
Crossjoin(Descendants([Total_Department],[Department].Levels(0)),