TABDELIMIT
The TABDELIMIT Report Writer command in Essbase places tabs, rather than spaces, between columns. This command is useful when you want to turn report output into a more compressed form for export. TABDELIMIT can occur anywhere in a report script.
Syntax
{ TABDELIMIT }Example
The following report scripts are designed for the Sample Basic cube, available in the gallery section of the Essbase file catalog.
<PAGE (Scenario)
<COLUMN (Year)
<ROW (Product, Market, Measures)
{Tabdelimit}
{ROWREPEAT}
<ICHILDREN Year
<DIMBOTTOM Product
<DIMBOTTOM Market
<CHILD Profit
!
The above example produces the following report (example truncated):
Scenario
Qtr1 Qtr2 Qtr3 Qtr4 Year
100-10 New York Margin 1,199 1,416 1,568 1,184 5,367
100-10 New York Total Expenses 433 488 518 430 1,869
100-10 Massachusetts Margin 1,237 1,533 1,741 1,224 5,735
100-10 Massachusetts Total Expenses 164 155 149 162 630
100-10 Florida Margin 372 442 494 375 1,683
100-10 Florida Total Expenses 174 192 200 175 741
100-10 Connecticut Margin 567 481 425 557 2,030
100-10 Connecticut Total Expenses 217 197 184 215 813
100-10 New Hampshire Margin 213 249 276 209 947
100-10 New Hampshire Total Expenses 139 149 155 137 580
100-10 California Margin 1,199 1,416 1,568 1,184 5,367
100-10 California Total Expenses 433 488 517 431 1,869
100-10 Oregon Margin 270 203 202 216 891
100-10 Oregon Total Expenses 193 183 176 180 732The following example is the same report script without TABDELIMIT:
<PAGE (Scenario)
<COLUMN (Year)
<ROW (Product, Market, Measures)
{ROWREPEAT}
<ICHILDREN Year
<DIMBOTTOM Product
<DIMBOTTOM Market
<CHILD Profit
!Without TABDELIMIT, the report output displays as follows (example truncated):
Scenario
Qtr1 Qtr2 Qtr3 Qtr4 Year
======== ======== ======== ======== ========
100-10 New York Margin 1,199 1,416 1,568 1,184 5,367
100-10 New York Total Expenses 433 488 518 430 1,869