SUPMISSINGROWS

Suppresses the display of rows that contain only #MISSING values.

Syntax

{ SUPMISSINGROWS }

Example

The following report script is designed for the Sample Basic cube, available in the gallery.

<PAGE("Measures")
<COLUMN("Scenario", "Year")
<ROW("Market", "Product")
"Sales"
"Scenario" 
"Jan" "Feb" "Mar" 
"New York"
"Product" "100" "100-10" "100-20" "100-30" "200" "200-10" "200-20" "200-30" "200-40" "300" "300-10" "300-20" "300-30" "400" "400-10" "400-20" "400-30" "Diet" "100-20" "200-20" "300-30" 
!

<PAGE("Measures")
<COLUMN("Scenario", "Year")
<ROW("Market", "Product")
{SUPMISSINGROWS}
{NOINDENTGEN}
"Sales"
"Scenario" 
"Jan" "Feb" "Mar" 
"New York"
"Product" "100" "100-10" "100-20" "100-30" "200" "200-10" "200-20" "200-30" "200-40" "300" "300-10" "300-20" "300-30" "400" "400-10" "400-20" "400-30" "Diet" "100-20" "200-20" "300-30" 
!

This example produces the following reports. The second report has missing rows suppressed.

                                        Sales Scenario 

                                       Jan      Feb      Mar 
                                  ======== ======== ======== 

New York             Product         2,479    2,625    2,601 
                   100                 678      645      675 
                 100-10                678      645      675 
                 100-20           #Missing #Missing #Missing 
                 100-30           #Missing #Missing #Missing 
                   200                 551      641      586 
                 200-10                 61       61       63 
                 200-20           #Missing #Missing #Missing 
                 200-30           #Missing #Missing #Missing 
                 200-40                490      580      523 
                   300                 663      675      695 
                 300-10                483      495      513 
                 300-20                180      180      182 
                 300-30           #Missing #Missing #Missing 
                   400                 587      664      645 
                 400-10                234      232      234 
                 400-20                219      243      213 
                 400-30                134      189      198 
                   Diet           #Missing #Missing #Missing 

                                        Sales Scenario 

                                       Jan      Feb      Mar 
                                  ======== ======== ======== 

New York         Product             2,479    2,625    2,601 
                 100                   678      645      675 
                 100-10                678      645      675 
                 200                   551      641      586 
                 200-10                 61       61       63 
                 200-40                490      580      523 
                 300                   663      675      695 
                 300-10                483      495      513 
                 300-20                180      180      182 
                 400                   587      664      645 
                 400-10                234      232      234 
                 400-20                219      243      213 
                 400-30                134      189      198