cancel
Showing results for 
Search instead for 
Did you mean: 

Only some users facing issue that "One or more mandatory variables of query XXX not filled"

Former Member
0 Kudos
66

Hi XCelsius Guru,

We have a dashboard in XCelsius that is based in multiple BW Query. This BW Query has one a variable which is not mandatory but initialized. I did the connection the bw query with xcelsius and everything was fine, but for few users when they try to execute the dashboard with the url link if gives the below error meaasge.

"One or more mandatory variables of query XXXXXX not filled"

For this user everything was working fine few days back but is showing error now but no authorization has been changed.

Regards,

Ankit

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi All,

The issue has been resolved. Thank you all for your help.

The issue was that the default date format for both the users was changed to MM/DD/YYYY while it should have been DD.MM.YYYY as it is the format in which the dashboard is taking the input. The mismatch in the date format was causing error.

How it was identified :  When I chacked all the access of the user's I only found this format which was different from m ID and for both the ID it was same. When I tried to execute the BW report too for the user's it was automatically taking the format as in their ID so report was executing fine but not the dashboard.

Finally the issue is resolved.

Thanks,

Ankit

former_member182541
Active Contributor
0 Kudos

Hi Bro,

Happy that you have done many R&D to identify the issue and closed it. These issue commonly arises when the end users are not aware, what is running behind the scene Please do close the thread if the issue resolved.

Answers (1)

Answers (1)

former_member182541
Active Contributor
0 Kudos

Hi,

Take a look at this SAP Note:  1580524 - Xcelsius Dashboard does not display variable popup

Also go through the below discussion, it may help you.

One or more mandatory variables of query XXX no... | SCN

Hope this helps brother.

Regards,

Suman T

Former Member
0 Kudos

Hi Suman,

Thank you for the reply.

The issue here is that note is already implemented and only 2 users are facing this issue while for all others the dashboard is working fine,

Regards,

Ankit RUngta

former_member182541
Active Contributor
0 Kudos

Hi Ankit,

Does the issue has been solved or still the error persist, Try to execute the BW report for the particular user in their id and check it.

Suman T

former_member195290
Contributor
0 Kudos

Hi Ankit,

Check the User Authorizations.

Also , can you create a new user with same permissions and check if you are facing the same issue.

Regards,

Javed

Former Member
0 Kudos

Hi Sman,

Issue still persists, The BW report is executing fine for the user.

Regards,

Ankit Rungta

Former Member
0 Kudos

Hi Javed,

We already created a test user but the dashboard is working perfectly for the test user with the same authorization. We also checked for the personalization but there is no personalization for the user.

Regards,

Ankit

former_member195290
Contributor
0 Kudos

Hi Ankit,

It seems that everything is running fine only, can you recreate the user causing the issue.

Regards,

Javed

Former Member
0 Kudos

Hi Ankit, Could you please check if it's returning error in RSTT trace with below note, maybe that we can clarify the issue is coming from BW BICS or BO perspective. 1925924 - How to enable RSTT Trace in SAP BW for Frontend Tool(SAP BI & 3rd-party Tools) https://support.wdf.sap.corp/sap/support/notes/1925924 Thanks Shengjun