Page 1 of 1
Amending TI - help please
Posted: Fri Sep 03, 2010 3:34 pm
by AWILDE
Hi,
I am loading data through TI using ODBC and want to load a company code to a location in the entity dimension if the financial year is pre and including FY09 and if it is post FY09 I need it to go to another company code in the entity dimension.
Due to the complexity of the TI process I was wondering if it is possible to do this in the variable formulas so that the data appears as the different code number dependent on the financial year number. If not how is it best to do this? I am not very experianced with TI.
Any help appreciated.
Re: Amending TI - help please
Posted: Fri Sep 03, 2010 5:26 pm
by wissew
AWILDE wrote:Hi,
I am loading data through TI using ODBC and want to load a company code to a location in the entity dimension if the financial year is pre and including FY09 and if it is post FY09 I need it to go to another company code in the entity dimension.
Due to the complexity of the TI process I was wondering if it is possible to do this in the variable formulas so that the data appears as the different code number dependent on the financial year number. If not how is it best to do this? I am not very experianced with TI.
Any help appreciated.
Assuming your fiscal year dimension is index in accending order, you can create a variable for company code.
if(DIMIX(dimension, vFY)<=DIMIX(dimension, 'FY09'), 'a company code', if(DIMIX(dimension, vFY)>DIMIX(dimension, 'FY09'), 'another company code', if(DIMIX(dimension, vFY)=0, 'FY Not valid')));
Re: Amending TI - help please
Posted: Mon Sep 06, 2010 2:38 pm
by AWILDE
Hi I only want this to work for one company code all the others need to remain going to the same place. I am thinking of doing this through the SQL query on the data source.
Re: Amending TI - help please
Posted: Mon Sep 06, 2010 9:16 pm
by Martin Ryan
It will be easier to do this in the TI code rather than in the SQL/variables tab.
Let's say the entity from the source has the variable name vEntity and the year is vYear, in that case you could write the following at the top of the Data tab. It will override the vEntity variable only when necessary
Code: Select all
if(vEntity@='12345' & vYear@='2010');
vEntity='54321';
endif;
HTH,
Martin
Re: Amending TI - help please
Posted: Tue Sep 07, 2010 1:30 pm
by AWILDE
Thanks Martin,
I have used this logic which worked fine.
Andrew