hi all,
need your help!!
I got two cubes, one with 6 dimensions, the other with 2.
The 'little' cube takes value from the bigger one.
I was able to do the feeders, but they take really long when recalculating values, because lot of dimension are at total element.
is there any way to avoid overfeeding the cube and make the calculation faster?
many thanks
Francesca
OVERFEEDING issue
-
- Community Contributor
- Posts: 247
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: OVERFEEDING issue
Read the Request for assistance guidelines
3) Try to make the question as specific as possible. A general question like "How do I write a rule?" is difficult to answer without copying out the whole of the user manual. A question like "I have a payroll cube which contains the following dimensions {details} and a general ledger cube which contains the following dimensions {details}, and although I've read through the Rules Guide I'm still not sure how to write a rule to give me average sales per employee" is far more likely to get the answer your need.
-
- MVP
- Posts: 3103
- 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: OVERFEEDING issue
Francesca,
Indeed, please provide details.
Also, what about the dimension sizes of the 2 dimensions in the smaller cube ?
In a small, dense, cube, I would not bother with feeding...
Indeed, please provide details.
Also, what about the dimension sizes of the 2 dimensions in the smaller cube ?
In a small, dense, cube, I would not bother with feeding...
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
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: OVERFEEDING issue
I'm going to take a stab in the dark and speculate that you aren't really talking about "feeders" since the calculation of feeders only happens when the rule is saved or you re-evaluate feeders in a TI process. I think what you really want to know is why does cube 2 take so long to open up and display values, correct? The answer is we can't really answer your question without more information but generally speaking, cube to cube rules do work but that doesn't always mean they are going to perform at the level you want. There is no way to "speed them up" short of making the source cube smaller. Unless the values "have" to be dynamic it may be better to transfer them from source to target as straight values via a TI process.
-
- Posts: 30
- Joined: Mon Oct 03, 2011 9:18 pm
- OLAP Product: TM1
- Version: 10.2.2fp6
- Excel Version: 2016
Re: OVERFEEDING issue
You could start with this page:
https://www.ibm.com/developerworks/data ... ge620.html
https://www.ibm.com/developerworks/data ... ge620.html