Skip to Content

BI Query Parameters

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 28, 2006 at 07:21 PM

    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-b89287cf330f

    for the correct syntax...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Kenneth Murray

      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.

  • avatar image
    Former Member
    Feb 19, 2007 at 09:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Feb 19, 2007 at 11:02 AM

    Hi Marcel,

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

    Best Regards

    Ravi

    Add comment
    10|10000 characters needed characters exceeded