Hi,
I have a BEx hierarchy on Profit Center, which results in 6 levels in the universe.
I have created very small queries in QaaWS 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