Databases Reference
In-Depth Information
Also, it must be noted that if you are using a report script to create an actual report
which will be printed and viewed by others, then your report script can be long and
complicated and perform several tasks at once. If you recall, we mentioned earlier
that some types of commands can be used more than once is a script. Well, the
exclamation point is the delimiter that tells Essbase that a series of commands is over,
and the next set of commands begins a new part of the report. You also end a report
script with
!
, also known as a bang. This lets Essbase know it has finished.
Of course, if you're using the report script to generate a flat file extract to ship
downstream somewhere, then you will only use
!
once and only at the end of
the report script.
Let's begin writing our simple Essbase report script. If you have your Esscar database
outline set up the way we instructed you earlier in this topic, you should be able to
code the
test.rep
report script exactly as shown. Please enter into the report script
editor the following code and comments:
//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 !
!
Now, if you execute this simple script, you will get a report file that when opened
looks like this:
United States Sales Model Year
2009 2010
======== ========
2 Door Sedan 20,400 40,800
4 Door Sedan 20,400 40,800
4X2 Pickup 20,400 40,800
4X4 Pickup 20,400 40,800
