We've custom build hierarchy for Account. We're getting the values posted for each node in the hierarchy in the flat file. In hierarchies, nodes always display the aggregated values of the lower-level nodes and leaves. I know there is a setting by which we can display the values of posted node. With this option, an additional leaf is inserted that has the same name as the node. This leaf displays the value posted to the node. Higher level node still shows the aggregated value.
My requirement is to display only values for posted node and no aggregation should happen at node level as I'm getting values in flat file for each node level. Is that a option available in BEx?
Is there any other design approach? Requirement is to display the Account structure in hierarchy format and display incoming value at each node level (no aggregation). We're on SAP BI 7.4.