Skip Blank dimension in Data loads

[Former Member]

Hi All,

We have a requirement to exclude records which has blank value on a specific dimension (in Source BW cube).

Is there a way this can be achieved?

I don't want to load this on say "NODIM" member in BPC.

Thank you,

Pratap

[former_member186338]

In transformation file you add some constant to the member.

In conversion file you skip this constant!

DIM1=*STR(AAA)+0XXXX

Conversion

AAA    *skip

AAA*  *

[Former Member]

Hi Pratap,

What is the business logic behind ignoring records with blank members?? Can you explain?

I don't want to load this on say "NODIM" member in BPC.

Why not? I mean certainly you can name that member some meaningful name....

Regards,

JP

[Former Member]

Hi Pratap,

In your conversion file you can skip blank members, or in your selection during the transaction data load you can select a range for that info object, which will filter out blank members as well.

Andy

[Former Member]

Hi Andy,

Thanks for your response.

Filtering on package is litle tricky on this dimension. We dont have any specific range of values that I can put it. Unless I want to be really wild in putting something in the filter.

[Former Member]

Hi Pratap,

Yes, you can even use AAAAAAAAA to ZZZZZZZZZ or 00000000 to 999999999 in the filter.

that will include everything except the blank.

Andy