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.