In SAP Analytics Cloud (SAC) Dashboard, we need to display dashboards for two separate company codes. We have created a public dimension for Profit Centers, and there are scenarios where the same Profit Center can exist in both company codes (1000 & 2000) with different descriptions.
However, SAC does not allow loading the same member ID twice with different descriptions.
@N1kh1l , could you please provide any inputs on how to achieve this?
You can create dimension comment that record textual descriptions of dimension member combinations. For your case, you can create 2 different dimension comment for the combination of same profit center and 2 company codes.
Alternatively, you can add the company code description as a property on the profit center. The property can be shown as a single column/bar in the table or chart.
You cannot duplicate member id's in dimension also you cannot have 2 different descriptions for the same member id in a dimension. You have to make the profit center members unique by either concatenating the controlling area or company code with the profit Centre. For e.g. 1000_PC1 and 2000_PC1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.