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,
Issue with Pulling data from Sales Cube for AR Cube
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
-
- 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
Now I cannot use ELPAR in my rule to pass the value based on condition since i have multiple Hierarchies .
-
- MVP
- Posts: 3117
- 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
Typically you would use an attribute to store the desired parent. This way you avoid the problem of Elpar with multiple hierarchies.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 .
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
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
-
- 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
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 .
DB('Sales',!Customers,!months,'Full Revenue');
If Attribute value is true then I need to pass all the children of the selected customer .