Skip to Content
0

BEx Analyzer, Product Hierarchy ROOT node repeats multiple times

Jun 15, 2017 at 08:26 PM

202

avatar image

Hi Experts,

We have a BEx report which provides information about Contract, Master Contract, Ship-To-Party, Product Hierarchy, Material, Profit Center, Contract Start & End dates in Rows and Net Value (KF) in Columns. When we execute the report (BEx Analyzer), the total net value is getting doubled due to Product Hierarchy ROOT node repetition.

We are on BW7.3 SP09, SAP GUI 7.40 (release 7400.3.8.1123).

Example: let's say, if we have 5 products (Materials) in the executed query result then the Prod.Hierarchy ROOT node (node level 1) repeats 5 times, Sub node 107 (node level 2) repeats 5 times and then displays child nodes (low level). But this doesnt make any sense for me because unless we rollup the query result at top node (ROOT Node) level we dont get correct Net value otherwise Net value will be doubled up (when drill down on the Prod.Hierarchy).

I hope you guys understand the issue, I really appreciate your expertise help. Let me know how to get rid of these repetition of nodes in the query result.

Please see attached BEx Analyzer result.

Thanks,

Venkat

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Anand Kumar Jun 16, 2017 at 06:07 AM
0

Hi,

what is the result if you run report on web analyzer or Analysis for office?

Regrads,

Anand Kumar

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Anand for the quick response.

I am expecting 125k which displays in the query result attachment (first).

Thanks,

Venkat

0
Koen Hesters Jun 20, 2017 at 09:21 AM
0

Hi,

the hierarchy is repeated because of the use of other dimensions in your query. So it is normal behavior. You can set the whole dimension-row as Hierarchy in query designer you can set in the properties of the rows to show as hierarchy and you can set at which level it should be by default collapsed; note you have to set the result rows of your infoobject as show to see the keyfigure in the hierarchy

Share
10 |10000 characters needed characters left characters exceeded
Bhavin Vyas Jun 16, 2017 at 10:12 AM
0

Have a look at this thread,

https://archive.sap.com/discussions/thread/3373152

Hope it helps!

Thanks,

Bhavin Vyas

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Bhavin,

I had gone through this link and tried but it doesnt work for my requirement. My requirement is very simple I just want to get rid of repeated root nodes from query result.

I am still not able to conclude that is it SAP BW BEx standard hierarchy behavior or some bug. Let me know if anyone has an idea/solution for this requirement.

Thanks,

Venkat

0
Venkateswarlu Boorugadda

Check out the material in the result, remove it and it will not happen, this is standard behavior, check my answer on 20th of June for a possible solution

0