Displays alias names for members in a report.
{ OUTALTNAMES }
The member name, not the alias name, is the default for reporting.
This command displays alternate names for members in the report instead of the actual member name. May be used in conjunction with OUTMBRNAME to switch between member names and alias names in report rows.
The following example is based on Sample Basic.
{WIDTH 15} //{OUTALTNAMES} If used (commented out), displays alias names for column headers <PAGE (Measures) Sales <COL (Year, Market, Scenario) Jan Feb Mar East Actual <ROW(Measures) {OUTALTNAMES} // These members display with aliases. <IDESCENDANTS "100" {OUTMBRNAMES} // These members display their member names as defined in the outline. <IDESCENDANTS "200" {OUTALTNAMES} // Switches back to alias names, as defined in the current alias table. <IDESCENDANTS "400" !
This example produces the following report:
Sales East Actual Jan Feb Mar ============== ============== ============== Cola 1,812 1,754 1,805 Diet Cola 200 206 214 Caffeine Free Cola 93 101 107 Colas 2,105 2,061 2,126 200-10 647 668 672 200-20 310 310 312 200-30 #Missing #Missing #Missing 200-40 896 988 923 200 1,853 1,966 1,907 Grape 562 560 560 Orange 219 243 213 Strawberry 432 469 477 Fruit Soda 1,213 1,272 1,250 |
OUTALT
OUTALTMBR
OUTMBRALT
OUTMBRNAMES
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |