Hyperion Essbase (MOSC)

MOSC Banner

Hyperion ASO MDX 11.1.2.4

edited Nov 3, 2017 12:58AM in Hyperion Essbase (MOSC) 2 commentsAnswered

All,

We are using mdx query to generate extract from formula based members.

it is taking time.Can you please tell us HOW WE CAN OPTIMIZE IT.

SELECT

{[zREG_U] } ON  AXIS(0),
NON EMPTY
{Descendants ([zGBS_NP], [Book].Levels(1)),[ZGBS_Inp_]} ON  AXIS(1),
{[zGBS_AC]} ON  AXIS(2),
{[zSour]} ON  AXIS(3),
        {Descendants([2018-6],[Time].Levels(0)),Descendants([2018-5],[Time].Levels(0))}ON  AXIS(4),
{[USD],[INR]} ON  AXIS(5),
{[ZGBS Enty Strue]} ON  AXIS(6),
        {[Actual cON],[ConvActlMTD]} ON  AXIS(7)

FROM [ZTESTl.TEST] WHERE ([ZTrad]);

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