Issue with Pulling data from Sales Cube for AR Cube
Posted: Fri Feb 16, 2018 2:07 pm
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,
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,