Side track on email. Cloud PA do provide SMTP for sending email.
See below:
https://www.ibm.com/support/pages/plann ... ell-script
Search found 206 matches
- Fri May 29, 2020 1:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Local Backup
- Replies: 30
- Views: 20059
- Wed May 27, 2020 2:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Local Backup
- Replies: 30
- Views: 20059
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.
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.
- 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: 2383
Re: REST API error when executing view
It is supposed to be "tm1.Execute"
It is case sensitive
It is case sensitive
- Wed Apr 08, 2020 3:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Never ending GET cellset thread
- Replies: 1
- Views: 2125
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...
- 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: 7030
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. ...
- 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: 7030
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://...
- 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: 7030
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...
- 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: 2708
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...
- 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: 7533
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...
- Fri Dec 20, 2019 11:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rest API
- Replies: 4
- Views: 2887
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.
check the Cognos Connection to confirm. ID and Name can be different.
- Tue Nov 26, 2019 1:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Question
- Replies: 6
- Views: 3648
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,...
- Mon Nov 25, 2019 2:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Question
- Replies: 6
- Views: 3648
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...
- Fri Nov 08, 2019 12:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 REST API - GitInit
- Replies: 11
- Views: 10644
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...
- Thu Nov 07, 2019 12:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Lock reporting periods in TM1
- Replies: 1
- Views: 1996
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...
- Thu Oct 17, 2019 5:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 trigger Macro in Excel
- Replies: 1
- Views: 4311
Re: TM1 trigger Macro in Excel
No Macro, nor Power Query.
There is no Excel on TM1Web.
Only listed Excel functions as in this arcticle.
https://www.ibm.com/support/pages/list- ... -and-later
There is no Excel on TM1Web.
Only listed Excel functions as in this arcticle.
https://www.ibm.com/support/pages/list- ... -and-later
- 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: 7890
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...
- 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: 1781
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...
- Thu Aug 01, 2019 1:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Cloud
- Replies: 5
- Views: 5141
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...
- 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: 2573
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...
- Thu Jun 13, 2019 7:58 am
- Forum: Commercial and Events
- Topic: TM1 coding extension for VSCode
- Replies: 13
- Views: 39400
Re: TM1 coding extension for VSCode
With the GIT support in PA 2.0.7, this may work.