Search found 206 matches

by kangkc
Fri May 29, 2020 1:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1921

Re: Local Backup

Side track on email. Cloud PA do provide SMTP for sending email.
See below:
https://www.ibm.com/support/pages/plann ... ell-script
by kangkc
Wed May 27, 2020 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1921

Re: Local Backup

Insetad of 7-zip, I used PowerShell System.IO.Compression.FileSystem to perform the zipping.
Alternatively you can use Powershell Compress-Archive cmdlet. All thee are available on Windows Server as long as PowerShell is not disabled.
No installation of 3rd party software.
by kangkc
Tue Apr 28, 2020 2:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API error when executing view
Replies: 2
Views: 777

Re: REST API error when executing view

It is supposed to be "tm1.Execute"

It is case sensitive :D
by kangkc
Wed Apr 08, 2020 3:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Never ending GET cellset thread
Replies: 1
Views: 708

Never ending GET cellset thread

This is probably the 10 times I am getting this issue in which TM1Top show a user innocent Get Cellset thread seems to be running forever and as a result caused lock wait in a few TI processes and evetually a full server locked up. Never arrived with any conslusion with IBM as it will require switci...
by kangkc
Tue Mar 31, 2020 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Authenticating to REST API on Postman
Replies: 12
Views: 1022

Re: Authenticating to REST API on Postman

Based on what you have tested, there is nothing wrong with the Rest API with your cloud subscription. I believe you have two issues 1. wrong instance name 2. Authentication issue due to setup If you are not the assigend PA Administrator/Modeler, suggest you get the correct instanace name from them. ...
by kangkc
Tue Mar 31, 2020 5:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Authenticating to REST API on Postman
Replies: 12
Views: 1022

Re: Authenticating to REST API on Postman

My understanding is Rest API on PA Cloud is enabled by default. However, to make it work with authentication you have to request for a non-interactive ID to be created which uses the namespace of LDAP. Only then you can use Rest API with authentication. The screen you are seeing using "https://custo...
by kangkc
Tue Mar 31, 2020 12:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Authenticating to REST API on Postman
Replies: 12
Views: 1022

Re: Authenticating to REST API on Postman

This is what we used for all cloud clients: https://customer.planning-analytics.ibmcloud.com/tm1/api/servername/api/v1 The servername is what you see when you login via PAx, PAW or TM1web. To test it without authentication, issue the $metadata call: https://customer.planning-analytics.ibmcloud.com/t...
by kangkc
Tue Mar 10, 2020 12:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Tree Expanding Error in PAW
Replies: 4
Views: 726

Re: Process Tree Expanding Error in PAW

Hi, all We are on PAW 2.0.46 and I found this error when expanding process tree. Other trees are fine. Any idea? Caused by: com.fasterxml.jackson.core.JsonParseException: Invalid UTF-8 start byte 0xa0 at [Source: (com.ibm.ba.pm.harmony.common.tm1.TM1RestResult$InputStreamProxy); line: 1, column: 26...
by kangkc
Fri Jan 24, 2020 1:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 14
Views: 1339

Re: TI MDX query of 2 different cubes

I think TSW is trying to get Cube A from Server 1 and Cube B from Server 2. Traditionally it will be like using TI to generate an interface fike from Server 1, followed by another TI in server 2 picking up the interface file and while processing the file records, CELLGETN Cube B. If this is to be au...
by kangkc
Fri Dec 20, 2019 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API
Replies: 4
Views: 740

Re: TM1 Rest API

Make sure you are using NameSpace ID and not NameSpace Name.
check the Cognos Connection to confirm. ID and Name can be different.
by kangkc
Tue Nov 26, 2019 1:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Question
Replies: 6
Views: 878

Re: Rule Question

Hi, thanks for help! I am working on TI process but it is not working yet. I prefer to do the rule, but I am facing some difficult too. My dimensions of period has the hierarchy as you said. I put some screenshots here. On rule you would use the ELPAR function? Can you explain more? Thanks, JR. No,...
by kangkc
Mon Nov 25, 2019 2:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Question
Replies: 6
Views: 878

Re: Rule Question

Given a choice I will prefer the path of using TI to copy data from one cube to the other. It will be a very straight forward unless the dates you are storing is serial number date format which you may need some date formatting function in combination of SUBST etc. If insist of using rule, I will ju...
by kangkc
Fri Nov 08, 2019 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API - GitInit
Replies: 10
Views: 1739

Re: TM1 REST API - GitInit

I did managed to get GInit running without error but I was using a local repository hence may be different as I didn't want to go through a trouble of involving certificates. I did encounter some error initially and I have to explicily run a Git Init command (not using TM1 Rest) with the local repos...
by kangkc
Thu Nov 07, 2019 12:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock reporting periods in TM1
Replies: 1
Views: 695

Re: Lock reporting periods in TM1

A quick and flexible way, set up a locking cube comprises of Version, Year, Month which allow you to set a string value of 'Lock', 'Unlock'. Write a Cell Security rule in the Financial Reporting Cube to reference this locking cube. If the intersection of Version,Year,Month is 'Lock', set access to R...
by kangkc
Thu Oct 17, 2019 5:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 trigger Macro in Excel
Replies: 1
Views: 3090

Re: TM1 trigger Macro in Excel

No Macro, nor Power Query.
There is no Excel on TM1Web. :lol:

Only listed Excel functions as in this arcticle.
https://www.ibm.com/support/pages/list- ... -and-later
by kangkc
Thu Oct 10, 2019 12:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Lock" Actual Data in a forecast application
Replies: 6
Views: 5140

Re: "Lock" Actual Data in a forecast application

The usual way I do it is via cellsecurity with rule referencing a locking cube which manages which months are actuals for respective forecast scenario. With that you have full flexibility of controlling. Note that this will not work under TI which runs under Admin context and you will need to put in...
by kangkc
Thu Aug 01, 2019 1:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Two sets of count in a dimension
Replies: 1
Views: 682

Re: Two sets of count in a dimension

I think any TM1 developer which has some modeling experience should be able to model this pretty easily. Various utility admin fee can be set via reference cube. Number of units in each building, number of units using respective utility services can be stored in the main cube. The rest are just simp...
by kangkc
Thu Aug 01, 2019 1:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Cloud
Replies: 5
Views: 1751

Re: REST API: Cloud

Based on what I understand from IBM, it will only work with non-interactive account for PA Cloud, which we have validated. CAM Namespace ID is "LDAP" based on PA Cloud welcome kit. Never manage to find out the Namespace ID for interactive account from IBM to test it out. Will be interested if this i...
by kangkc
Thu Jun 27, 2019 12:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Cloud backup to local drive
Replies: 2
Views: 764

Re: IBM Cloud backup to local drive

What I did is to write a TI to invoke a Powershell script (yes, it is available in Cloud PA environment), copy to a backup folder and compress it. On-premise we have a scheduled task to initiate a FTPS client request to pull the compressed backup back to local site. Simple setup and do not need to i...
by kangkc
Thu Jun 13, 2019 7:58 am
Forum: Commercial and Events
Topic: TM1 coding extension for VSCode
Replies: 13
Views: 24152

Re: TM1 coding extension for VSCode

With the GIT support in PA 2.0.7, this may work.