Modify Bex Variable Selections in Virtual Cube Transformation Routine

[Former Member]

Hi Experts, hoping you can help 🐵

I have a Bex query on a Virtual Provider, which has some variable selections. In order for the VP to generate the required data, i need to modify one of the variable values to something different to that which the user has entered (long story, but critical to the data processing in the TRFN). However, I also need to capture the original value, because it is used in the end routine coding.

I know i can do this using the inverse routines in the transformation (which i have done & can see the correct value when i debug the query in RSRT), both the modified value (used to select the source data) and the original value (used to process the source data in the end routine).

Data is selected ok from the source, is processed correctly in the end routine, but even though everything looks ok, I always return zero records in the final query!

So here's my question: Is it even possible to make such a change? or will the query always return zero records because the changed variable is now different from that which the user originally entered.

Hope i have explained this well enough & that someone can help!!

Thanks,

Mike

[kohesco]

Hi,

I had to a similar coding about NEW GL and new company codes. When the report runs, they wanted to enter the new company code: H00. But they wanted to extract ABB data (old company code). So in my inverse routine, I changed H00 to ABB, so I pushed the correct company code through, When loading the data up, you must change it as well, to pass the query selection, so in the "normal" upwards transformation you have to set the swap again ABB to H00.

Worked perfectly!

grtz

Koen

[Former Member]

Hi Michael

Please read SAP note 1592982:

https://launchpad.support.sap.com/#/notes/1592982

Regards

Thomas