Creating HTML Mashup to get the BI Query with Mapped with Account ID

[Former Member]

Hi Experts,

I Need Help Regarding the HTML / URL Mashup to get the Data from BI Query using Customer OnDemand Account ID

I have created the Mashup HTML type URL and pass the URL of the BI Query and Add the Parameters in sequence below...

1) QUERY                              - : Provide the constant Query name

2) ZCUST_VAR_001             - :  Mapped with the Account ID of the OnDemand System 

3) sap_user                           - : BI System User

4) sap_password                  - : BI System Password

5) SAP-LANGUAGE             - : /$System/LogonLangua

When i click on Preview button then the BI Screen display but with all the Account ID not for the Specific account ID

Also Pleas check the below screen

this is the same when click on preview button he comes with all data not specific like - : 6000000002

I want to ask the above parameters have any problem or we need more parameter require to add and Why its not display for specific customer but display all customer there is something wrong in BI query

Please anyone have solution of this please share with me its urgent i really appreciate if anyone have documentation of same please share with me

Many Thanks in Advance

Regards,

Mithun

[Former Member]

Hi Mithun,

I have similar requirement. Did you get any solution for the above post. Suppose I want this Account ID to be passes dynamically as a parameter to the HTML Mashup what am I supposed to do.

Please share your ideas regarding the same.

Thanks,

Srinivasan

[Former Member]

Hi Srinivasan S,

You need to follow below steps :

1) Take BI query with customer id parameters (please note down technical name of Customer Id that is given in BI query).

2) Also maintain BI query name.

After that please use below parameters to achieve this.

Regards,

Mithun

[Former Member]

Hi Mithun,

Can you tell me what should I add in place of query and when I try to bind the ID as in your last parameter I don't find any option for the same.

Please help me on this.

Thanks,

Srinivasan

[Former Member]

Hi Srinivasan S,

Please check below details for parameters :

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
VARIALBE_SCREEN	Variable screen value is blank or X if blank then skip the variable screen
TEMPLATE_ID	BW / BI Report(Query) template to make the change in query view

Regards,

Mithun

[Former Member]

Hi Mithun,

Thank you for the reply. Will get back to you if I have further queries.

Regards,

Srinivasan