Hi,
There was an issue in early PAX and PA versions with aliases in TM1ELLIST, which was corrected. What are your PAX/PAW/PA versions?
Search found 334 matches
- Wed Jul 15, 2020 7:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1ELLIST syntax to get alias
- Replies: 4
- Views: 2674
- Fri Jul 03, 2020 3:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: STR(Num, len, dec) with only one argument
- Replies: 11
- Views: 4368
Re: STR(Num, len, dec) with only one argument
I don't think this is really a documentation mistake. The information about those "not specified" parameters appeared in PA (comparing to TM1 10.2.2 doc), and supposedly with 2.0.5 version ("The behavior of the STR function has been updated. This may cause a behavior change in usage d...
- Fri Jul 03, 2020 10:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: STR(Num, len, dec) with only one argument
- Replies: 11
- Views: 4368
Re: STR(Num, len, dec) with only one argument
Answer from IBM:
IBM wrote:All parameters to STR are required. You cannot omit any parameters or pass empty parameter values.
The documentation will be updated shortly with this clarification.
- Tue Jun 30, 2020 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Experience with PAW and its future prospects
- Replies: 13
- Views: 6600
Re: Experience with PAW and its future prospects
Hello! IMHO: PAW has many disadvantages, but the Hierarchies, which you cannot use in Architect, outweigh them all. Rule/TI editors are, I can say, "handy" now. Ctrl+space is smart enough now to let me write a rule without touching a mouse. You can create really useful dashboards: with inp...
- Mon Jun 29, 2020 12:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: STR(Num, len, dec) with only one argument
- Replies: 11
- Views: 4368
STR(Num, len, dec) with only one argument
Hello, The documentation says (in short): Arguments : Number - the number to convert Length - ... If the length parameter is not specified , the number parameter is preserved and the length of the function result includes sign, separators, decimal, and decimal places. ... Decimal - ... If this param...
- Tue Jun 23, 2020 8:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5161
Re: How run a SPSS Modeler stream from Tm1 process
Domain is for CAM security. You do not need it with ISM=1
- Mon Jun 22, 2020 11:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5161
Re: How run a SPSS Modeler stream from Tm1 process
I've found error in your command line: "tm1import" works only with SPSS versions <=17 (and my script also )
You need to use tm1odataimport: https://www.ibm.com/support/knowledgece ... slots.html
You need to use tm1odataimport: https://www.ibm.com/support/knowledgece ... slots.html
- Mon Jun 22, 2020 10:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5161
Re: How run a SPSS Modeler stream from Tm1 process
I really didn't work closely with clemb arguments :) Try to add this script in the Stream (Tools, Stream Properties, Execution) and execute just "clemb -execute -stream "E:\SPSS TM1 Demo.str"" stream = modeler.script.stream(); node = stream.findByID("Id_of_your_TM1_Source_No...
- Mon Jun 22, 2020 7:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5161
Re: How run a SPSS Modeler stream from Tm1 process
- Which IntegratedSecurityMode do you use? If 5, try with 1
- Do you have SPSS Modeler Server installed? You can store credentials there
- Fri Jun 19, 2020 10:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Server Crash in PA 2.0.7
- Replies: 3
- Views: 1783
Re: TM1 Server Crash in PA 2.0.7
Hello! Try to increase maximumviewsize parameter (if Windows) Does Event Viewer say something useful? Is it possible to upgrade to 2.0.9.1? Or at least to .08, considering last news regarding Security and dynamic subsets... They have 5-10 issues with "server crash" fixed every fixpack. May...
- Thu Jun 18, 2020 4:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5161
Re: How run a SPSS Modeler stream from Tm1 process
Hi,
As an addition: refer to this documentation to create the bat/cmd file: https://www.ibm.com/support/knowledgece ... rence.html
As an addition: refer to this documentation to create the bat/cmd file: https://www.ibm.com/support/knowledgece ... rence.html
- Wed Jun 17, 2020 8:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 with Cognos Analytics Open ID connect
- Replies: 5
- Views: 3406
Re: TM1 with Cognos Analytics Open ID connect
It depends on your security requirements. Technically, you can configure gateway on any server. Usually it is on the same server with Cognos Analytics
- Tue Jun 16, 2020 6:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Private Views in Contributer
- Replies: 9
- Views: 5258
Re: Private Views in Contributer
What browser do you use? Have you tried another? There was an error with IE years ago: the views didn't save with it. What do you mean by "change the view"? If you just select filters, it's not a trigger to save the view. You should drag dimensions between rows/columns/filters Just try upg...
- Mon Jun 15, 2020 7:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Private Views in Contributer
- Replies: 9
- Views: 5258
Re: Private Views in Contributer
1. Are you sure that the user opens the same workflow node?
2. Check the DATE\namespace\User\YouCube}vues\View_Name_With_GUID_and_node_name.vue. Does it exist? If so, is it THAT view made by user (you can open in in Architect or just analyse using notepad)?
PS thats MY signature!
2. Check the DATE\namespace\User\YouCube}vues\View_Name_With_GUID_and_node_name.vue. Does it exist? If so, is it THAT view made by user (you can open in in Architect or just analyse using notepad)?
PS thats MY signature!
- Mon Jun 15, 2020 6:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SandBoxes Cross Aplication using TM1 Applications
- Replies: 2
- Views: 1600
Re: SandBoxes Cross Aplication using TM1 Applications
Hi, The sandboxes list in different applications are independent. And even more: The sandbox created in one workflow node cannot be seen in another workflow node of the same application. The real name (visible in Architect) of the sandbox created in TM1 Applications will contain application's GUID a...
- Wed Jun 10, 2020 2:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 with Cognos Analytics Open ID connect
- Replies: 5
- Views: 3406
Re: TM1 with Cognos Analytics Open ID connect
Hello,
You can use IIS reverse proxy / URL Rewrite to accomplish this.
To do this, please refer to IIS documentation. The rule will be something like "http://server:9510/tm1web{R:1}"
You can use IIS reverse proxy / URL Rewrite to accomplish this.
To do this, please refer to IIS documentation. The rule will be something like "http://server:9510/tm1web{R:1}"
- Thu Jun 04, 2020 10:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Best Practice for Active Form with dynamic columns?
- Replies: 3
- Views: 2636
Re: Best Practice for Active Form with dynamic columns?
Hi, you can use TM1ELLIST function for this: Generate MDX for your columns dimension Use this MDX in TM1ELLIST Create a date range with this TM1ELLIST Use INDEX in columns PS sorry, I've noticed later that you have TM1 10.2 installed. If so, TM1ELLIST is not your option as it was added in PA2
- Tue Jun 02, 2020 1:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Local Backup
- Replies: 30
- Views: 19839
Re: Local Backup
There is an RFE to include 7zip, and it has "planned" status: https://ibm-data-and-ai.ideas.aha.io/ideas/PAOP-I-245
It's not clear that it's about cloud, but "as we use to do on-premise" implies
It's not clear that it's about cloud, but "as we use to do on-premise" implies
- Fri May 29, 2020 9:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How set alternative hierarchy in Architect or Performance Modeler.
- Replies: 4
- Views: 2228
Re: How set alternative hierarchy in Architect or Performance Modeler.
Hello,
PAW is the only interface where you can manage hierarchies.
In Architect, PM you should use TI for this
PAW is the only interface where you can manage hierarchies.
In Architect, PM you should use TI for this
- Wed May 13, 2020 9:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Memory Usage Issues - StatsByCube
- Replies: 17
- Views: 8297
Re: Memory Usage Issues - StatsByCube
Hi,
TM1 will not use "Memory in garbage". The only way to resolve this is to return the garbage memory to Windows. And the only way to return memory to Windows is to restart the TM1 service
There is a recommended practice to restart your TM1 server every Sunday
TM1 will not use "Memory in garbage". The only way to resolve this is to return the garbage memory to Windows. And the only way to return memory to Windows is to restart the TM1 service
There is a recommended practice to restart your TM1 server every Sunday