SELECTION OPTION Not Working in Transformation File - SAP BPC 10 NW

[Former Member]

Hello,

We are loading transaction data from a BW infocube to BPC. For this, we want to filter out data based on a certain criteria (0BUS_AREA). Surprisingly, the SELECTION option is not working in the transformation file.

We are using the below condition:

SELECTION=0BUS_AREA,WTCH

We do not want user to select the Infocube name and Selection criteria through GUI as they are prone to commit mistakes in selecting the same and hence want to use the SELECTION Option. The Infocube's name will be handled/hardcoded in the DM Package's advanced script. However, surprisingly, it is not working for us. We are in CPMBPC Release 801, Level 0002. It used to work perfectly in my previous project which was on NW 7.5.

Are we missing anything ? Appreciate your suggestions.

Thanks.

[Former Member]

Hi Venkat,

In BPC 10, we can do the selection as follows.

After clicking the validate & Process Tranformation File and enter the infoprovider name.

Click on “Set selection” tab. You can see the below screen. Select the Dimension field and enter the values.

Click on “Save”.

Give the selection file name and Save it.

Then Click on “ Save as”

Enter the Transformation file name and save it.

While running the data load package, Provide the transoformation file name and run.

Hope this will helps you.

Regards,

Praveen

[sean_chen]

I had same issue as Venkata's and applied your solution and fixed the issue.

[Former Member]

Hi,

    We have sent this issue to SAP and we got the reply that this SELECTION option has removed in the  EPM 10 version,as an alternative there has provided the selection GUI while loading the data from data manager.

[former_member200327]

HI Venkata,

You can hard code that selection in Dynamic Script of your Package; then user won't have to select and make a mistake.

Gersh

[Former Member]

Dear Gersh,

Thanks for your advise. Do you have a sample code for this that I can see and reuse for this purpose.

Thanks.

[P.S: Currently, we are using the SELECTION Option as in the DM package].