Retrieving Data into Formatted Worksheets

Formatted worksheets can contain these formats:

Spaces between rows and columns
Cell values that contain text or data that is not defined in the database outline
Member names in noncontiguous locations at the top of a worksheet
Spreadsheet formulas (see also Lesson: Preserving Formulas When Retrieving Data)
Visual cues (styles)

To retain the formatting when retrieving data into a formatted worksheet, you must specify certain options.

To retrieve data into a formatted worksheet:

Select Essbase, and then Options.
In Essbase Options, select Mode.
In Formula Preservation, select Retain on Retrieval, to enable Formula Preservation mode.
Note:
Selecting Retain on Retrieval may cause slight delays in retrieval time.
By default, an Essbase retrieval overwrites the spreadsheet formula with data values in the retrieval area of a worksheet. The retrieval process also eliminates formulas in cells outside the retrieval area. The Retain on Retrieval option, however, enables you to define retrievals that do not overwrite formulas in the worksheet.
Select Display.
To set column widths to fit the data, in Cells, select Adjust Columns.
To save these settings, click OK.
To update the worksheet with the latest data values, select Essbase, and then Retrieve.
Essbase determines whether all text cells in the worksheet correspond to database member names. When Essbase is unable to resolve text values in the worksheet, a message box is displayed.
Click Yes to display the next unknown member or No to continue with the retrieval.
Tip:
You can disable the unknown members message by clearing Display Unknown Members from the Global page in the Essbase Options dialog box.