Search found 13 matches
- Wed Dec 15, 2021 5:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web negative number didnot allowed
- Replies: 7
- Views: 20230
Re: TM1 Web negative number didnot allowed
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...
- Wed Dec 15, 2021 4:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web negative number didnot allowed
- Replies: 7
- Views: 20230
Re: TM1 Web negative number didnot allowed
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?
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?
- Thu Sep 10, 2020 10:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Free Excel-to-Text converter
- Replies: 20
- Views: 7958
Re: Free Excel-to-Text converter
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 ...
- Thu Sep 10, 2020 6:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Free Excel-to-Text converter
- Replies: 20
- Views: 7958
Re: Free Excel-to-Text converter
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,...
- Thu Sep 10, 2020 3:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Free Excel-to-Text converter
- Replies: 20
- Views: 7958
Re: Free Excel-to-Text converter
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...
- Thu Sep 10, 2020 2:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Free Excel-to-Text converter
- Replies: 20
- Views: 7958
Re: Free Excel-to-Text converter
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?
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?
- Mon Jun 01, 2020 6:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drill Through custom views/subsets
- Replies: 8
- Views: 3891
Re: Drill Through custom views/subsets
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 ...
- Wed Feb 27, 2019 9:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web- Cell Background Color Change
- Replies: 5
- Views: 4835
Re: TM1 Web- Cell Background Color Change
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 ...
- Fri Jan 26, 2018 10:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View not visible after load server
- Replies: 15
- Views: 11676
Re: View not visible after load server
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...
- Thu Jan 25, 2018 2:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Set ODBO Datasource in Prolog
- Replies: 10
- Views: 8247
Re: Set ODBO Datasource in Prolog
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...
- Tue Mar 21, 2017 4:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Set ODBO Datasource in Prolog
- Replies: 10
- Views: 8247
Re: Set ODBO Datasource in Prolog
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...
- Mon Mar 20, 2017 1:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Set ODBO Datasource in Prolog
- Replies: 10
- Views: 8247
Re: Set ODBO Datasource in Prolog
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...
- Fri Mar 17, 2017 3:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Set ODBO Datasource in Prolog
- Replies: 10
- Views: 8247
Set ODBO Datasource in Prolog
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...