Search found 481 matches

by macsir
Sun Feb 18, 2018 9:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 1
Views: 124

Re: Rules Passing children

be more specific?
by macsir
Mon Feb 12, 2018 11:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get the Admin Host of TM1 server
Replies: 7
Views: 1102

Re: Get the Admin Host of TM1 server

I just put the admin host manually into a central control cube where all processes can refer to as it really doesn't change.
by macsir
Fri Feb 09, 2018 2:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Feeder
Replies: 6
Views: 320

Re: String Feeder

Code: Select all

['Measure'] = S: 'READ' ;
by macsir
Wed Feb 07, 2018 8:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DB load time 10.2.2 vs Planning Analytics
Replies: 1
Views: 101

Re: DB load time 10.2.2 vs Planning Analytics

It could be many factors, such as different parameter config, changed proccesses or different rules. You need to check your log to find out which one is the slowest compared to v10 and go from there to trace the root cause.
by macsir
Wed Jan 31, 2018 11:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Table on TM1
Replies: 3
Views: 248

Re: Table on TM1

Table is just two-dimension cube in TM1. Yes, you can.
by macsir
Fri Jan 19, 2018 5:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Alternative Hierarchies to calc stock balances
Replies: 7
Views: 299

Re: Using Alternative Hierarchies to calc stock balances

Glad to see it is working in old way. To be honest, I have never used CELLVALUEN in any of my projects so far. Need to learn it and figure out the correct way it works.
by macsir
Fri Jan 19, 2018 1:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Alternative Hierarchies to calc stock balances
Replies: 7
Views: 299

Re: Using Alternative Hierarchies to calc stock balances

What if you use DB function rather than the new one and trace it?
by macsir
Wed Jan 17, 2018 1:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alias update and stargate view
Replies: 5
Views: 295

Re: Alias update and stargate view

Can you check if there is lock contention which is causing the delay?
by macsir
Tue Jan 16, 2018 5:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running a new blank unsaved TI... it executes a different TI
Replies: 9
Views: 320

Re: Running a new blank unsaved TI... it executes a different TI

Better to provide some log info and tm1top snapshots to prove your guessing.
If you create a new process and run it right away, TM1 will give you Error running the process issue immediately and won't trigger any other process to run.
by macsir
Tue Jan 16, 2018 5:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Unable to fetch data" in PAW book
Replies: 4
Views: 148

Re: "Unable to fetch data" in PAW book

Have you setup session limit for that user? You need to use 0 which is unlimited, otherwise it will reach the upper limit quickly. :D
by macsir
Fri Jan 12, 2018 4:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 424

Re: Feeders Not Fed

Try this
['Daily H0 - Accumulated' ] =>[{'MTD H0','RPD','PTQ'}];
by macsir
Thu Jan 11, 2018 10:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Snapshot feasibility in TM1
Replies: 2
Views: 211

Re: Snapshot feasibility in TM1

What do you mean specifically by sapshot? If it is just backup, then snapshot all these tm1 web report into static values in excel and do whatever you want or export cube data relating to these report into flat file or a snapshot version in the cube.
by macsir
Wed Jan 10, 2018 10:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI in PA 2.0.3 with password file
Replies: 10
Views: 472

Re: TM1RunTI in PA 2.0.3 with password file

ascheevel wrote:
Wed Jan 10, 2018 12:25 pm
Macsir, got it; our 10.2.2 environments are gone so not able to test that for you. Pictured below are file details for runti, it's 11.1.4.3 I guess.
Thanks, buddy. Yes, looks like mine is older than yours and IBM did fix the bug in your version.
by macsir
Wed Jan 10, 2018 10:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI in PA 2.0.3 with password file
Replies: 10
Views: 472

Re: TM1RunTI in PA 2.0.3 with password file

I thought I can copy tm1runti.exe from C:\Program Files\IBM\cognos\tm1_64\bin64 on TM1 10.2.2 server and put it into PA2.0.3 environment to make it work. After testing, it apparently doesn't work. I didn't do the upgrade on existing 10.2.2 but just a new fresh installation of PA2.0.3. A pretty mass...
by macsir
Wed Jan 10, 2018 1:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI in PA 2.0.3 with password file
Replies: 10
Views: 472

Re: TM1RunTI in PA 2.0.3 with password file

Hi, ascheevel Sorry for a bit confusing. I thought I can copy tm1runti.exe from C:\Program Files\IBM\cognos\tm1_64\bin64 on TM1 10.2.2 server and put it into PA2.0.3 environment to make it work. After testing, it apparently doesn't work. I didn't do the upgrade on existing 10.2.2 but just a new fres...
by macsir
Tue Jan 09, 2018 7:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI in PA 2.0.3 with password file
Replies: 10
Views: 472

Re: TM1RunTI in PA 2.0.3 with password file

I didn't realize you were able to run successfully on 10.2 but not 2.0.3, sorry if my questions seemed rather obvious then. We are on 2.0.3 and the base RUNTI command and password files are from when we were on 10.2.2. It's worked through our upgrade cycles without needing updates. Thanks, mate. No...
by macsir
Mon Jan 08, 2018 9:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI in PA 2.0.3 with password file
Replies: 10
Views: 472

Re: TM1RunTI in PA 2.0.3 with password file

We use -passwordfile in RUNTI calls without issue. The -passwordfile parameter must also have the -passwordkeyfile parameter defined. Do you have both defined and did you remove the -pwd parameter? Thanks, the two TM1RunTI commands have same parameters except that one is with -pwd parameter and the...
by macsir
Thu Jan 04, 2018 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How To Avoid LF in source file
Replies: 2
Views: 248

Re: How To Avoid LF in source file

Yes, Perl can deal with these characters pretty easy.
by macsir
Thu Jan 04, 2018 5:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI in PA 2.0.3 with password file
Replies: 10
Views: 472

TM1RunTI in PA 2.0.3 with password file

Hi, has anyone successfully run TI in TM1RunTI command using password file?
I am always getting the following error,
(TM1 API Error) SystemServerClientNotFound
Server connection failed
But if I use password directly, it runs successfully.