Skip to Content
0
Former Member
Oct 25, 2012 at 11:49 AM

Hierarchies in Bex (Fin Statement Item)

42 Views

Hi

My Financial Statement Item is configured correctly into a hierarchy in ECC.

When I create my BEx query - this works perfectly and running the query in Analyzer - I get my drill down effect for;

Balance Sheet

Income Statement

And I can drill down correctly.

What I would like to do is to isolate just my Income Statement.

I created a structure in Bex, added a new selection to the structure, and bought in my Financial Statement Item into the selection. Then I filtered by Income Statement.

When I run the query - All I get is the Total Income Statement value - and I cant drill down to the lower nodes - it does not allow.

In my query when I go to Drill down it does not allow me to drill down.

Is there perhaps a smarter way to do this, I do not want the Balance sheet items to come through at all.

Thanks