Amending TI - help please

[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.

[wissew]

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')));

[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.

[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

[AWILDE]

Thanks Martin,

I have used this logic which worked fine.

Andrew