Suppressing Missing Rows in Multiple Worksheets

If you do not want to replicate rows containing only #Missing labels, you can specify the option to create replicated worksheets without missing data.

To suppress replicating worksheets containing missing rows:

Select Essbase, and then Cascade.
From Essbase Cascade Options, select Format Options.
Under Sheet Formatting, select Suppress Missing Rows.
Rows containing only #Missing values are not replicated.

Related Topics

Copying Formats into Multiple Worksheets

Creating a Table of Contents for Multiple Worksheets

Specifying Multiple Worksheet Names

Specifying the Destination Directory of Multiple Worksheets

Specifying the Worksheet Detail Level

Specifying Output Types of Multiple Worksheets