Skip to Content
0
Former Member
Sep 11, 2013 at 12:14 PM

Conversion file syntax for blank values

23 Views

Hi,

I am loading the property values for my account dimension - C_ACCT. The property here is Entity, i.e. each intercompany account has an entity value against it and rest accounts should have blank values.

My transformation looks like this.

*MAPPING ID=*IF(ID=*STR() THEN *STR(NO_ACC); ID) ACCTYPE=ID RATETYPE=ID RESTATE=ID SCALING=*STR(Y) DRILL_ID=0CHRT_ACCTS+ID ENTITY=ID *CONVERSION ID=C_ACCT_MD_CONV.xls ACCTYPE=C_ACCT_MD_CONV.xls!ACCTYPE RATETYPE=C_ACCT_MD_CONV.xls!RATETYPE DRILL_ID=C_ACCT_MD_CONV.xls RESTATE=C_ACCT_MD_CONV.xls!RESTATE ENTITY=TEST_Nitin_C_ACCT_MD_CONV.xls!ENTITY

My Conversion file looks like this.

EXTERNAL INTERNAL 1301080001 2000 1301080006 2000 1301080007 2000 1301080008 2300 * "What to mention here ???"

My requirement is, I want a blank value of Entity (Internal) for the remaining accounts (External). But I cannot use *SKIP for the remaining accounts because then it skips the accounts for other tabs of conversion file also. Is there a way to put blank values ?

Cheers,

Nitin