Databases Reference
In-Depth Information
//ESS_LOCALE English_UnitedStates.Latin1@Binary
//This block of commands will turn a report script that create a
//report into a report script that creates an ASCII text flat file.
//If you look closely you should be able to recognize what some of
//the commands will do. For instance, the first one will suppress
//the page heading if any. The second command will suppress any
//column headings. The third command will suppress any page feeds that
//would have been sent to the printer had this been a multiple
//page report
{SUPPAGEHEADING
SUPHEADING
SUPFEED
SUPCOMMA
SUPBRACKETS
NOINDENTGEN
SUPMISSINGROWS
ROWREPEAT}
//This line tells Essbase how to set up the output data. For example,
//the first command tells Essbase to Tab delimit the output data
//columns.
<SETUP {TabDelimit} {decimal v} {IndentGen -5} <ACCON <SYM <END
//Define page members
<PAGE ("Total Market","METRIC")
//Define column members
<COLUMN ("Calendar Periods")
//Define row members
<ROW ("Total Vehicles")
//Select specific members to include in report
Sales
<CHILDREN "Total Market"
<CHILDREN "Calendar Periods"
<CHILDREN "Total Vehicles"
//Always end your script with a !
!
We have not altered the original script in any way except to add the commands we
explained at the top of the script. When we execute the same script now, we get
vastly different output results that are more suitable for a data extract than a report.
