cancel
Showing results for 
Search instead for 
Did you mean: 

BICS - Passing Mandatory Filter Variable value to a BEx Query

Former Member
0 Kudos

Hi All,

I have similar problem as the below URL.

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi

Check SAP Notes:1580524

Former Member
0 Kudos

Guyz,

Any update on this?

Thanks!

AK

sriramvijay_ravidoss
Contributor
0 Kudos

Hi Anil,

I assume you are using SAP direct connectivity.

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.

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?

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

Please let me know abt this issue,

Cheers,

Sriramvijay.R

Former Member
0 Kudos

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