Skip to Content
avatar image
Former Member

Modify Bex Variable Selections in Virtual Cube Transformation Routine

Hi Experts, hoping you can help :o)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 17, 2017 at 07:35 AM

    Hi Michael

    Please read SAP note 1592982:

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

    Regards

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 17, 2017 at 11:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded