Hierarchy view in Analysis similar to Bex Analyzer

[former_member234729]

Hello,

In Analysis for Excel I get following Hierarchy view:

My goal is to get the empty rows filled the same way as the BexAnalyzer:

Is there any configuration in Analysis where I can select this kind of view?

[Loed]

Hi,

I'm not sure about analysis but the views in your analyzer depends on the setting of your QUERY. You can UNCHECK the "show same values" (something like that) setting in your query designer.

Regards,

Loed