To display master data for profit Center Hierarcchy

[former_member546611]

Hello,

We currently have a BO report created on bex query to extract the entire Profit center hierarchy as it from ECC system.

We observe that this report have few nodes of hierarchy missing. We observed that, in the underlying bex,only posted values for navigation is selected. And these missing nodes have no transaction data posted against it.

Now, If a make a copy of this bex query and change this option from only posted values for navigation to values only in master data table, i am assuming these missing nodes will appear. But will change affect the original bex query?As i do not want data with 0 values appearing hence this setting is made in orginal bex.

Thanks,

Hetal

[kohesco · Accepted solution]

Hi

to have the full hierarchy displaying in BO, you could check my blog:

https://blogs.sap.com/2016/03/29/merge-bw-hierarchies-in-webi-reports-new-gl-reporting-things-to-kno...

greetings

Koen

[cornelia_lezoch]

Hi Hetal,

the setting for the "Access Type for result values" is set in each query and it effects only the one query where it is set.

regards

Cornelia