Essbase provides an advanced spreadsheet interpretation engine that scans a spreadsheet and interprets its content when fulfilling retrieval requests. This feature enables you to define spreadsheet layout through drill operations, Retrieval Wizard operations, or by typing members into the spreadsheet.
When you construct a report by typing member names directly in the spreadsheet in Advanced Interpretation mode, Essbase interprets the member names and creates a default view based on the location of the labels.
You can enter the name of a database member into a spreadsheet and use the Essbase Retrieve command to retrieve its data. You can enter a member name to add information to a spreadsheet, or enter member names in a spreadsheet to construct a custom report.