How do I create an additional hierarchy in the Account dimension? We already have H1 (PARENTH1). We would like step-by-step directions and what part of the BCP application to perform these steps. I added, below, the dimension columns and attached the Maintain Dimension Property report.
to add a hierarchy just add 2 properties on the dimension, PARENTH2 and FORMULAH2 copying the type and length of the ... H1 and fill the second hierarchy following the rules given by Tim in http://scn.sap.com/message/7593996#7593996 and by me in http://scn.sap.com/thread/3189203 better to ignore the threads on NW because these can have some differences.
I added two new properties: PARENTH2 and FORMULAH2. I then changed the name of FORMULAH to FORMULAH1. When I processed the query I get this error message: "The number of parentH columns cannot be different than the number of hierarchies."
Perfect! I now understand that after adding the new Hierarchy properties, the H2 rollup members will have to be built-out and added to the new hierarchy. The dimension successfully processed.
Thanks again for the excellent BPC guidance and advice. It's appreciated.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.