Retrieving in Template Retrieve Mode

Template Retrieve mode enables you to define reports using the Essbase Report Script Editor command language. Report Script Editor commands let you select data items and place them in a row or column of the worksheet. See the Oracle Essbase Database Administrator's Guide.

The major difference between Template Retrieve mode and the standard retrieval mode is that Template Retrieve mode enables you to dynamically query branches of member in dimension trees. For example, if you must create a report that shows every product, including those added since the last retrieval, standard retrieval mode only reflects these changes when you drill down on the product. The Report Script Editor command <IDESCENDANTS retrieves all descendants of a member in the database, including the specified member.

Notes:

In Template Retrieve mode, Zoom In, Zoom Out, Keep Only, Remove Only, and Pivot commands are unavailable.
If you are connected to an application and database that supports duplicate member names, you cannot perform retrievals in Template Retrieve mode.
To use Dynamic Time Series in Free-Form or Template Retrieve mode, do not put the Dynamic Time Series and the latest member (for example, Q-T-D(Feb) in one cell. You must enter the Dynamic Time Series member, Q-T-D, and the latest member within parentheses, (Feb), in adjacent cells). In Free-Form mode, you must enclose the Dynamic Time series and the latest member in quotation marks (for example, "Q-T-D" ("Feb")).
Do not use Report Writer formatting commands, such as {BRACKETS}, {DECIMAL}, and {EUROPEAN} in Free-Form mode, because they are incompatible with the Excel formatting features.
Unlike Oracle's Hyperion® Web Analysis, Spreadsheet Add-in does not recognize changes to member aliases in the outline that are made while the add-in connection is active. Depending on the details of the changes made and the structure of the spreadsheet, affected data cells may show missing or incorrect data upon retrieval after the change, and error messages are generated.

To retrieve data in Template Retrieve mode:

Select Essbase, and then Options.
In Essbase Options, select Mode.
Under Retrieval, select Free Form.
Select Template Retrieve.
In the spreadsheet, enter the report script command you want to retrieve.
For example, the report script command <IDESCENDANTS Product tells Essbase to retrieve all descendants of the Product dimension.
Select Essbase, and then Retrieve.