Search found 486 matches

by macsir
Wed Feb 21, 2018 9:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add CAM Users
Replies: 5
Views: 139

Re: Add CAM Users

Here you go, don't you have this option in your AD?
And there is another way, go to you AD and click on search link at the upper right corner, you can find individual user as well.
by macsir
Tue Feb 20, 2018 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add CAM Users
Replies: 5
Views: 139

Re: Add CAM Users

I don't quite get it. Can't you add users through Clients/Groups interface?
by macsir
Tue Feb 20, 2018 9:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting data from AD
Replies: 2
Views: 81

Re: Getting data from AD

if you are using Cognos namespace(CAM), then you can use Cognos SDK to export groups and users.
by macsir
Mon Feb 19, 2018 10:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 8
Views: 309

Re: Rules Passing children

I don't think there is a way to get all children for a selected parent in the rule. Children function only exists in MDX.
If Consolidatechildren('Customers') by summing immediate children works for you, why can't you create some hierarchies instead for better performance?
by macsir
Sun Feb 18, 2018 9:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 8
Views: 309

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: 1131

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: 333

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: 115

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: 271

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: 327

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: 327

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: 320

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: 366

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: 176

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: 449

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: 220

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: 491

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: 491

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