Skip to Content
0
Former Member
Sep 30, 2009 at 01:41 PM

Dynamically change selection filter in transformation

35 Views

Hi,

does anyone know how to solve the following problem?

I am loading transactional data from BW to BPC through data manager.

In my transformation file I am using the following parameter to restrict the amount of data being loaded:

SELECTION=/CPMB/I0D8CUP,2009.12;/CPMB/I0DFYJU,353;/CPMB/I0DGDMY,CPOJ

Right now the user has to manually edit this parameter. What I would like to have is that the user can dynamically change the constants through a data manager prompt.

Does anyone know how to handle this?

Perhaps there is another way how to dynamically set the filters but I haven't found it yet.

Any advice will be highly appreciated.

Jan