Sample 8: Creating Custom Headings and % Characters
This Essbase report script sample shows how to create a custom header for a report, and include percent sign (%) characters after each data value.
This report displays custom headings and percent sign (%) characters after each data value. This section shows a representative part of the output.
Prepared by: Admin The Electronics Club Page: 1
09/21/01
Profit_% Actual Stereo
Jan Feb Mar Apr May Jun
======= ======= ======= ======= ======= =======
New_York 1.43% -10.00% -3.51% -2.22% 1.14% -6.18%
Boston -0.34% -2.51% -4.44% -4.89% -7.02% -13.15%
Chicago -0.65% -0.72% -2.28% -3.53% -6.33% -10.79%
East 0.18% -4.47% -3.39% -3.41% -3.60% -9.70%
San_Francisco 1.43% -1.87% 4.42% 2.15% -1.26% 0.66%
Seattle 0.95% -5.66% 1.42% -6.82% -11.47% -12.34%
Denver 3.03% -1.11% -5.88% -6.52% -5.17% -13.83%
Los_Angeles -1.50% -3.94% -2.86% -3.29% 3.12% -2.51%
West 0.98% -2.95% -0.13% -2.81% -2.62% -5.61%
Dallas 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Houston 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Phoenix 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
South 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Market 0.65% -3.56% -1.44% -3.06% -3.03% -7.29% Prepared by: Admin The Electronics Club Page: 2
09/21/01
Profit_% Actual Compact_Disc
Jan Feb Mar Apr May Jun
======= ======= ======= ======= ======= =======
New_York 32.51% 29.95% 35.30% 32.70% 30.45% 31.73%
Boston 33.42% 27.92% 33.98% 30.74% 27.45% 30.85%
Chicago 34.29% 30.48% 26.33% 28.83% 28.11% 33.76%
East 33.35% 29.50% 32.30% 30.92% 28.77% 32.09%
San_Francisco 37.77% 35.02% 33.41% 33.23% 35.32% 37.95%
Seattle 40.41% 38.33% 38.89% 37.06% 37.01% 38.29%
Denver 31.93% 32.10% 34.82% 29.15% 32.71% 30.85%
Los_Angeles 31.65% 30.22% 30.22% 31.45% 27.06% 33.20%
West 35.51% 33.94% 34.21% 32.77% 33.16% 35.25%
Dallas 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Houston 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Phoenix 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
South 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Market 34.60% 32.10% 33.41% 32.01% 31.35% 33.97% Prepared by: Admin The Electronics Club Page: 3
09/21/01
Profit_% Actual Audio
Jan Feb Mar Apr May Jun
======= ======= ======= ======= ======= =======
New_York 19.35% 13.64% 18.64% 16.55% 16.70% 14.65%
Boston 18.34% 14.44% 18.94% 14.94% 12.14% 12.42%
Chicago 18.50% 16.67% 13.18% 14.12% 12.70% 13.74%
East 18.76% 14.88% 17.09% 15.32% 14.05% 13.68%
San_Francisco 20.32% 17.38% 18.92% 18.03% 18.23% 20.57%
Seattle 23.36% 21.40% 23.37% 20.17% 18.82% 19.04%
Denver 18.36% 17.25% 18.88% 13.43% 15.84% 12.14%
Los_Angeles 17.15% 14.76% 15.44% 15.76% 15.10% 17.07%
West 19.75% 17.53% 19.00% 16.88% 17.01% 17.52%
Dallas 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Houston 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Phoenix 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
South 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Market 19.34% 16.45% 18.21% 16.24% 15.78% 15.96% Prepared by: Admin The Electronics Club Page: 8
09/21/01
Profit_% Actual Product
Jan Feb Mar Apr May Jun
======= ======= ======= ======= ======= =======
New_York 22.71% 21.43% 13.11% 10.54% 9.73% 13.16%
Boston 24.98% 23.25% 19.95% 18.00% 17.03% 18.62%
Chicago 22.01% 17.94% 18.14% 15.45% 18.70% 16.01%
East 23.19% 20.84% 16.89% 14.42% 14.94% 15.78%
San_Francisco 23.71% 20.60% 21.93% 20.45% 21.44% 19.98%
Seattle 21.06% 21.05% 21.24% 19.00% 21.72% 15.13%
Denver 21.61% 16.01% 19.79% 14.81% 20.66% 13.89%
Los_Angeles 17.54% 15.51% 17.03% 14.33% 17.59% 16.09%
West 21.02% 18.35% 19.99% 17.26% 20.30% 16.61%
Dallas 15.67% 16.50% 15.32% 13.93% 20.36% 15.49%
Houston 20.01% 20.29% 20.62% 15.87% 23.60% 12.38%
Phoenix 20.01% 16.12% 17.18% 16.50% 21.39% 15.22%
South 18.39% 17.53% 17.59% 15.36% 21.66% 14.46%
Market 21.37% 19.09% 18.46% 15.92% 18.67% 15.93% Use the following script to create Sample 8:
<PAGE (Accounts, Scenario, Product)
{ PAGEONDIMENSION Product } // New page when Product changes
Profit_%
Actual
<IDESCENDANTS Product
<COLUMN (Year)
Jan Feb Mar Apr May Jun
<ROW(Market)
{ STARTHEADING
TEXT 1 "Prepared by:"
14 "*USERNAME"
C "The Electronics Club"
65 "*PAGESTRING"
TEXT 65 "*DATE"
SKIP
ENDHEADING }
{ Decimal 2 AFTER "%" SUPBRACKETS } // Place % at end and
// suppress bracket
<IDESCENDANTS Market
! Each data value in the report has a percent sign, %. This label is defined with the AFTER "%" format command. You can specify any character within quotation marks.
This report has custom headings at the top of each page. All format commands specified between the STARTHEADING and ENDHEADING format commands are displayed at the top of each report page.
TEXT format commands define text labels. The report generator provides dynamic text with *options. This report uses the following options:
-
*USERNAME, which outputs the user name used when connecting to Essbase Server
-
*PAGESTRING, which outputs the current page number of the report
-
C, which centers the report title