Skip to Content
0
Nov 25, 2011 at 11:02 AM

Hierarchy, Filter, BEx

30 Views

Hello! Help me please.

There is an issue with building hierarchy in BW and the report designing in BEX Analyzer. (The general scheme is simplified).

There is manually created hierarchy for one base InfoObject (Type of costs) which has duplicate nodes. The hierarchy does not depend on time.

Виды затрат, Объект показатель.

There is an ODS with basic information, which has fields such as:Type of costs, Object, Price

First issue: I need to build a report which will display the entire hierarchy (field 0HIER_NODE), even if he has no child node

(Type of costs).

I need to do filtration on field - Object. The difficulty lies in the fact that the repeating nodes can be filtered by different objects in the same report. Here is an example of what should happen in BEx:

Type of costs Object Price

1 Type | | 5000

10000001 | А | 5000

2 Type | | 0 no node(s)

3 Type | | 0

10000002 | B | 0 (Filter by "B")

Thanks.