Call hierarchy issue in APD

Hi BW Gurus,

we have a requirement in which we need to provide CSV files based on query in APD

When checked using each query I am getting a short dump stating u201CCall hierarchy issueu201D(hierarchies are used in query)

And when I remove the hierarchy in query u2026I am able to execute the APDu2026and generate the fileu2026but some key figures are restricted with hierarchies which should not be removedu2026..is there any concern in using hierarchies of Query in APDu2026is there any other alternative

Please let me know

Regards,

Srivatsava