SAC Hierarchy Derivation from another Public Dimension

[SAC_Newbie]

Dear all,

I am currently struggling with a seemingly simple issue and I am not the desired solution. I have created a planning model with multiple dimensions. Two of them are important for my example. Profit Center (including a profit center hierarchy) and Product (including a property which should be linked to the Profit Center).

Product	Profit Center
A	PCA
B	PCA

Profit Center	Hierarchy
PCA	PC
PCB	PC

Please see above dimensions for simplification.

Now I have created a planning table with a few columns, including the profit center hierarchy and the product. In this table the profit center hierarchy and product are shown in two different columns. But I would like to include the product into the profit center hierarchy as a leave element, as each product does belong to a profit center. 

Is it possible to derive the hierarchy for the property "Profit Center" from the dimension "Profit Center" by linking them in any way (similar to BW and the usage of infoobjects).

Of course one option would be to delete the profit center dimension and create a hierarchy on top of the product. But this model is also used to do planning on profit center level, which is why the profit center dimenson is needed. Would there be any workarounds?

Best

[N1kh1l · Accepted solution]

@SAC_Newbie 

If product and PC are separate dimensions they will always appear as separate column. If you want product as leaf member below PC, PC needs to be part of hierarchy structure as parent within product dimension itself. PC dimension then becomes optional if you still intend to keep it for data slicing.

Nikhil

[William_Yu · Accepted solution]

Right, I would suggest to create PC and PC parent nodes a property of product dimension, and create level base hierarchy on product dimension. You can still keep PC dimension for planning

[SAC_Newbie · Accepted solution]

Dear both, thank you very much for your reply! I agree. Of course it does make sense to have this hierarchy included in the product dimension. But I see a catch here. I have to do planning on both product and profit center dimension. Unfortunately if include the profit center hierarchy into the product dimension and remove the profit center dimension from the table, it will not plan on the profit center attributes from the dimension. Instead profit center will be "#". Is there a way to mitigiate this. Basically show the profit center from the product dimension, but while planning write back the data on the profit center dimension attributes?

[N1kh1l · Accepted solution]

You can still keep PC as dimension and use SAC data validation for PC using PC attribute of the product dimension to auto populate PC while planning using product PC attribute.

[SAC_Newbie · Accepted solution]

Thank you! Would I have to show the pc dimension in the planning table? Or will the validation rule ensure, that the right pc is considered without the dimension being visible in the table? Thank you so much!

[N1kh1l · Accepted solution]

You dont need to have PC in table validation rule should do the trick. Just see the SAP help section for validation rule and you will get a fair idea of how it works.

[SAC_Newbie · Accepted solution]

Dear Nikhil, I have checked your comment about the automatic distribution. It does not work. My data gets written to PC = #. I have created the rule for validation and although in the rule I see the correct assignment, once i remove the Profit Center from the planning table, all data gets mapped to #. Is there something I am not doing well?

[N1kh1l · Accepted solution]

In the filter section of your table select PC member # and set it to exclude. If dimension has # member thats were values go by default