TI script lags at PLOLOG

Post Reply
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

TI script lags at PLOLOG

Post by ioscat »

What may be a reason for TI process not complete? It doesn't stops, no errors, everything is like it is making something but not going to ever finish. I suppose VIEWZEROOUT is responsible, cos if i resave "zero" view - everything is ok.
asutcliffe
Regular Participant
Posts: 164
Joined: Tue May 04, 2010 10:49 am
OLAP Product: Cognos TM1
Version: 9.4.1 - 10.1
Excel Version: 2003 and 2007

Re: TI script lags at PLOLOG

Post by asutcliffe »

ioscat wrote:What may be a reason for TI process not complete? It doesn't stops, no errors, everything is like it is making something but not going to ever finish.
Are you sure it will never finish or is it just taking a really long time? Have you looked monitored it using TM1Top? In any case, why don't you just post your code?
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TI script lags at PLOLOG

Post by Wim Gielis »

Did you try to AsciiOuput some helpful texts at various parts in the Prolog?
(Then you know that at least these commands were reached yes or no).
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: TI script lags at PLOLOG

Post by ioscat »

Code: Select all

#****Begin: Generated Statements***
OldCubeLogChanges = CUBEGETLOGCHANGES('rep.result.FinancialResult');
CUBESETLOGCHANGES('rep.result.FinancialResult', 0);
VIEWZEROOUT('rep.result.FinancialResult','ZeroOut');
#****End: Generated Statements****
nothing special. can view be corrupted?
normally prolog finishes less than for a second. i gave process to ran for a couple of minutes and there were no progress
Last edited by ioscat on Mon Oct 08, 2012 2:38 pm, edited 1 time in total.
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TI script lags at PLOLOG

Post by Wim Gielis »

Can you (manually) export that view to Text data?
(Right click the cube name for that option).

I never used dots in a cube name. Do you have any reason to do so?
Why no underscore for example? Or judicious use of uppercase and lowercase letters?
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
Post Reply