Skip to Content
avatar image
Former Member

SAP Cloud For Customer How to Pass the URL with Parameters of SAP BW / BI 7 Query Report in URL Mashup

Hello Experts,

I need help to calling BW / BI7 Query Report in Cloud For Customer using URL or HTML Mashup...

I am calling BI7 Query Report URL is below.....

URL http://<server>:<port>/SAP/BW/BEX

with URL Paramters

QUERY = ZZB_TPMCLM_Q0003 ( BI7 Query Name as a Parameter)

VAR_NAME_I = ZCUST_VAR_001 ( Selection Variable Name )

VAR_VALUE_EXT_I = 6000000002 ( Selection Variable Name value )

SAP-LANGUAGE = EN

CMD = PROCESS_VARIABLES

SUBCMD=VAR_SUBMIT

Please help me if the above parameters mention for the URL is correct or

When i click on Preview the URL link its calling the BI7 Query but the value are not populate and its no execute directly

but i need direct execute from passing Submit code or execute code

Like When i click on Preview the URL with above parameter fill up directly and go to the screen mention below

can anyone help me regarding solve this issue ?

Many Thanks,

Mithun


11.JPG (9.9 kB)
22.JPG (58.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 19, 2013 at 05:06 AM

    You can simply test the URL in a normal browser. Actually this would be your first test of the URL - just by itself.

    If it works there, it should work in a mashup. A mashup is generally a pass thru mechanism.

    If it works, in the mashup config, parse the parameters but leave them as fixed parameters.

    So just test things at 1 step at a time.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello all,

      Mithun, thanks for the parameters info you have passed above.

      But I have one related question: does exist any parameter to return the SAP C4C user that is exectuing the mash up?

      I have created some Mash Ups for some BW reports, and would like to filter the report by the C4C user is asking for it. Is it possible?

      Waiting for your kindly help and response.

      Best regards,

      Paco.