Skip to Content
0
Aug 31, 2017 at 04:17 PM

Fixed Hierarchy node in dimension

94 Views

Hello,

I have a couple of dimensions in BPC for which I am not loading hierarchy because of unavailability of hierarchy in BW source

For those dimensions in Parenth1 I used to update total node to facilitate reporting at a total level as below

hypothetical e.g

ID ... Desc ... Parenth1

AB ... ab ...TOTAL_MATERIAL

BC ... bc ...TOTAL_MATERIAL

DE ... de ... TOTAL_MATERIAL

etc ...

I would like to automate populating the TOTAL_MATERIAL node instead of manually updating the Parenth1 node for each new material once the dimension is loaded through Text and attribute package

any ideas?