Restricting zero's in BPC account dimension ID

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