OUTALTSELECT

Selects an alias table in a report script.

Syntax

<OUTALTSELECT AliasTableName

AliasTableName The name of the selected alias table associated with the database outline.

Description

This command selects an alias table. The table remains in effect until another <OUTALTSELECT command executes. This lets you use different alias tables for different dimensions in a report script.

Example

The following example is based on Sample Basic, using two different alias tables: Funny Names and Default.

<PAGE("Scenario")
<COLUMN("Year", "Market")
<ROW("Measures", "Product")
<LINK(  <CHILDREN("Qtr4"))
<LINK(  <CHILDREN("South"))
<OUTALTSELECT "Long Names"
{OUTALTNAMES}"100-10"
"100-20"
"100-30"
<OUTALTSELECT Default
{OUTALTNAMES}
"200-10"
"200-20"
"200-30"
!
                                                                                   Scenario 

                                                  Oct                                 Nov                                 Dec                 
                                  Texas  Oklahoma Louisiana New Mexico Texas Oklahoma Louisiana New Mexico Texas  Oklahoma Louisiana New Mexico 
                                  ======== ======== ======== ======== ======== ======== ======== ======== ======== ======== ======== ======== 

Measures         The Best Cola      185       74       47       23      174       71       44       20      188       66       46       27 
                 SlimJim Cola        26       21       45      (26)      26       30       28       (8)      30       28       31       16 
                 AntiShake Cola   #Missing #Missing #Missing #Missing #Missing #Missing #Missing #Missing #Missing #Missing #Missing #Missing 

                 Old Fashioned      133       15       58       (6)     127       29       49       (7)     133       24       31       (5)
                 Diet Root Beer      78       65       30       14       48       62       34        8       52       72       27       12 
                 Sasparilla          55       76        1      (12)      59       89        1       (4)      47      121       (3)     (15)

See Also

OUTALTMBR
OUTALTNAMES
OUTMBRALT
OUTMBRNAMES

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com