Getting the most out of the Microsoft Excel Add-in - Oracle Essbase 9 Implementation Guide - page 260

Using the currency conversion tool
To use the Essbase | Currency Report… function you must purchase a separate
license for the Essbase currency conversion tool. Unless you have extensive currency
conversion needs there are ways to create financial data without it.
The Essbase | Currency Report… function enables you to perform ad hoc currency
conversions during data retrieval. When you select Essbase | Currency Report…
the Essbase Currency Report dialog box is displayed. If you have implemented
a currency conversion application you can use the Currency Report command to
dynamically perform currency retrievals and currency conversions.
Custom Microsoft Excel workbook reporting
The Essbase | Cascade… command allows you to replicate Microsoft Excel
worksheets using member combinations. You can have retrieved data flow across
multiple Microsoft Excel worksheets in the same Microsoft Excel workbook, or you
can create multiple cascaded Microsoft Excel workbooks stored in different locations.
When you select Essbase | Cascade… the Essbase Cascade Options dialog box
is displayed.
The Essbase Cascade Options dialog box has three tabs that allow you to set
the formatting and storage options for the cascaded reports you will create:
• Cascade Information : On this tab, you select what outline members
you want to cascade on and the zoom level you wish to zoom to.
• Destination Options : On this tab, you can choose where to store the
newly created Microsoft Excel workbooks.