Search found 514 matches

by macsir
Tue Jul 10, 2018 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing Java application through TM1 process
Replies: 10
Views: 887

Re: Executing Java application through TM1 process

You still can just java with rest api. I am actually developing it now but don't have much time to make it progress ATM. I use Java + Jackson + apache HTTP client to interact with rest api. TM1Py is similar thing as it wraps rest api with python. If you are interested, just have a read on rest api o...
by macsir
Sun Jul 01, 2018 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Benefits of REST API over native TM1py/TM1JavaApi
Replies: 3
Views: 241

Re: Benefits of REST API over native TM1py/TM1JavaApi

REST API is the way to go. Those old .net or java native api are obsolete.
by macsir
Mon Jun 18, 2018 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI for placing a file on SFTP server
Replies: 4
Views: 418

Re: TI for placing a file on SFTP server

google is your friend. https://serverfault.com/questions/78557 ... th-cuteftp
If you can't fix it, you still could try winscp.
by macsir
Sun Jun 17, 2018 9:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2 - Can Pax & Perspectives Co-exist?
Replies: 3
Views: 294

Re: Planning Analytics 2 - Can Pax & Perspectives Co-exist?

Just a case of "not officially supported" != "doesn't work"
:D
by macsir
Fri Jun 08, 2018 12:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking Element Level Security in a TI processes
Replies: 6
Views: 348

Re: Checking Element Level Security in a TI processes

Thanks for sharing. I reckon MDX is handy and helpful.
by macsir
Fri Jun 01, 2018 4:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA: Multiple web instance
Replies: 6
Views: 528

Re: PA: Multiple web instance

Just out of curiosity, what is the general use to have multiple web instance?
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: 367

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

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

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

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

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

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

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: 14
Views: 1566

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: 5
Views: 737

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

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

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

Re: TI: Process Options - Rebuild sheet

Interesting, have you tested it yet?