Skip to Content
Product Information

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

User Case

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.

4 Comments
You must be Logged on to comment or reply to a post.
  • Which ‘advanced’ planning features are not supported?

    Can users simply copy paste values from one CC to another CC?

    When will limitations be handled, so this can be useful and reliable for real life planning use cases?

    • Hi Jef,

      Currently, structure allocation, VDT calculation, data actions will not learn Dimension Combination Rule when generate data. Data with invalid combination will also be generated in the private version.

      For Copy/Paste, if copy data from one CC (base) to another CC (base), it will NOT learn Dimension Combination Rule, either.

      While, these data with invalid combination will be marked with invalid warning icon in table, which is released in version 2020.11. Also, when click Publish data, these invalid data will be reverted.

      For the timeline to remove these limitation, currently, it is still under investigation. There is no specific timeline I can provided right now.

      Best regards.

      Kilar

      • Thanks Kilar, that’s really helpful to realize. Honestly, I don’t see how we can give this to any end-users, because they will use copy-paste at some point and data may be lost when publishing.