Skip to Content
0
Nov 30, 2009 at 04:50 PM

Hierarchy level value repeats in lower level

40 Views

Hi,

I have a BEx hierarchy on Profit Center, which results in 6 levels in the universe.

I have created very small queries in WebI with always the same structure, i.e.

Select L01 ProfitCenter where L00 ProfitCenter = <Value>

Select L02 ProfitCenter where L01 ProfitCenter = <Value>

Select L03 ProfitCenter where L02 ProfitCenter = <Value>

...

Strange thing is that, when I look to the resultset of such a query, the <Value> used in the where-clause is always repeated in the resultset from the level below.

E.g. Select L01 ProfitCenter where L00 ProfitCenter = "Area SE" => the resultset returns two values:

Area SE

Country Sweden

Select L02 ProfitCenter where L01 ProfitCenter = "Country Sweden" => the resultset returns two values:

Country Sweden

Plant Sweden

In the SAP Hierarchy, Area SE has only one level underneath: Country Sweden.

How can I avoid this behaviour? It is really annoying.

Lieven