Calculation Issue in Business Rule

Summary:

Content (required):

Hi Experts,

In our implementation, we are having 9 dimensions as Years, POV, Time Periods, Version, Scenario, Account, Product, Cost Centre, Group. In which we need to copy some data entered in the below combination to copy across descendant values specified in the rule FIX.

Example:

Value is in the combination of

Group -L000,

Cost Centre - C000,

Product - P000,

Time Periods - Jan,

POV - Monthly,

Years - FY21,

Account - AWDR 1 Month - Benchmark,

Version - Draft 1,

Scenario - Budget,

The rule is written as follows,

FIX(FY21,Budget,"Draft 1",@Relative("All Cost Centre",0),@Relative("Region 9",0),@Relative("All Products"),Monthly,@IDESCENDANTS("Time Periods",0))