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.
Works for Essbase Addin 7X and above.
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.