BLOCKHEADERS

The Essbase Report Writer BLOCKHEADERS command displays all members that apply to a column as the column heading, in the style used by asymmetric reports.

Note:

This is the only format that can be used with asymmetric reports. Pyramid headers are the default for symmetric reports.

Syntax

{ BLOCKHEADERS }

Notes

BLOCKHEADERS is a setting command.
BLOCKHEADERS can be useful when columns are reordered and previously symmetric upper-tier column headers no longer align properly.
BLOCKHEADERS ensures right-justified alignment of all columns.

Example

The following example is based on Sample Basic.

<PAGE Measures)
Sales
{WIDTH 7}
{BLOCKHEADERS}
<SYM 
     <COLUMN (Scenario, Year, Market)
     Actual Budget
     Jan Feb
     East West
<ROW (Market)
<IDESCENDANTS "400"
     !

This example produces the following report:

                                                                      Sales 

                 Actual Actual Actual Actual Actual Actual Actual Actual Budget Budget Budget Budget Budget Budget Budget Budget 
                    Jan    Jan    Jan    Jan    Feb    Feb    Feb    Feb    Jan    Jan    Jan    Jan    Feb    Feb    Feb    Feb 
                 400-10 400-20 400-30    400 400-10 400-20 400-30    400 400-10 400-20 400-30    400 400-10 400-20 400-30    400 
                 ====== ====== ====== ====== ====== ====== ====== ====== ====== ====== ====== ====== ====== ====== ====== ====== 

East                562    219    432  1,213    560    243    469  1,272    580    230    440  1,250    580    260    490  1,330 
West              1,115  1,032    625  2,772  1,122  1,065    618  2,805    740    690    410  1,840    740    700    400  1,840

Related Topics

PYRAMIDHEADERS