Hi Folks.
We have a TM1 Model which when started takes around 35 minutes to come up, however on looking at the log files it appears one cube within the Model takes 20 minutes on its own.
The Cube is questions holds summarised data which is fed from a lower level cube alongside data from some other cube. Data from this cube is also distributed to some other cubes. I have had a look at the rules/feeders and cannot see anything in particular which would cause this.
My question is: would the issue specfically be related to this cubes own rule file or would any cubes that feed this cube or is fed from this cube also be an issue?
Thanks in advance.
Cube Load Time
-
- Community Contributor
- Posts: 110
- Joined: Thu Aug 26, 2010 7:41 am
- OLAP Product: TM1, PA
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: North West England
Cube Load Time
Always Open to Opportunities
-
- MVP
- Posts: 2836
- 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: Cube Load Time
You need to look at the feeders in ALL the related cubes. You haven't provided any information about the size of your model (and the number of calcs) so I have no idea if 30 minutes for loading is reasonable. Apparently you think not since you are looking for a fix. I have had models that take that long to feed so it's not necessarily a problem with your feeders, it all depends on the model structure and size. One tip: if you are using consolidation nodes to feed then those have to be evaluated before the feed, which can make the feeding process take longer than just feeding from a pure value.