Search found 159 matches
- Fri Mar 02, 2018 12:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel run vs. ICX
- Replies: 11
- Views: 9561
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...
- Fri Mar 02, 2018 12:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel run vs. ICX
- Replies: 11
- Views: 9561
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 ...
- Thu Mar 01, 2018 2:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: GENERATE STatement
- Replies: 5
- Views: 4236
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] ) ,...
- Thu Mar 01, 2018 1:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel run vs. ICX
- Replies: 11
- Views: 9561
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...
- Tue Feb 20, 2018 7:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules Passing children
- Replies: 8
- Views: 6453
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...
- 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: 3324
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
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')
- Mon Feb 19, 2018 2:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules Passing children
- Replies: 8
- Views: 6453
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 ...
- 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: 6337
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...
- 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: 7335
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...
- 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: 6337
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...
- 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: 7335
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...
- Wed Feb 07, 2018 2:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ElementAttributes Rule and TI conflict
- Replies: 10
- Views: 6520
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.
- Wed Feb 07, 2018 2:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ElementAttributes Rule and TI conflict
- Replies: 10
- Views: 6520
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'...
- 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: 2694
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_...
- 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: 3940
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);
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);
- Tue Nov 28, 2017 9:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View Extract with TM1 API
- Replies: 23
- Views: 16193
Re: View Extract with TM1 API
Use POST method.
- 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: 1955
Re: Multiple servers on same host - direct login
maybe need check config files in cognos bi ?
- 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: 2570
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>
architect <= 10.2.2 fp4 not see tm1 instance run on 10.2.2 fp4>
- Mon Oct 09, 2017 9:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance of Architect Vs Perspectives
- Replies: 14
- Views: 7827
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?
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?
- 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: 6245
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...