Set Essbase Refresh timings in WebAnalysis Reports


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……

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.