Skip to Content

BICS - Passing Mandatory Filter Variable value to a BEx Query

Hi All,

I have similar problem as the below URL.

BICS - Passing variables to a BEx Query

Details:

I have a mandatory filter - Display Currency in BEx query. I'm trying to input this mandatory filter from Xcelsius, (by mapping the filter value to a cell in Xcelsius spreadsheet).

However, when I lauch the dashvoard in IE page, it still throws an error:

" One or more mandatory varaibles of the query... are not filled"

Does anyone face this issue?

Regards,

AK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 13, 2011 at 05:48 PM

    Guyz,

    Any update on this?

    Thanks!

    AK

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sriram,

      I assume you are using SAP direct connectivity.

      >> Yes, it is direct connectivity to SAP-BW.

      (And I'm publishing this dashboard in SAP-BW system itself.)

      1. What are all the Variables you get in intial variable screen?

      because if you have a Mandatory variable in your Bex query, a intial variable screen will appear with all the variables.

      >> I'm testing the underlying BEx query, it has one mandatory variable for "Display Currency". Other are optional variable-filters, so other filters are not a problem.

      2. when you get this error "One or more mandatory varaibles of the query... are not filled", just after the Launch or after the variable screen?

      >> I use the option in Xcelsius: SAP --> Launch --> a new IE page opens, then I get this error

      3. However you can bye pass this screen only when you give default values to your mandatory variables.

      >> When I use personalization in BEx side, to input default value (e.g: USD), and then run this standard content dashboard, the hangs.(Do not see anything on IE page for long time. Though the data is very less-Few hundres rows)

      So, I'm looking at passing the value from Xcelsius-spreadsheet, however, the dashboard is not picking up the value from the mapped-cell.

      Hope this gives more clarity on the problem.

      Cheers,

      AK

      Edited by: Anil Kumar2981 on Jun 16, 2011 12:12 AM

  • avatar image
    Former Member
    Jul 07, 2011 at 09:52 AM

    Hi,

    We have the same issue. But in our case the variable pop-up screen was appearing before the BW upgrade to EHP1 SP8. When we built the dashboards using xcelsius BICS connections, BW version was EHP1 SP5. Would appreciate if anyone can confirm if this is an issue with the latest patch SP8?

    Tahnsk in advance.

    Regards,

    Anitha

    Add comment
    10|10000 characters needed characters exceeded