Search found 520 matches

by macsir
Tue Aug 07, 2018 9:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading to Database; ideas
Replies: 5
Views: 164

Re: Loading to Database; ideas

So, if not that way, the simplest way to do that is to use nested loop. The inner loop for all attributes and outer loop for all projects, if you know what I mean.
by macsir
Tue Jul 31, 2018 9:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw - dashboard Backups
Replies: 1
Views: 166

Re: Paw - dashboard Backups

There is an official doco which tells you how to backup and restore. Just google it.
by macsir
Tue Jul 31, 2018 9:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dropdown list in Chrome for TM1 Web not responding
Replies: 6
Views: 181

Re: Dropdown list in Chrome for TM1 Web not responding

I will propose the user to reinstall Chrome to see if it works and will keep updates here.
by macsir
Tue Jul 31, 2018 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dropdown list in Chrome for TM1 Web not responding
Replies: 6
Views: 181

Re: Dropdown list in Chrome for TM1 Web not responding

Thanks, guys. But the problem is we have same version of Chrome, why it works fine on my PC? That's what is bothering me. :?
by macsir
Mon Jul 30, 2018 11:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dropdown list in Chrome for TM1 Web not responding
Replies: 6
Views: 181

Re: Dropdown list in Chrome for TM1 Web not responding

Looks like this issue only happens to me. :cry:
by macsir
Thu Jul 26, 2018 4:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dropdown list in Chrome for TM1 Web not responding
Replies: 6
Views: 181

Dropdown list in Chrome for TM1 Web not responding

Hi, guys Have a weird issue for tm1 web in chrome. The user has chrome up-to-date and is on Windows 10. The whole web report is showing fine and when he click on the down arrow in the drop-down list, the list can be shown. However, chrome is not responding or highlighting any item from that list whe...
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: 988

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

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

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

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

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

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

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

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

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

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

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

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

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.