Search found 117 matches

by Drg
Thu Mar 01, 2018 2:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GENERATE STatement
Replies: 5
Views: 1354

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...
by Drg
Mon Oct 09, 2017 8:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help to create TI process to copy data
Replies: 5
Views: 1273

Re: Need help to create TI process to copy data

emmm... Use

Code: Select all

while 
copy data from one month to other month 
end;
maybe should use bedrock process !
by Drg
Fri Sep 29, 2017 7:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 2904

Re: Dynamic subset based on a cube value, with another dimension

You can't do this. If you need filter dimension differently in different cube and use Only one MDX Subset? you need in each cube have system measure element containing dimension for filter. also need store(maybe as attributes dimension Product) filter mask for each Department(attr1...attrN). I'm sti...