Suppresses the display of all rows that contain only #MISSING values.
{ SUPMISSINGROWS }
<Sym
<Column (Scenario, Year)
Actual Budget
Jan Dec
<Top ("Measures", 5, @DataCol(4))
<Row (Measures, Market, Product)
{SupMissingRows}
<Idescendants Profit
<Ichildren Market
<Idescendants Product
!
This example produces the following report:
Actual Budget
Jan Dec Jan Dec
======== ======== ======== ========
Sales Market Product 31,538 33,342 29,480 30,820
Margin Market Product 17,378 18,435 16,850 17,360
COGS Market Product 14,160 14,907 12,630 13,460
Sales Central Product 10,346 10,662 9,970 10,310
West Product 10,436 11,116 9,460 10,200
|
INCEMPTYROWS
INCMISSINGROWS
INCZEROROWS
SUPEMPTYROWS
SUPZEROROWS
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |