Report Writer Command Groups

Overview Syntax Command Groups Command List

This section lists all Report Writer commands, grouped by command type. The command groups correspond to the steps of report design:

• Report Layout Commands
• Data Range Commands
• Data Ordering Commands
• Member Selection and Sorting Commands
• Format Commands
• Column or Row Calculation
• Member Names and Aliases

For a description of the stages of report design, see the Database Administrator's Guide.

Report Layout Commands

A report layout is composed of items that make up the columns and rows of a page. Report layout commands provide column, page, and row layout, and include two commands that override the default method for interpreting column dimension member lists. Report Writer provides the following page layout commands:

• <ASYM
• <COLUMN
• <PAGE
• <ROW
• <SYM

Data Range Commands

Data range commands restrict the range of data selected for your reports. Report Writer provides the following data range commands:

• <BOTTOM
• <RESTRICT
• <TOP

Data Ordering Commands

Data ordering commands order data in your reports. Report Writer provides the following ordering commands:

• <ORDERBY

Member Selection and Sorting Commands

Member selection commands enhance your selection options using member relationships based on the database outline. The Report Writer provides the following selection and sorting commands:

<ALLINSAMEDIM <ALLSIBLINGS <ANCESTORS <ATTRIBUTE <CHILDREN <CURRENCY <DESCENDANTS <DIMBOTTOM <DIMEND <DIMTOP <DUPLICATE

<IANCESTORS <ICHILDREN <IDESCENDANTS <IPARENT <LATEST <LINK <MATCH <OFSAMEGEN <ONSAMELEVELAS <PARENT

<SORTALTNAMES <SORTASC <SORTDESC <SORTGEN <SORTLEVEL <SORTMBRNAMES <SORTNONE <TODATE <UDA <WITHATTR

Format Commands

These commands define the appearance of your data and your report. Each format command applies only to those output lines that follow the command.

AFTER BEFORE BLOCKHEADERS BRACKETS COLHEADING COMMAS CURHEADING DECIMAL ENDHEADING EUROPEAN FEEDON FIXCOLUMNS FORMATCOLUMNS HEADING IMMHEADING INCEMPTYROWS INCFORMATS INCMASK INCMISSINGROWS INCZEROROWS INDENT INDENTGEN LMARGIN MASK MISSINGTEXT NAMESCOL NAMESON

NAMEWIDTH NEWPAGE NOINDENTGEN NOPAGEONDIMENSION NOROWREPEAT NOSKIPONDIMENSION NOUNAMEONDIM ORDER OUTALTNAMES OUTMBRNAMES OUTPUT PAGEHEADING PAGELENGTH PAGEONDIMENSION PYRAMIDHEADERS QUOTEMBRNAMES RENAME ROWREPEAT SCALE SETCENTER SINGLECOLUMN SKIP SKIPONDIMENSION STARTHEADING SUPALL SUPBRACKETS SUPCOLHEADING

SUPCOMMAS SUPCURHEADING SUPEMPTYROWS SUPEUROPEAN SUPFEED SUPFORMATS SUPHEADING SUPMASK SUPMISSINGROWS SUPNAMES SUPOUTPUT SUPPAGEHEADING SUPSHARE SUPSHAREOFF SUPZEROROWS TABDELIMIT TEXT UCHARACTERS UCOLUMNS UDATA UNAME UNAMEONDIMENSION UNDERLINECHAR UNDERSCORECHAR WIDTH ZEROTEXT

Column or Row Calculation Commands

These commands perform column and row calculations that let you create extra columns or rows in a report (not defined as part of the database outline) based on selected data members. Enclose all calculation commands and their arguments in curly { } braces.

CALCULATE COLUMN CALCULATE ROW CLEARALLROWCALC CLEARROWCALC OFFCOLCALCS

OFFROWCALCS ONCOLCALCS ONROWCALCS PRINTROW REMOVECOLCALCS

SAVEANDOUTPUT SAVEROW SETROWOP

Member Names and Aliases

These commands allow you to set aliases or alternate names that can make reports easier to read and help your reader focus on the data values rather than the meanings of member (page, column, and row) names.

• OUTMBRALT
• OUTALTMBR
• OUTALT
• OUTALTNAMES
• OUTALTSELECT

You can use aliases to display members in a report:

• By alias alone. For example, display the name as Diet Cola rather than its corresponding member name 100-20.
• As a combination of member name and alias. For example, display the name as Diet Cola 100-20.

In addition, these report commands also control the display of member names and aliases.

• ALLINSAMEDIM
• CHILDREN
• DESCENDANTS
• SORTASC
• SORTALTNAMES
• SORTDESC
• SORTGEN
• SORTLEVEL
• SORTNONE

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.