SmartView provide options to download HFR reports in spreadsheets and carryout analysis as most analyst love to do. One common requirement which HFR do not offer as an out-of-box solution, is the ability to burst reports in spreadsheets. This post delves into an alternate approach to cater such requirements.
The code to retrieve sheet is shown below
- The code first checks existence of connection with name "MyConn". We can name it anything, more appropriately application-dbname
- In case the connection does not exist, it creates a connection
- Login to Essbase using the parameters passed
- Retrieve sheet and logout. We can all multiple sheets to retrieve
We can also add some VBScript code to email the spreadsheet to users (code not included here). You can download these files here.
Hope this helps !!!