TM1 Forum

You need to check a format cell in a hidden area in your active form for the row you want to write values to. Check the link for finding hidden area: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_pers_arch.2.0.0.doc/t_revealingtheformatrange_n80346...

Is the report made on the basis of a websheet (on Excel by TM1 Perspectives) or a simple view?
If it is a websheet, then it looks like a format problem on the Excel side.
If a view, then this is a strange situation. Maybe clean broweser's cache?

Dear community, thank you so much for your help! As a result, I got the following TI code and it works fine for me at this moment. This code will be supplemented in the part of overriding the source files for processing, but the main point is below. Maybe later I can update this post and add a more ...

Then I would suggest AsciiOutput in the Prolog tab to a text file and execute it in the Epilog tab. Yes, that's a good idea. But the file with VBscript is unloaded with the text in quotes. I tried closing quotes both at the beginning and at the end. Unfortunately, such a file does not work. Script,...

For example, see line 2: Wim, thank you so much! Sorry, I followed the difficult path and completely forgot about the simple) Everything works! While I was setting up the script, I got the idea to abandon this script file and write everything through the ti-process? Is it possible to run a script u...

Mackenzie, Wim, it's really works! Thank you!
Could you help with one more thing?
Is it possible to add such lines of the script so that the cell format is cleared before saving the file?

Hello everyone! Our version: PA 2.0.8 (11.6.00000.14) We use customized views in drills in exactly the same way. Unfortunately, we observe that when we change the name of a view in the Prolog, nothing happens. Drill opens the view that is selected on the Source tab, but with new correct subsets. At ...

If it is a active form or slice TM1 supports conditional formatting for a criteria : https://www.ibm.com/support/knowledgecenter/SS9RXT_9.5.0/com.ibm.swg.im.cognos.tm1_wb.9.5.2.doc/tm1_wb_id868ConditionalFormatting_N10064D.html But other than that, the default behavior is not editable/rules driven ...

Hello, Maxime! If I understand correctly, you have the following situation: - views are in the folder DATA; - views consist only of existing subsets and contain existing elements that are displayed at the opening; - views were previously published and were accessed; - everything works on the dev, bu...

Hello, Jim! Perhaps, I can help in solving your problem. To specify the values that are passed from the parameters, you have to use the following syntax: [ Dimension ].[ ? ParameterName ? ] For example: DatasourceQuery = ' SELECT {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Period] )}, 0)} ON COLUMNS, Non emp...

One more thing :) For some reason, security specialists can prohibit storing the login and password openly and side by side in the TI-process (most likely it's a technical user with administrator rights). In this case, you can do the following: In Prolog you do not need to use local variables , whic...

Thank you, Wim, for the warm welcome! Yes, you really did not quite understand what I asked about initially. But you helped me A LOT in solving my problem. Thank you! When I put the values of local variables in a file (TextOutPut) during the standard functional is working (without using any override...

Hello everyone! IBM Cognos TM1 Build Number: 10.2.20603.106 OS: Windows Server 2012 R2 Standart We have several servers. On each server (OS - the same) there are several different Cognos models (TM1 Version - the same). There is a need to transfer data from one server to another and from another mod...