Skip to Content
avatar image
Former Member

Passing a range of dates from Visual Composer 7.0 to Bex Analyzer

Dear Experts,

I created a button in my Visual Composer model that has the following settings:

System action: Hyperlink

Apply to: Self

Hyperlink address: "...QUERY=BMMSEG_C01_SAS_Q0001&BI_COMMAND_1-BI_COMMAND_TYPE=SET_SELECTION_STATE&BI_COMMAND_1-TARGET_DATA_PROVIDER_REF_LIST-TARGET_DATA_PROVIDER_REF_1=DP_1&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-CHARACTERISTIC=MBUDAT&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-SELECTION_1-SELECTION_INPUT_STRING=08/22/2006;08/28/2006"

Basically, what I need is to pass a range of dates from Visual Composer to Bex Analyzer on the characteristic "MBUDAT". However, it only brings back the data with those specific dates, not the range.

I don't think this is the correct syntax to pass in a range value: 08/22/2006;08/28/2006 Please advise how should I do it.

Thank you in advance,

Kevin

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 10, 2010 at 01:48 AM

    Hi all,

    I also tried this format with the colon: 08/22/2006:08/28/2006

    but then it only returns the data with 08/22/2006.

    Thanks,

    Kevin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2010 at 11:26 PM

    Hello

    i had the same requirements for one of my dashboards.

    The way i solved it was:

    1. create a Date range variable on bex query

    2. Create a Form with 2 input boxes (a Date from and a Date To)

    3. In that form add a button which concatenates the "Date From" + ":" + " Date To"

    4. pass that concatenated value to your Bex query

    this seems to work quite well

    please let me know if u need further info or explanation

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      How can select the variable with document date range. For ex: I am creating query for due date analysis, i want to select under 30 days, and 31 to 60, 61 to 90 days and 91 days and over. I want to restrict to using range between, but it is not working. Can anyone suggest me how to fix this problem please

      Regards

      Ravi