Display upper level hierarchy values in one row with leafs

[robert_tullius]

Hello,
 
I am facing a hierarchy problem that I was not able to solve yet. I need to display the levels of a hierarchy in some kind of flat view.
 
First of all: we are using Webi 4.0 SP5 Patch 7 with BICS interface on SAP BW.
 
Here's an example of I try to achieve:
 
Hierarchy:

Europe

   Germany

      Frankfurt

      Berlin

      Stuttgart

   France

      Paris

Asia

   China

      Bejing

      Hong-Kong

Desired result as table in a Webi report:

City         Continent

Frankfurt    Europe

Berlin       Europe

Stuttgart    Europe

Paris        Europe

Bejing       Asia

Hong-Kong    Asia

My problem: "City" and "Continent" are just linked via the hierarchy. "Previous" does not help, as the distance between the hierarchy leafs and level 1 is not constant. ".parent" is only available to change the context of a calculation.
 
My perfect solution would be "CITY.parent.parent"...

Is there any solution for this request?
 
Regards,
Robert

[james_batchelor2]

I have struggled with this as well.  It is unfortunate Webi doesn't have a Hierarchy Level n filter ability like Analysis for Office.  I ended up building individual tables filtered to the lowest level of each node and arranging them to look like one table. The users wanted the top nodes under the children and that row be a different color than the children rows.  These are individual tables filtered on the  parent node.  Problem there is any additions/changes made on the hierarchy will not come through to the report without manually adjust each tables' filters.  But it gave the ability to have custom formatting for each node level and bring in just the level needed for the one section.

jim