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

[Former Member]

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

[SAPjedi · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks for your reply...

I have tested the Google Map URL using Parameter in Account Detail on Address City Mapping With Google Map Parameter and its working fine in Account Screen When click on Web Service on Right Top Corner of the Thing Based Screen of Account 

But I have tested the URL many times in normal browser as well as i have change the URL parameter many times and check the URL using preview button but every time same response comes so can you please tell me or can you please give me the sample URL so i can test that URL any System so i can understand easily.

Thanks,

Mithun

[SAPjedi · Accepted solution]

You may need to work with your BI SME to see what's happening.

The fact you got Google maps to work tells you it's a pass-thru mechanism works fine.

BTW, I find the Preview button is not 100% dependable.  Probably best to author the mashup and try it for real in the WebService button.

[apoorva_singh · Accepted solution]

Hi Mithun,

we have a similar requirement. Did this mashup approach worked for you.

-Apoorva

[Former Member · Accepted solution]

Yes

Kindly use these parameters mentioned below for configure the mashup,

Parameter Name	Parameter Value
QUERY	Query name of the Report from BI / BW
VAR_NAME	Name of the above query parameter name / variable name
VAR_OPERATOR	EQ / LT / GT / LE / GE / BT
VAR_SIGN	I or E
SAP_USER	Username of the BW / BI system
SAP_PASSWORD	Password of the above username
VAR_VALUE_LOW_EXT	Variable Low value
VAR_VALUE_HIGH_EXT	Variable High value When VAR_OPERATOR = BT

Many Thanks,

Mithun

[apoorva_singh · Accepted solution]

Thanks Mithun. We'll try this approach.

[pacosola1 · Accepted solution]

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.