Search found 193 matches

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

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 depending on whi...
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: 573

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: 12
Views: 554

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 input cubes, ...
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: 573

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: 11
Views: 398

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: 11
Views: 398

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: 11
Views: 398

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_Node"); node.setPropertyVal...
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: 11
Views: 398

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

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. Maybe one of ...
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: 11
Views: 398

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

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: 8
Views: 1451

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 upgrade to 2....
by Elessar
Mon Jun 15, 2020 7:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Private Views in Contributer
Replies: 8
Views: 1451

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

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

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: 1
Views: 201

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: 22
Views: 1229

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

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

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
by Elessar
Fri May 08, 2020 7:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - Connection Error
Replies: 2
Views: 139

Re: TM1 - Connection Error

Hi,

What is IntegratedSecurityMode in tm1s.cfg? Admin+Apple usually stands for 1, but CAM is 4 or 5.