How to Skip Entire column from Source file while load MD from Flat file in BPC

[Former Member]

Hello Experts,

I am loading flat file MD and noticed there is some BPC limitation. For example I have one property "ABC" in dimension and source file also have the same property name "ABC". I do not want to bring that property data and I did not mapped this property in transformation file. If the property name is exactly same in both source and Dimension, then system reads it and updates property "ABC" in dimension.

Is there any way I can skip "ABC" while loading MD using DMP.

Your input highly appreciated.

Inaam

[Former Member]

Hi Inaam,

So are you saying that you only want to update the property when there isn't a existing value in BPC?

You can call routine (ABAP) in your transformation file to do that for you.

Andy

[Former Member]

Thanks Andy for your input. There is a specific function by SAP which Vadim mentioned and it worked.

Inaam