I’ve an issue…
I’ve built multiple dashboards using QaaWS and Xcelsius, and now I want to put the exact Time and Date, the dashboard is refreshed. For this, I simply wrote Now() in a cell and linked that cell to label text.
But, I am also using Connection Refresh Button to refresh my queries. Since the Connection Refresh Button only refreshes the Qaaws queries, the time on the Dashboard doesn’t change.
Any suggestions on this will really help.
Why don’t you include an object in your qaaws that grabs the system date/time (sysdate for oracle or getdate() for SQL server). Either as part of an exisiting qaaws or a separate query that just gets the date. I pull a simple date/time from one of my warehouse tables to display in a text component to show how up to date my data is.
I was required to add a refresh time as well to a Salesforce Dashboard.
Took awhile but got it in the end.
Hope its not too long.
Go to the Web service Query you have made and in the idle message in the load status:
This example I have placed in the word
“Last Refresh=”(I could of placed anything I liked into the field)
(I placed nothing in the loading message)
Then in your model make the Idle message go to a cell.
Next cell place in a reference to the next cell.
In another cell place in the formula, my example is:
IF(J7="","",NOW())
So J7 has the input from the qaaws, K7 has a reference to L7. L7 has the formula.
And there you go.
So when the dashboard loads I get the last refresh time of the query and when I click the query refresh it updates the time by updating the qaaws.
(BOB member since 2005-03-01)
(BOB member since 2014-03-19)