Databases Reference
In-Depth Information
Summary
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
allow you to automate routine tasks, from the very basic and menial, to the large
and complex. You can turn everyday chores into automatically running batch jobs
that do everything from dynamically adding dimension members to the database
outline, to loading and calculation data, to actually building presentation and
analysis cubes.
