Search found 88 matches

by Drg
Tue Mar 26, 2019 7:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA Extension
Replies: 5
Views: 764

Re: JAVA Extension

Hi Mate, As far as I know this has been depreciated in PA. Based on your profile you are on 10.2.2, but given its going out of support in the near future, I would not be investing my time into Java Extensions. Rest API is the way forward. There are open-source Python wrappers available online that ...
by Drg
Tue Mar 05, 2019 7:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web- Cell Background Color Change
Replies: 5
Views: 734

Re: TM1 Web- Cell Background Color Change

if we talk abaut tm1 web you can change color directly in
C:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\scripts\tm1web\themes\flat\flat.css
if you use this theme checked in browser in develop mode (f12)
by Drg
Tue Mar 05, 2019 6:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw installation: issue to open the admintool
Replies: 3
Views: 423

Re: Paw installation: issue to open the admintool

You can open your admin tool remotely:
after run start.ps1 and starting admin tool
open in web browser on your local machine url- http://your_paw_server:8888
by Drg
Fri Feb 15, 2019 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: collect logs to database
Replies: 0
Views: 329

collect logs to database

Hi to all Today I wondered why not to collect server logs not into a file but into a relational database. As I see it, there are several solutions: 1 use rest api 2 use log4j (tm1s-log.properties) 3 parse log files by other means 1 Checking the rest api on a large amount of logs, I realized that it ...
by Drg
Fri Sep 28, 2018 7:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How To Compare two dimensions
Replies: 8
Views: 3331

Re: How To Compare two dimensions

I use this approach in all major dimension updates. I update an _Origin version of the dimension first. This copy of the dimension is not used in any cubes so if the update fails for some reason it does not affect any data. I then have processes that compare the updated _Origin dimension to the cur...
by Drg
Wed Sep 26, 2018 8:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How To Compare two dimensions
Replies: 8
Views: 3331

Re: How To Compare two dimensions

Who faced the universal approach of comparing two dimensions with the comparison of hierarchies, implying that the serial numbers can be different? until I came to the conclusion that one of the systems should be considered a donor by another recipient and overwrite the measurement at boot, but this...
by Drg
Wed Sep 19, 2018 2:41 pm
Forum: Useful code, tips and tricks
Topic: Listing of all numerical TI process property values in .pro
Replies: 12
Views: 4276

Re: Listing of all numerical TI process property values in .pro

use java extension to parse *.pro files and collect his variable name with type [string,numeric].
if this is someone I need to post with examples
by Drg
Tue Sep 04, 2018 10:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 3175

Re: TM1 REST API

Hello Wim. Regarding your questions, some of them are described in the main dock, although I'll notice that they are described in the main dock very poorly, but there is still something there. https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rest_api.2.0.0.doc/tm1_r...
by Drg
Tue Mar 06, 2018 8:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Homepage redirection without re-login
Replies: 1
Views: 539

Re: TM1Web Homepage redirection without re-login

I do not think that someone will offer a ready solution. but you need to dig

...\ibm\cognos\tm1_64\webapps\tm1web\scripts\

https://www.ibm.com/support/knowledgece ... brary.html
by Drg
Fri Mar 02, 2018 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 2413

Re: Parallel run vs. ICX

I do not know the nature of such locks, I guess only that this is due to the presentation of data at a certain point in time those. in the moment you read of the cube, somebody put data into this cube but the reading is not blocked and the record is not blocked either, and the data you read is actua...
by Drg
Fri Mar 02, 2018 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 2413

Re: Parallel run vs. ICX

dear friend, let's imagine a situation where you open an architect and run one of your processes. after you run another architect and try to log in and execute the second process. what result will you get? I guess it depends on what is the purpose of both processes? :) so check that this! is not a ...
by Drg
Thu Mar 01, 2018 2:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GENERATE STatement
Replies: 5
Views: 1197

Re: GENERATE STatement

HI you do not use dimension in subset for another dimension. For Dimension Cost Center GENERATE( FILTER(TM1FILTERBYLEVEL( TM1SUBSETALL( [Cost Center] ), 0),[CostCenterSelection].([Version].[Plan],[m_CCEmpSelection].[SelectCC])="Yes")), {FILTER(TM1FILTERBYLEVEL( TM1SUBSETALL( [Employee] ) , 0),[Emplo...
by Drg
Thu Mar 01, 2018 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 2413

Re: Parallel run vs. ICX

As far as I know there shouldn't be any IXC lock on both source and target cubes because each TI process is reading/writing from/to a separate ORG unit, right? dear friend, let's imagine a situation where you open an architect and run one of your processes. after you run another architect and try t...
by Drg
Tue Feb 20, 2018 7:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 8
Views: 1553

Re: Rules Passing children

I need the equivalent expression to get the childrens of the selected customer . In one cell you want to pass that list of children? separated by what? But of course this can be done BUT WHY? []=S:ELCOMP(dimension, element, 1) | ' ; ' | ELCOMP(dimension, element, 2) ... I mean this is slow logic fo...
by Drg
Mon Feb 19, 2018 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore resubmitting itself when Locked out by another Process
Replies: 4
Views: 767

Re: Chore resubmitting itself when Locked out by another Process

as written above the use of flags is a good idea.

I'll suggest an alternative to file flags:

Use your chore to run one parent process that starts the child processes.
in the parent process in the first line of the prolog, use the function

Code: Select all

synchronized('Important_batch_process')
by Drg
Mon Feb 19, 2018 2:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 8
Views: 1553

Re: Rules Passing children

Based on attribute value , I I have to pass all the childrens for a selected customer for a certain case and customer itself in certain cases . DB('Sales',!Customer) or DB('Sales',Childrens(!Customer)) I am not sure for the syntax to pass all CHildrens(!Customer). Thanks You should understand that ...
by Drg
Thu Feb 15, 2018 9:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get the Admin Host of TM1 server
Replies: 7
Views: 2386

Re: Get the Admin Host of TM1 server

I just put the admin host manually into a central control cube where all processes can refer to as it really doesn't change. I also did this until I transferred a model that starts several hours and left home as a result of which users started the processes on the productive model and the child pro...
by Drg
Thu Feb 15, 2018 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI and number of cores/threads
Replies: 9
Views: 2121

Re: TM1RunTI and number of cores/threads

tm1runti is quite picky about text vs numeric parameter values. In my experience it quite likes or requires the process name and all string parameters to be in double quotes. Depending on how picky it is feeling it might also like the user and pwd in quotes as well. If using CAM it can also be pick...
by Drg
Mon Feb 12, 2018 6:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get the Admin Host of TM1 server
Replies: 7
Views: 2386

Re: Get the Admin Host of TM1 server

I apologize for raising the old topic but no where there is no explanatory description let it be here Test this script only on Windows server. p/s/ sctript created dimension DimName='sys_ServerParameters'; you can append parameters pParamsList=UPPER(':adminhost:ServerName:'); or append all parameter...
by Drg
Fri Feb 09, 2018 5:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI and number of cores/threads
Replies: 9
Views: 2121

Re: TM1RunTI and number of cores/threads

If you use windows server you can monitor threads from parent process; TIprc='Process_NAME'; pTreadNum=10; SCRIPT='powershell -command "& { while(( Get-WmiObject Win32_Process -Filter """"name = ''tm1runti.exe'' and CommandLine like ''%-process """"""""'| TIprc |'""""""""%'' """" ).count -gt '|NUMBE...