cancel
Showing results for 
Search instead for 
Did you mean: 

Restricting zero's in BPC account dimension ID

Former Member
0 Kudos

Hi,

     Actually what i want I have to put a condition that whenever there is "00" in the end of the ID it wont be loaded only the id with out 00 at the end will be loaded in the BPC master data

     

DATA IN BI:

ID               Rate_type     Account_type

70000100      AVG               INC

70000200      AVG               INC

70000110      AVG               EXP

70000120      CLO                INC

Now i need to post in BPC like this

ID               Rate_type     Account_type

700001          AVG               INC

700002          AVG               INC

7000011        AVG               EXP

7000012        CLO                INC

thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Please use js:... in the conversion file.

Vadim

Former Member
0 Kudos

I am so sorry for above posting, i want to restrict the members followed by two zero's at the end. because we can't change ID, i think for this solution we need to write start routine, so could some one help me with this start routine.

DATA IN BI:

ID               Rate_type     Account_type

70000100      AVG               INC

70000200      AVG               INC

70000112     AVG               EXP

70000121      CLO              INC

Answers (0)