Longest saving/loading feeders

Post Reply
kudzis
Posts: 42
Joined: Wed Nov 10, 2010 12:35 pm
OLAP Product: Cognos 8 BI
Version: 9.5.1
Excel Version: Excel 2007

Longest saving/loading feeders

Post by kudzis »

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.
User avatar
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

Post by qml »

What's the best way to find long 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. :mrgreen:

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
tomok
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

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Christopher Kernahan
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

Post by Christopher Kernahan »

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.
User avatar
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

Post by qml »

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.
Nah, it's enough to unload the cube. :lol:
Kamil Arendt
Gregor Koch
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

Post by Gregor Koch »

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.
User avatar
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

Post by Steve Rowe »

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,
Technical Director
www.infocat.co.uk
kudzis
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

Post by kudzis »

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,
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.

Basically, I have to skim through all feeders and disable longest loading ones, there is no easy way. Thank you everyone for your input.
Post Reply