Sample Script to Export Data via a Tab-Delimited Text tile

// THIS SCRIPT IS DESIGNED TO EXPORT BOOKINGS, BOOKINGS ADJ AND UNITS
//CREATED SEPTEMBER, 2009
..



// Define the dimensions to list on the current page, as below
//None. We are not using this section.

// Define the dimensions to list across the page, as below
++COLUMN ("Time Periods", "Scenario")

// Define the dimensions to list down the page, as below
++ROW ("Product","Entity","Account")

//SETUP TO PLAY NICELY AS A TEXT FILE.

{ SUPMISSINGROWS
//Set to TAB Delimit
TABDELIMIT
//One decimal point
DECIMAL 1
//Width of each column in characters
WIDTH 12
//Suppress brackets for (negative), use a minus sign instead
SUPBRACKETS
//Suppress commas in thousands
SUPCOMMA
//Missing text just has space
MISSINGTEXT " "
//UNDERSCORECHAR " "
//To kill headers, get rid of the next line.
//SUPHEADING
//Do not indent headings
NOINDENTGEN
//Suppress automatic page heading.
SUPFEED
//repeat the row headings.
ROWREPEAT
}


// Select the members to include in the report

++DIMBOTTOM "Product"
++UDA ("Entity", "GEO")

//SETUP, PICK THE FIX WE WANT.
"Jul""Aug""Sep""Oct""Nov""Dec""Jan""Feb""Mar""Apr""May""Jun"
"FY09"
"Actual.Local.At.CSR"
"Local"
"BU Data"
"As Entered"
"Total Projects"
"Total Regions"
"Total Departments"
"HSP_InputValue"

//What do we want to get out?
"Bookings"
"Backlog adj"
"Bookings Units"
// Finish with a bang.
!