Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 27, 2014 at 11:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Mar 16, 2014 at 06:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded