I have a dashboard where my data are coming from queries linked to a universe. The queries are set to refresh every 5 minutes or when the user changes tabs. The queries are working fine when the user changes tabs. The problem is when I leave the dashboard alone and wait the 5 minutes. When I do I get Warning messages saying that I need to enter a value for a mandatory prompt. Sometimes the number of warnings is equal to the number of queries on the tab and other times it is many times the total number of queries in my dashboard.
My queries all use filters which have prompts. All of the prompts are linked to cells in the Excel. The values for those cells come from a Filter selector and a combo box. The warning give me not indication of what prompt is missing. All of my queries use the same three prompts. I am using SAP Dashboards 4.1 SP2.
Are your prompts set to forget the last value selected?
Do you have any other component on your dashboard that is clearing/overwriting the cell your prompt values are based on? Do you have “Remove destination when no value selected” checked on your filter components?
Do you have default values for your selectors and combo box?
Create a test component (single values or grid should do) over the cells that supply the prompts to the queries. Then you can see what values are in them before and after the dashbaord tries to refresh.
Thanks. Adding the grid to show the values was the answer. It turns out that we had two query results writing to the same set of cells. Now we make sure that we color code our cells so we know when they are being used either as query results or formulas.
(BOB member since 2006-03-01)
(BOB member since 2005-01-28)