SUPMISSINGROWS
The Essbase Report Writer SUPMISSINGROWS command can control the display of empty values that are #MISSING in the report. It 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"
!The above report script 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