Issue with Pulling data from Sales Cube for AR Cube

Post Reply
Analytics123
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

Issue with Pulling data from Sales Cube for AR Cube

Post by 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
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

Re: Issue with Pulling data from Sales Cube for AR Cube

Post by Analytics123 »

Now I cannot use ELPAR in my rule to pass the value based on condition since i have multiple Hierarchies .
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Issue with Pulling data from Sales Cube for AR Cube

Post by Wim Gielis »

Analytics123 wrote: Fri Feb 16, 2018 2:57 pm 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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Analytics123
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

Re: Issue with Pulling data from Sales Cube for AR Cube

Post by 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 .
Post Reply