Analysis for office - Show Hierarchy Level 2 only

[former_member234729]

Hello

When I try to choose a specific Hierarchy only ( Hierarchy 2 ) I can't do it. On the screenshot you can see the Hierarchy-level-3 is flagged and greyed out.

This is unuseful because I'd like to specifically flag ONLY the Hierarchy-level-2.

Whats the reason behind the greyed Hierarchy-level-3?

[TammyPowlas]

Hello Christian - what is your data source? BW/BEx query? Which version/SP of Analysis Office are you using?

[former_member234729]

Hello Tammy

The data source is a BW Query and we are currently using the Analysis for Office Verison 2.2.1.53549

[former_member1224587]

Hi - Did you get any solution for above problem, we are in AFO 2.8 version with BEx and still have this issue

[former_member811579]

Hello,

Did you find any solution ?

Thank you