Search found 10 matches
- Thu Sep 28, 2017 7:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: loading data using parameters
- Replies: 3
- Views: 2843
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.
- Thu Sep 28, 2017 6:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: loading data using parameters
- Replies: 3
- Views: 2843
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.
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.
- Fri Sep 22, 2017 7:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: dynamic subset for last 5
- Replies: 1
- Views: 1466
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.
i used this
{drilldownlevelbottom({[segment].[all segments]},5)}
but this one is showing first 5.
- Thu Sep 21, 2017 11:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: reports using active form
- Replies: 1
- Views: 1818
reports using active form
can someone tell me how to make report using active form. i have perspectives installed.
- Wed Sep 20, 2017 12:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: fileexists and dimensionexists
- Replies: 8
- Views: 5412
Re: fileexists and dimensionexists
can you suggest if file is missing i have to exit the process with a message, how to do that
- Wed Sep 20, 2017 12:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: fileexists and dimensionexists
- Replies: 8
- Views: 5412
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...
- 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: 2847
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...
- 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: 2847
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.
-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.
- Wed Sep 20, 2017 10:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: fileexists and dimensionexists
- Replies: 8
- Views: 5412
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;
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;
- Wed Sep 20, 2017 9:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: fileexists and dimensionexists
- Replies: 8
- Views: 5412
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.