SAP BPC 10.0 : Filter not equal to blank

[Former Member]

Hello

We have a requirement to map transaction data for a product for production order ( characteristics) not equal to blank.

For Eg.

product  Mov type p oder  amount

ABC       101           0001    10000

ABC       101                      15000

In the above example I want to map only those transaction data which has p order no ie only the 1st case and skip the second case.

I would like to know the options available in BPC to link transaction data with a characteristics not equal to blank.

I do not want to use the selection file option as the series are not pre defined for production orders.

Regards

ATG

Message was edited by: ATG BPC

[former_member186338]

Sorry, but not clear... What dimensions do you have? What is p order?

[Former Member]

Thanks Vadim,,

P order is one of my fey fields (Production order number) .

Dimension I have is as follows:

1. PRODUCT

2.CATEGORY

3.TIME

4.ENITY

5.CURRENCY

6.UOM

My requirement is to map only those values which has production order ie key field Porder and skip the blank for the respective product.

Regards

[Former Member]

Hi,

Not sure if this can be done by transformation file mapping.

You can write a Start Routine and include it in the transformation file to skip the records.

Thanks,

Varsha

[former_member186338]

Please explain what you are talking about? Data load from BW or...?