Search found 10 matches

by raman
Thu Sep 28, 2017 7:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading data using parameters
Replies: 3
Views: 2826

Re: loading data using parameters

i want to use parameters as whenever i should run tI process it should ask for what service and what department i want to insert data. it should load data only for specified service and department.
by raman
Thu Sep 28, 2017 6:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading data using parameters
Replies: 3
Views: 2826

loading data using parameters

i want to load data into a cube using two parameters.
id name service department data

these all are col. in my .csv source file.i want two parameters service and department based on those 2 only data should be loaded.
i never used parameters before.please someone help me.
by raman
Fri Sep 22, 2017 7:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: dynamic subset for last 5
Replies: 1
Views: 1420

dynamic subset for last 5

i wan to make a dynamic subset using expression which shows last 5 elements of dimension.
i used this

{drilldownlevelbottom({[segment].[all segments]},5)}

but this one is showing first 5.
by raman
Thu Sep 21, 2017 11:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: reports using active form
Replies: 1
Views: 1739

reports using active form

can someone tell me how to make report using active form. i have perspectives installed.
by raman
Wed Sep 20, 2017 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: fileexists and dimensionexists
Replies: 8
Views: 5290

Re: fileexists and dimensionexists

can you suggest if file is missing i have to exit the process with a message, how to do that
by raman
Wed Sep 20, 2017 12:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: fileexists and dimensionexists
Replies: 8
Views: 5290

Re: fileexists and dimensionexists

Have you defined the path correctly in the TI : FileExists('C:\tm1s7\pdata\model.dim'); And created a wapper process to perform the evaluation in the PROLOG: IF(FileExists('FILENAME') =1); ExecuteProcess('Load Process Name Here'); ELSE; ProcessQuit; ENDIF; As for the second part: This feature can b...
by raman
Wed Sep 20, 2017 11:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding elements in dimesnion using TI
Replies: 3
Views: 2745

Re: adding elements in dimesnion using TI

Hi Please go through below functions,It will give you an idea: https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_ref.10.2.2.doc/c_dimensionmanipulationturbointegratorfunctions_n71607.html#DimensionManipulationTurboIntegratorFunctions_N71607 http://public.dhe.ibm...
by raman
Wed Sep 20, 2017 10:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding elements in dimesnion using TI
Replies: 3
Views: 2745

adding elements in dimesnion using TI

country
-city
- building

this is my dimension hierarchy. i want to add a element city-building not available at building position whenever a new city come. I am using TI process to make dimension.i cant edit the source file.
by raman
Wed Sep 20, 2017 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: fileexists and dimensionexists
Replies: 8
Views: 5290

Re: fileexists and dimensionexists

i tried this
if(FileExists('filename')=1);
ExecuteProcess('dim_name');
else;
ProcessQuit;
endif;
but this one is sending the process into loop


and for dimension part i did

if(dimesnionexists('dim_name')=0);
dimensioncreate('dim_name');
else;
dimensionupdatedirect('dim_name');
endif;
by raman
Wed Sep 20, 2017 9:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: fileexists and dimensionexists
Replies: 8
Views: 5290

fileexists and dimensionexists

i am new to tm1. i want to make a ti process which first check wether the file exists or not, if fileexists then process should continue otherwise it should exit with a suitable message.then it should check for dimension and create or update according to availability of dimension.