Replacing #Missing label with 0 Zero not text 0

Put the #Missing label as (0) and excel will interpret it as a numeric zero.Technically, it's a negative zero.
If (0) it didn't work, it may be because the cell is already formatted as a text entry rather than general formatting.Clear the formatting of the data area and then retry the (0) setting.

Works for Essbase Addin 7X and above.

Some Old School Stuff

What is the Outline?
•Organize the data into dimensions and hierarchies
•Assign member and dimension properties
–Storage
–Two Pass
–Member formulas
•Tag dimensions dense or sparse

Why is the Outline Important?
•Determines how data is stored
•Determines the size of the blocks
•Determines some of the calculations for the database
•Determines the calculation order for dimensions
•Determines how users can perform analysis
•One of the major things that you can tune to improve performance

AutoConfiguration of sparse dense
•Don’t use autoconfiguration
•Autoconfiguration of dense and sparse dimension provides only an approximation
•Essbase cannot take in account the nature of the data loaded into the database or the requirements of calc scripts
•Automatic configuration can be disabled for manual definition of dense and sparse settings

Blocks in Essbase
•Dimensions tagged dense will make up the cells within a block
•Dimensions tagged sparse will create the blocks themselves
–Essbase creates a data block for each unique combination of sparse dimension members that contain data
•Tagging dimensions as dense and sparse determines the overall size and structure of the database

Calculate Block Size
•Data block size is determined by the amount of data in a particular combination of dense dimensions
•Data block size is 8n bytes, where n is the number of cells that exist for that combination of dense dimensions

How do you reduce block size?
•Change a dense dimension to a sparse dimension
•Make members in a dense dimension dynamic
–Label only
–Dynamic calc

Old School Dimension Order
•Hourglass
•Accounts first, Time second
•Dynamic calcsalways slow retrievals

The Improved Way -Dimension Ordering
•Largest Dense Dimensions
•Smallest Dense Dimensions
•Smallest Aggregating Sparse Dimensions
•Largest Aggregating Sparse Dimensions
•Non-aggregating Sparse Dimensions
•Referred to as hourglass on a stick

Dimension Ordering Guidelines
•Dense dimensions -define the data block and must reside at the top of the outline
•Aggregating Sparse dimensions -dimensions that will be calculated to create new parent values
–Should reside directly below the last Dense dimension in the outline
–Placing these dimensions as the first Sparse dimensions positions them to be the first dimensions included in the calculator cache
–Gives them an ideal location within the database for optimized calculation performance.