Writing Report Scripts

Essbase report scripts consist of formatting elements and member selection commands. When writing report scripts:

The following snippet must appear at the beginning of the script:
```
{SUPFEED}{BLOCKHEADERS}{TABDELIMIT}<SINGLECOLUMN
{SUPCOMMAS}{SUPBRACKETS}{ROWREPEAT}{DECIMAL VARIABLE}
{NOINDENTGEN}{SUPMISSINGROWS}
```
{SUPMISSINGROWS} can be omitted if you need rows with missing values in the result set.

Follow formatting control commands by member selection commands; for example:

<Page (Product, Caffeinated, Ounces)
<Column (Year, Measures)
<ROW (Scenario, Market, Population)
"Jan" "Feb" "Mar" <Child "100"
<IDescendant "Population"
<IDescendant "Market" "Actual" "Sales" "COGS"

Use <SYM or <ASYM commands to control member selection along columns.
The Page axis definition should have all “real” dimensions from Essbase, which are not part of the Column or Row definitions.