Hope you are doing great.
How to handle the transformations in the ERPI which source is in Flat file?
My source has blanks which needs to be transformed to a default member in the HFM
also source has members like '00' which needs to be transformed with a prefix like '00' needs to be as D00
How to handle this at ERPI level?
To map something to a default member you can use a simple WILDCARD mapping:
* to DEFAULT MEMBER
To add a prefix either do it in the import format, or using a wild-card mapping depending.
Take a read of this document:http://docs.oracle.com/cd/E17236_01/epm.1112/erpi_admin.pdf