I once had a client who wanted to get the Essbase refresh time in their WebAnalysis Reports.
If you are familiar with WebAnalysis Reporting Studio, there is an option where you can add a label to an existing report.
Insert a LABEL in an existing report, do a right click in the Insert Text area and select <<dbnote>>
Now we have to create a database note in Essbase. For that we’ll use a small UNIX script (The date command in Windows can be also used, but then it is based on the regional settings, so you have to check the output how it is coming.)
set_dbnote_refresh()
{
printf “spool on to /CERA/logs/Maxl_logs/refreshdbnote.txt;n” > ${ESS_MAXL_DIR}/PMS_REFRESHDBNOTE.txt
printf “login CERAAdmin identified by `cat $SECURE` on `cat $SVRNAME`;nn” >> ${ESS_MAXL_DIR}/PMS_REFRESHDBNOTE.txt
printf “alter database Sample.Basic set note Last Refreshed: `date ‘+%m/%d/%Y %H:%M’`’;n” >> ${ESS_MAXL_DIR}/PMS_REFRESHDBNOTE.txt
printf “logout;nn” >> ${ESS_MAXL_DIR}/PMS_REFRESHDBNOTE.txt
printf “spool off;n” >> ${ESS_MAXL_DIR}/PMS_REFRESHDBNOTE.txt
printf “exit;n” >> ${ESS_MAXL_DIR}/PMS_REFRESHDBNOTE.txt
}
Execute the Maxl and check whether the database note came in.
Open the report in WebAnalysis and see the refreshed time there in it.
Hope it helps……
