BI Query Parameters

[sap_cohort]

I have done everything I can to pass a Date Range to a BI Query in Visual Composer to no avail. I created a form with 2 date fields and tried various ways to send them to the query variable. I got it to work when I used a user exit variable and populated the values using abap, but I can't get it to work when using a form in Visual Composer.

Does anyone have an example of how to pass in a Date Range to a BI Query from a Visual Composer Form?

Thanks,

Ken Murray

[Former Member · Accepted solution]

You have to serialize it. The data range in BI is passed to the same field that means your two date fields have to come together somewhere and pass this value to the date field of the data service.

Take a look at the Value Help Wizard that does exactly this. You can select there "Intervall" (or was it "Range?) and after exiting the wizard, you can take a closer look into the generated model and the syntax.

See also the document

How to work with Variables

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/07134c67-0b01-0010-0493-b89...

for the correct syntax...

[Former Member · Accepted solution]

Here is the Visual Composer WIKI:

https://wiki.sdn.sap.com/wiki/display/VC/Howtoselect+ranges

[sap_cohort · Accepted solution]

Thanks for your help. I was unable to find anything on this topic. Also, thanks for putting it on the Wiki!

Ken Murray

[Former Member · Accepted solution]

Yes, it's tricky, as it runs under a different name and you have to be aware of this. But now hopefully people will be able to find it better.

[Former Member]

Hi Marcel,

Thanks a lot, now i can able to pass the date range.

Best Regards

Ravi

[Former Member]

Hi Ravi,

I forgot to mention, that you also could have a look into the VC WIKI:

<a href="https://wiki.sdn.sap.com/wiki/display/VC/Howtoselectranges">https://wiki.sdn.sap.com/wiki/display/VC/Howtoselectranges</a>

Best Regards,

Marcel

[Former Member]

hi,

I have read the document "How to Work with Variables in SAP NetWeaver Visual Composer" and still i could not able to pass date range. I am working on EP7 with BI 7.0

Could you any one help me resolving the issue. I am not able to pass the date range to Data Service in VC

[Former Member]

Hi Ravindra,

you can pass a range

[first data]:[second data]

If you need more information you should read the WEB API Documentation.

Best Regards,

Marcel