Hyperion Essbase (MOSC)

MOSC Banner

Help with a Maxl Query

edited Aug 26, 2019 9:22AM in Hyperion Essbase (MOSC) 4 commentsAnswered ✓

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)),

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center