Well, there you have it! In this chapter we have learned how you can generate reports using the Essbase Add-in for Microsoft Excel or Visual Explorer or Essbase Query Designer, as well as the capabilities of each type of reporting. What we recommend now is to just start playing with the add-in. Try creating custom data sheets by first performing simple retrieves. Then, as you become more comfortable and confident, you can begin setting up advanced row and column headings by using the double-click and pivoting functions or by using the fully functional Essbase Member Selection tool to populate your spreadsheet's row and column headings. Once you've become adept at setting up good looking spreadsheets and reports, you can start playing around with retrieving data into your sheets, then Locking and Sending the data back to the database.
Next up, is how to automate your Essbase database system. We will show you an assortment of functionality options included in your Essbase package that...
