Issue with Pulling data from Sales Cube for AR Cube

[Analytics123]

Hi ,

I have an AR cube which has a customers dimension like

All Region -> Region -> Agency->Rep-> Customers .

Now there is a rule in the cube which takes the customer element and pulls data from sales cube .

Now there was a requirement to see customers by collection specialist , so I created an alternate hierarchy in Customers dimension to include
AllCOllectionSpecialist -> CollectionSpecialist -> Customers

Now the issue I am having is the sales cube doesnt have this grouping , so the value for collectiona specialist is returned as zero and all the customer below it has has the values .

I cannot bring in the alternate hierarchy in sales cube .

Is there a way I can tell to overwrite the calculation for the sales column to aggregate its children total , when its parent is All collection specialist or it itself is All Collectionspecialist .


Thanks,

[Analytics123]

Now I cannot use ELPAR in my rule to pass the value based on condition since i have multiple Hierarchies .

[Wim Gielis]

Now I cannot use ELPAR in my rule to pass the value based on condition since i have multiple Hierarchies .

Typically you would use an attribute to store the desired parent. This way you avoid the problem of Elpar with multiple hierarchies.

[Analytics123]

Okay thanks , I will use Attributes and how doI pass the elements all children in the rule .
DB('Sales',!Customers,!months,'Full Revenue');

If Attribute value is true then I need to pass all the children of the selected customer .