Hello,
I have a large project with multiple cubes (~20). When I edit a rule in one of main cubes, it takes 15minutes to save a rule. What's the best way to find long loading feeders? I want to comment out these feeders on my test environment to make development faster.
Longest saving/loading feeders
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Longest saving/loading feeders
That would have to be switching them all off and then back on one at a time and measuring the resulting load times.What's the best way to find long loading feeders?

You can also look into persistent feeders to speed up your cube loading process.
Edit: Before anyone points out - yes, you need to unload the cube after switching off a feeder statement.
Last edited by qml on Thu Sep 01, 2011 2:24 pm, edited 1 time in total.
Kamil Arendt
-
- 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: Longest saving/loading feeders
There is a direct correlation between how many cells are being fed and how long it takes for feeders to process (duh!) so look for 1) the elements that contain the most data and turn off whatever they feed and 2) look for instances where you are feeding consolidated nodes (as this feeds all the children. Basically, there is no shortcut for knowing exactly what your feeders are doing and turn them off when desired because just turning them off without understanding what they are doing is going to lead to incorrect results and likely cause development problems and delays.
-
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: Longest saving/loading feeders
Just a note that once a cell is fed, it is permanently fed - so you will need to comment out your feeders and then bounce the server before testing.
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Longest saving/loading feeders
Nah, it's enough to unload the cube.Christopher Kernahan wrote:Just a note that once a cell is fed, it is permanently fed - so you will need to comment out your feeders and then bounce the server before testing.

Kamil Arendt
-
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: Longest saving/loading feeders
Agree with qml on unloading the cubes.
Might not even be necessary though to simply find the lines that need a long time to save/compile/process.
Just adding to what has been said already about what takes a long time when compiling rules.
Conditional Feeders (with complex conditions) and Feeders that use a large consolidation (without really overfeeding the target) on the left side can take a long time when saving the rule, as well.
Might not even be necessary though to simply find the lines that need a long time to save/compile/process.
Just adding to what has been said already about what takes a long time when compiling rules.
Conditional Feeders (with complex conditions) and Feeders that use a large consolidation (without really overfeeding the target) on the left side can take a long time when saving the rule, as well.
- Steve Rowe
- Site Admin
- Posts: 2464
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Longest saving/loading feeders
The other big factor in feeder time is the amount of data in the cube.
You are probably better off developing with a full set of rules and a subset of the live data rather than subset of the rules and all the data?
Cheers,
You are probably better off developing with a full set of rules and a subset of the live data rather than subset of the rules and all the data?
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 42
- Joined: Wed Nov 10, 2010 12:35 pm
- OLAP Product: Cognos 8 BI
- Version: 9.5.1
- Excel Version: Excel 2007
Re: Longest saving/loading feeders
There are a lot rules and small amount of data (when I zip all Data folder during nightly backup, zip file weights 11MB). So, I chose to delete all rules on some cubes which are unrelated to my current cube i'm fixing.Steve Rowe wrote:The other big factor in feeder time is the amount of data in the cube.
You are probably better off developing with a full set of rules and a subset of the live data rather than subset of the rules and all the data?
Cheers,
Basically, I have to skim through all feeders and disable longest loading ones, there is no easy way. Thank you everyone for your input.