Multiple Member Selection in Transactional Data Load

[simon_kussmann]

Hi,

I want to load transactional data from an Infocube to BPC.

My problem is, that I do not have all members available in BPC which are available in my Infocube.

It is possible to restrict my member selection in my conversion file?

So that all other members are skipped? The select options of the package is not what I want to use, because I have to select round about 100 members.

I want to validate the records, but this won't work with invalid members (n.a. in BPC).

Thanks and regards,

Simon

[Shrikant_Jadhav · Accepted solution]

Hi Simon,

You can use conversion file to skip the records.

e.g. the ID start with the 6 , 7. assuming 5 is max lent of ID

6????=*SKIP

7????=*SKIP

If you have specific property, you can filter it SET SELECTION.

Or simply ignore the rejected records.

Shrikant 

[Ankur_Jain1m8 · Accepted solution]

Hi Simon,

If you already have the list of your required members (over 100 as mentioned by you) you can list all the members in your conversion file and use the SKIP for rest all. For e.g.

Member 1 = BPC member 1

Member 2 = BPC member 2

...

...

...

...

.....

Member 100 = BPC member 100

* = *SKIP

Regards,

Ankur

[simon_kussmann · Accepted solution]

Thanks Ankur!

I already thought about that, it works!

[Former Member]

Hi Simon,

You need to find the best logical way to group them and then use *skip and allow others to pass through.

the worst case would be enter 100 members into the conversion file and *skip the rest.

Andy