This content has been marked as final. Show 5 replies
I would suggest to use the table W_ETL_RUN_S to see the last max refresh date with status field completed.
You can find the table in your warehouse database.
You may go for any kind of approach to bring it to answers, the simplest approach is using repository variables
If helps pls mark as correct else update..
Edited by: Srini VEERAVALLI on Dec 11, 2012 10:38 PM
Yes I have created repository variable can u give me exact steps to show that on dashboard?
Use Narrative view to show in the report.
You can go with by adding it in the report as column,hide it and call in Narrative view using @1, assuming very first column in the criteria..
Hope this helps pls mark as correct/helpful
I want to show it using Text objects in dashboard can u guide me on syntax part?
Create repository variable get the date value from table and use that in the report by pulling any of the column on criteria->fx-> use VALUEOF("YourVariableName")
Hope this helps