cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Hierarchy issue in Web intelligence report

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Priyank,

Right click on the table and select the option

"Avoid aggregation of duplicate rows"

Thanks,

Vivek

Former Member
0 Kudos

Hi Vivek,

I have tried to check “Avoid aggregation of duplicate rows”, but it does not resolve the issue and shows result as,

Level 1: XYZ

     Level 2 : ABC     10

     Level 2 : ABC     10

     Level 2 : BCD     20

     Level 2 : BCD     20

     Level 2 : XYZ      30

     Level 2 : XYZ      30

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks everyone,

Current issue is resolved after hierarchy update at backend.

manju_manjunatha
Participant
0 Kudos

Hi Bhayani,

In our Webi report we having almost same issue which your faced above. heirarchy update in backend means it's BI or some other place?

Thanks,

Manjunatha

Former Member
0 Kudos

Hey! Im also having the exact same problem!

What do you meant by changing the hierarchy?

Thank you!

Former Member
0 Kudos

Hi,

May I know the solution for this?.

I got the Hierarchies working in the Advanced OLAP Office Edition and BEx Analyzer but not in the Web Intelligence.

What are settings need to be done?.

Thanks
Raghu

Former Member
0 Kudos

Hi,

It is design behaviour. You have added the child nodes twice in the hierarchy under parent nodes with same name and hence it is aggregating the values.

Try applying filters or Create Separate hierarchy (or BEx Query) for below portion and display in separate table block.

Former Member
0 Kudos

Hi Ganesh,

But by creating seperate table user will not get hierarchical nevigation.

Do u think it is a bug in web intelligence as I am getting correct result in OLAP Analysis.

IngoH
Active Contributor
0 Kudos

Hello Priyank,

when you add additional characteristics into the table then the values for the key figures are being repeated and when you then create a simple summary, the values are becoming wrong.

Yes - Analysis OLAP and Analysis Office and Design Studio will show correct totals and subtotals as they have an understanding of what a hierarchy is.

regards

Ingo Hilgefort

Former Member
0 Kudos

Hi Ingo,

Thanks for reply,

Here I have attached both output bex query output and Webi report output,

In bex query output i have highlighted rows which are getting aggregated in webi report and showing under first level of hierarchy. When you check webi report output you can observer only parent nodes are coming for the values but child member are aggregating in first level.

Please check and let me know is this the expected behavior in Webi reports for bex hierarchy?

Note: To identify the difference i have checked "Avoid aggregation of duplicate rows".

Thanks in Advance,

former_member207878
Active Participant
0 Kudos

Can you please try to achieve your functionality through Outline feature, if it will help you to resolve your problem:

Former Member
0 Kudos

Thanks Sahil for reply,

Outline feature is for section only, We can not use outline feature for bex hierarchy in table.

Regards,

Priyank Bhayani

Former Member
0 Kudos

Hi,

Are you using the BW hierarchy or BEx Structure?

If you use BEx Structure (Hierarchy), then:

  • Add dummy child nodes for the Parent Node 'Current Liability' with similar name at the BEx Level,
  • Write formulas in webi side to pick up the value from another Parent node (Unassigned items) and display for the dummy nodes coming under the Parent nodes 'Current Liability'.

You can check the below blog for formula to pick up the value of another row:

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2012/11/26/how-do-you-pick-value-...

If you use BW Hierarchy, then you need to post value (assign 0) at the backend to the dummy nodes so that it will appear in the WebI tool.

Please note: BEx Structure is static and BW Hierarchy is dynamic. These hierarchies has its own advantages and disadvantages.

Hope it helps!

Thanks.

IngoH
Active Contributor
0 Kudos

Hi,

it looks like you are missing a level of the hierarchy in the Web Intelligence report.

When you created the report did you configure the report to select all levels of the hierarchy in the Web Intelligence query panel ?

regards

Ingo Hilgefort, SAP

Former Member
0 Kudos

Hi,

I do select all member of the hierarchy, Find attached screen shot with the option which i have selected.

Regards,

Priyank Bhayani