Search found 84 matches

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

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

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

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: 4
Views: 877

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

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

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

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

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

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

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

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

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

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

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

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

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...
by Drg
Wed Feb 07, 2018 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes Rule and TI conflict
Replies: 10
Views: 1122

Re: }ElementAttributes Rule and TI conflict

I ask you to take into account that CubeRuleDestroy permanently deletes the file. for correct operation, before you perform this function, you must first copy the }elementattribute*.rux file to a temporary folder.
;)
by Drg
Wed Feb 07, 2018 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes Rule and TI conflict
Replies: 10
Views: 1122

Re: }ElementAttributes Rule and TI conflict

Try to use this before CubeRuleDestroy(CubeName); and CubeRuleAppend(CubeName, RuleText, IsCalculationRule); after update dimension with alias Or create config cube to stet alias rules on time wheen you update dimensionn example: [aliasNameElement] s:= IF( DB(configcube, 'UseRule' , 'DimensionAlias'...
by Drg
Wed Feb 07, 2018 8:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: how tm1 locks work at the time the view is read
Replies: 1
Views: 486

how tm1 locks work at the time the view is read

colleagues today faced with the most interesting fact of mutual locks, a collective help is necessary in the correct understanding of the logic of TM1. So to the point: I have a parent process that starts parralel processes that in turn create temporary views and write them to the database. Prarent_...
by Drg
Wed Dec 20, 2017 8:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Read Lock on CSV Source File
Replies: 3
Views: 608

Re: TI Process Read Lock on CSV Source File

export server (E)
import server (I)

Do I understand correctly that you are launching the process of an import from the server E within the expot process?
if it is so try launch RUNTI without waiting for an answer executecommand(, 0);