Skip to Content
0
Former Member
Feb 10, 2014 at 11:00 AM

Bex Hierarchy issue in Web intelligence report

183 Views

Hello,

I am facing strange issue in Bex hierarchy used in Web intelligence report,

In Hierarchical table in webi, Same values are aggregating although they are from different level of hierarchy.

Version : SAP BusinessObjects 4.1 SP2

For Example:

Actual hierarchy in Bex

Level 1: XYZ

Level 2 : ABC 10

Level 2 : BCD 20

Level 2 : XYZ 30

Level 1: PQR

Level 2 : URT 34

Level 2 : RTE 25

Level 2 : ERT 24

Level 1: XYZ

Level 2 : ABC 10

Level 2 : BCD 20

Level 2 : XYZ 30

Level 2 : LMN 24

Level 2 : APO 24

But when I create hierarchy table in Webi it aggregates same value from different level and shows as follows,

Level 1: XYZ

Level 2 : ABC 20

Level 2 : BCD 40

Level 2 : XYZ 60

Level 1: PQR

Level 2 : URT 34

Level 2 : RTE 25

Level 2 : ERT 24

Level 1: XYZ

Level 2 : LMN 24

Level 2 : APO 24

In above you can see values for ABC, BCD, XYZ is aggregated although they are from different level.

If anyone have faced this kind of issue then please help me if you have any solution to this.

Thanks in Advance.