MDX query output from Essbase connection gives additional fields

[mithundev]

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