Databases Reference
In-Depth Information
SUPCOMMAS
Syntax:
{ SUPCOMMAS }
Example:
{ SUPCOMMAS }
This example will return numeric data rows with no commas delineating
the numbers for values over 999.
COMMAS
Syntax:
{ COMMAS }
Example:
{ COMMAS }
This example will return numeric data rows with commas delineating
the numbers for values over 999.
WIDTH
Syntax:
{ WIDTH number [ column1 [ column2 [ columnN ] ] ] }
Example:
{ WIDTH 20 }
This example will truncate all column widths to
20
spaces wide, regardless
of their actual width.
Column or row calculation
While these are some pretty cool commands, we recommend that you be very careful
with their use. As you must know by now, we have repeatedly stated the benefits of
Essbase's dynamic data calculating abilities and there is no arguing that.
When you use these row and column calculation commands, you are artificially
creating data that does not actually exist in the Essbase database.
