As in Advanced Interpretation mode, with Free-Form mode you can enter dimension members in the spreadsheet and retrieve a report. In Free-Form mode, you can also enter Essbase Report Script Editor commands to retrieve data into a spreadsheet.
Report Script Editor commands are most useful for defining member references that can dynamically bring back the most current member information. 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. See the Oracle Essbase Technical Reference and the Oracle Essbase Database Administrator's Guide.
