Hi There,
I am trying to fetch data from Essbase to Qlik using MDX query , but the output file generates lot many extra fields based on the level of hierarchy .
For example if put something like
{{Descendants ([Account_parent], 1, Leaves)}} ON ROWS on the select query, it gives the result like
Account.Level(1),Account.Level1(2),Account.Level(3) and then the columns
Can you please advise if there a way we can filter out these level fields and just give the descendants of the selected parent in one field