Search found 334 matches

by Elessar
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

Re: TM1ELLIST syntax to get alias

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?
by Elessar
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...
by Elessar
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.
by Elessar
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...
by Elessar
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...
by Elessar
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
by Elessar
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
by Elessar
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...
by Elessar
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

  1. Which IntegratedSecurityMode do you use? If 5, try with 1
  2. Do you have SPSS Modeler Server installed? You can store credentials there
by Elessar
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...
by Elessar
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
by Elessar
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
by Elessar
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...
by Elessar
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! ;)
by Elessar
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...
by Elessar
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}"
by Elessar
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
by Elessar
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
by Elessar
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
by Elessar
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