Search found 159 matches

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

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

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

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] ) ,...
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: 9063

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

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

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

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

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

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

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

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 """"&q...
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: 6348

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

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

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

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);
by Drg
Tue Nov 28, 2017 9:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Extract with TM1 API
Replies: 23
Views: 16090

Re: View Extract with TM1 API

Use POST method.
by Drg
Tue Nov 28, 2017 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple servers on same host - direct login
Replies: 1
Views: 1863

Re: Multiple servers on same host - direct login

maybe need check config files in cognos bi ?
by Drg
Wed Oct 18, 2017 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 instances are running in cognos configuration but not appearing in TM1 architect.
Replies: 3
Views: 2427

Re: TM1 instances are running in cognos configuration but not appearing in TM1 architect.

also check you architect version and tm1 version.

architect <= 10.2.2 fp4 not see tm1 instance run on 10.2.2 fp4>
by Drg
Mon Oct 09, 2017 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 7722

Re: Performance of Architect Vs Perspectives

I agree with my colleagues and add my assumptions.
ARCHTECT and PERSPECTIVE are launched from one machine that is not a server?
If this is a server from which directories are the clients running?
you use VMM VMT ?
Do your tests have a chaotic startup order?
by Drg
Mon Oct 09, 2017 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI process time for cubes with heavy rules
Replies: 11
Views: 6147

Re: Improve TI process time for cubes with heavy rules

If you Output generate many data and cube receiver not final in chain calcultion. You need find the narrow neck of your process: long calc or long insert. based on the result of the analysis, I can assume that you have further logic for calculating the data, and the TI side-by-side starts will not g...