cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation file - Transactional data from BW info provider

former_member212723
Participant
0 Kudos

In the transformation file that will be used to load transactional data from a BW info cube, would like to restrict the selection of accounts to a range, say 500000 to 699999.

What should be the logic/code in the options section of the transformation file?

For a specific values, it looks like this is the logic

SELECTION = ZACCT01,500000; ZACCT01,500001 ( ZACCT01 being the technical name of characteristic and 500000 & 500001 being the value of characteristic/dimension member)

Any help appreicated in providing the logic for the range to be used in the transformation file.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member200327
Active Contributor
0 Kudos

What version of BPC are you using? In 7.5 there is a new process Chain /CPMB/LOAD_INFOPRIV_UI that allows dynamic selections. This Process Chain is delivered not active.

In Transformation file you can't make range selections - single values only.

former_member212723
Participant
0 Kudos

Thanks Gersh. This helps and this is what I am looking for.

We are on NW 7.5 SP4. I see the process chain /CPMB/LOAD_INFOPROVIDER but do not see the process chain /CPMB/LOAD_INFOPRIV_UI that you are referring to. How can I activate this? Truly appreciate your help on this.

Regards

Former Member
0 Kudos

HI

Al Sathappan , you can go to tcode RSPC on BW side, if you cannot see the process chain you should go to RSA1 and activate from business content

I hope you help