Databases Reference
In-Depth Information
Getting the most out of the
Microsoft Excel Add-in
In the real world it is no secret that a very large percentage of data and financial
analysts do their jobs using Microsoft Excel. It is also no secret that a very large
percentage of these same analysts actually like Microsoft Excel very much and
enjoy using it.
This is probably why, after you tell them that they can continue to use Microsoft
Excel to do their jobs even with the addition of Essbase, you will see a large smile
spread across their faces. Just wait until you tell them they can continue to use
Microsoft Excel but can now perform complex data analytics and create professional
looking reports by taking advantage of the easy to install and use Essbase add-in.
Our guess is that you will be peeling them off of the ceiling.
Get ready, because after all of the prior instruction, it is now time to actually learn how
to use Essbase and the Essbase add-in to connect to the Essbase database, analyze data,
modify or create data, create reports, run database calculation scripts, use the really
cool Query Designer function included in the add-in, and a whole lot more.
Reporting with the Microsoft Excel Add-in
Assuming you have the Essbase Add-in for Microsoft Excel installed on your PC you
will see the
Essbase
menu pick available on the main Microsoft Excel menu toolbar.
If you read how to install the add-in but did not do it, please install it now for you
will need it in this chapter.
