Derivation in SAP Analytics Cloud
In this blog post, I will introduce how to use Dimension Combination Rule to derive dimension member. The feature has been released in version 2020.07. For general introduction about Dimension Combination Rule, please refer to Dimension Combination Rule in SAP Analytics Cloud
There is 1:1 mapping between dimensions, such as cost center is always mapped to a profit center. When user inputs data on one dimension, the member of another dimension can be derived automatically. This member derivation could be achieved via Dimension Combination Rule.
Assuming in the planning model, there are Cost Center dimension and Profit Center dimension. In order to have derivation from cost center to profit center, firstly of all, user needs to define 1:1 member combinations between Cost Center and Profit Center dimension.
How to define Dimension Combination Rule?
Combination rule needs to be defined as 1:1 member mapping.
Open the Cost Center dimension and create a new custom property named “ProfitCenter”(it’s not required to name property as ProfitCenter. Any name is ok). And then maintain the mapped profit center for each cost center in “ProfitCenter” property. Each cost center member has only one value in “ProfitCenter” property.
After saving the master data, go to Rule tab of the model. Create a new Rule, select Cost Center as Reference dimension. In Matched dimension setting, select “ProfitCenter” from the attribute list and match it to Profit Center dimension. Then, save the rule.
Member Derivation in Table
In table, add Cost Center dimension into row or column but do not add Profit Center dimension into row or column. For Profit Center dimension, please exclude unassigned member in table filter. For unassigned member behavior, please also refer to Dimension Combination Rule in SAP Analytics Cloud
Then, enter data into one Cost Center. After enter the data, the PC2 of Profit Center dimension will be auto derived.
Note: Data action and other advanced planning features don’t learn dimension combination rule yet, hence derivation is not support in advanced planning features.
From above user case, end user could reach the derivation effect with dimension combination rule function.