Search found 507 matches

by macsir
Sat May 19, 2018 12:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder for C level calculation
Replies: 2
Views: 205

Re: Feeder for C level calculation

Sorry, maybe title is confusing, what I mean is feeder for Average XYZ at N level to enable right consolidation. Since it is just doing average at C level and no zero suppression required, I really don't think feeder for Average XYZ at N level is not needed. I am aware of making "Average XYZ" the pa...
by macsir
Fri May 18, 2018 1:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder for C level calculation
Replies: 2
Views: 205

Feeder for C level calculation

Hi, guys

If I am calculating C level average

Code: Select all

['Average XYZ'] =C: ['ABC'] \ ['EFG'];
and user don't need this average at N level and don't care about the Zero Suppression,
I won't use any feeder for this to gain the max cube performance. ( ['ABC'] , ['EFG'] are all real numbers.)
Is that true?
by macsir
Thu May 03, 2018 4:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 instance stuck on restart on StatsBy... cub files
Replies: 8
Views: 290

Re: TM1 instance stuck on restart on StatsBy... cub files

I think there is some conflicting between the two functions. If you use savedataall, it is unnecessary to use CubeSaveData to save all cubes.
by macsir
Wed May 02, 2018 9:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 instance stuck on restart on StatsBy... cub files
Replies: 8
Views: 290

Re: TM1 instance stuck on restart on StatsBy... cub files

Never heard about that before. Did you manually save data before restarting?
by macsir
Wed May 02, 2018 9:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 476

Re: Cube Copy TI Process

You don't need to remove year. As long as you get all level 0 elements from year dimension, it still can remain.
But for easier coding, I would like to remove it and make sure your extracting view is suppressing zeros and skip consolidations.
by macsir
Mon Apr 30, 2018 12:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Putting Expand function to a good use
Replies: 11
Views: 3512

Re: Putting Expand function to a good use

Yes, I agree. This is exactly the way I am doing for all dimension building processes. Another extra thing I add is, the base table with this multi-column table is still useful in DB or DW, which I don't want to change. I created a view with parent-child pair based on the table, which is loaded as s...
by macsir
Thu Apr 26, 2018 9:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell to logoff and clean profile on another server
Replies: 5
Views: 319

Re: Powershell to logoff and clean profile on another server

Check your service account you are using for TM1. It might be the service account don't have proper privilege compared with the one you run the PS script.
by macsir
Mon Apr 23, 2018 9:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 6
Views: 586

Re: Server Locked after save data process and save data is running for a long time .

You probably can use process explorer to check what process is locking up your files at that time and go from there.
by macsir
Mon Apr 23, 2018 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Workspace – Installation issue / IP issue
Replies: 4
Views: 418

Re: Planning Analytics Workspace – Installation issue / IP issue

Do you have proxy settings in the LAN of your IE? Untick them all and try.
by macsir
Thu Apr 19, 2018 9:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 on GPU
Replies: 2
Views: 244

Re: TM1 on GPU

That is interesting idea! However, I think TM1 calculation is different from current hot popular AI calculation which can utilize GPU at maximum level.
by macsir
Thu Apr 19, 2018 9:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI Parallel Processing with Batch File Error Capture
Replies: 11
Views: 924

Re: TM1RunTI Parallel Processing with Batch File Error Capture

Bat file is kind of clumsy. And I use powershell to wrap TM1RUNTI command. In other powershell file, you can use $LASTEXITCODE to capture what this TM1RUNTI returns.
by macsir
Tue Apr 10, 2018 9:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI: Process Options - Rebuild sheet
Replies: 3
Views: 197

Re: TI: Process Options - Rebuild sheet

Interesting, have you tested it yet?
by macsir
Mon Apr 09, 2018 12:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cheking File Size
Replies: 3
Views: 292

Re: Cheking File Size

Powershell is the way to go rather than TI processes.
by macsir
Thu Apr 05, 2018 9:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible to pass parameters to a powershell (.ps1) file?
Replies: 14
Views: 979

Re: Is it possible to pass parameters to a powershell (.ps1) file?

| Move -Destination "TARGET:\$Server\$Instance\LogFiles\" Off the top of my head, MOVE is dos command rather than PS command. Use Move-Item instead. https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.management/move-item?view=powershell-6 And better to show powershell log when ...
by macsir
Wed Apr 04, 2018 9:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Interesting findings in rules
Replies: 4
Views: 590

Re: Interesting findings in rules

Elessar wrote:
Wed Apr 04, 2018 7:53 am
(Was long ago in 9.5.2)
This broke my brain, when I tried to analyze a rule with 3 (!) SKIPCHECKS

The rule begins to be evaluated from the last SKIPCHECK statement
haha, good one. :lol:
by macsir
Wed Apr 04, 2018 4:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Interesting findings in rules
Replies: 4
Views: 590

Interesting findings in rules

Although the official document is saying, When consolidating data in cubes that have rules defined, TM1 turns off this sparse consolidation algorithm because one or more empty cells may in fact be calculated by a rule. (Skipping rules-calculated cells will cause consolidated totals to be incorrect)....
by macsir
Wed Mar 28, 2018 9:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1TOP not working - Planning Analytics -2.0
Replies: 4
Views: 447

Re: TM1TOP not working - Planning Analytics -2.0

You missed some files and directories for PA2.

1. C directory
2. gsk8valn_64.dll
3. gsk8dbfl_64.dll
4. gsk8kicc_64.dll

If you get the copy from installation folder, it should run fine.
by macsir
Wed Mar 28, 2018 9:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Possible to provide line space in comments?
Replies: 5
Views: 477

Re: Possible to provide line space in comments?

I am using Powershell as well but I wrap the send email function to sendemail.ps1 file to accept parameters from TI processes.
by macsir
Sun Mar 25, 2018 10:50 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 13
Views: 1306

Re: Using old clients with new planning analytics server

We have a PAL 2.0.4 server and our users are using a multitude of Perspective/Architect versions, going back as far as version 9.5.1. Here are the things that need to be done: 1) set the TM1 Admin server to support pre-TLS v1.2 clients via Cognos Configuration 2) add in tm1s.cfg: SupportPreTLSv12Cl...