Hyperion ASO MDX 11.1.2.4
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]);