Tracing cube load after unload

Post Reply
kenship
Posts: 111
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Tracing cube load after unload

Post by kenship » Thu Jun 07, 2018 12:58 pm

Hi,

We have a few cubes which we unload manually and have the Demand Load status updated to "Yes" in Cube Properties.

Yet some of them are later started and we don't have any idea why.

We want to know whether it is started by a user or something else, is there any way that we can find the information?

Thanks.

Kenneth

User avatar
tomok
MVP
Posts: 2483
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: Tracing cube load after unload

Post by tomok » Thu Jun 07, 2018 1:42 pm

Have you looked in the tm1server.log file?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Edward Stuart
Community Contributor
Posts: 220
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Tracing cube load after unload

Post by Edward Stuart » Thu Jun 07, 2018 1:43 pm

Do these cubes have Feeders?

IBM Support Note: DemandLoad property
The Load on Demand feature only works if the cube has no feeders.
If the cube has feeders, it will be loaded on server start,
no matter if its Load on Demand property is set.
If the cube has feeders, rules or dependencies, Load on Demand property is ignored.

kenship
Posts: 111
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Re: Tracing cube load after unload

Post by kenship » Thu Jun 07, 2018 2:13 pm

Thanks for the answers.

For the log, does it mean I have to make sure cube logging is on?

For the feeder, I checked and there's no feeder associated.

Kenneth

kenship
Posts: 111
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Re: Tracing cube load after unload

Post by kenship » Thu Jun 07, 2018 2:41 pm

I'll start looking at dependency and rules to see if I can pinpoint the source.

Thanks again!

Wim Gielis
MVP
Posts: 1808
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Tracing cube load after unload

Post by Wim Gielis » Thu Jun 07, 2018 3:15 pm

kenship wrote:
Thu Jun 07, 2018 2:13 pm
Thanks for the answers.

For the log, does it mean I have to make sure cube logging is on?

For the feeder, I checked and there's no feeder associated.

Kenneth
No it's the TM1 server message log that was suggested.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

kenship
Posts: 111
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Re: Tracing cube load after unload

Post by kenship » Thu Jun 07, 2018 3:28 pm

Wim Gielis wrote:
Thu Jun 07, 2018 3:15 pm
No it's the TM1 server message log that was suggested.
Hi Wim,

I checked the server log ("TM1server.log") and I realize one of the cubes I'm checking has feeders, I'll disable that. Thanks!

Kenneth

Post Reply