Dimension types

                                                      Types of Dimensions

              Note: Attributed Dimensions are below the Standard Dimension.

    Types of Dimensions:  Standard Dimensions, Attributed Dimensions.

   I. Standard Dimensions (SD) 

           Types of Standard Dimensions  

               1. Sparse (Default) - Low Probability Ex: Root bear  

               2.  Dense- High Probability, Ex: Pepsi       

           * Not Associated with Attribute Dimension.  

Consolidation Operation.	No- Two pass
Sparse, Dense	Required Storage Space
Standard Dimension above Attributed Dimension.	Storage Property- all
Formula	UDA allowed
Shared Members

           II. Attribute Dimensions  

Should be associate to Standard Dimension with Sparse. Not Associated with Dense.	Two pass
Should be associate to Standard Dimension with Sparse. Not Associated with Dense.	No formula
If assign AD, automatically recovered Consolidation operators: +-,*...	No Shared Members
No Consolidation Property.	Required Storage Space
Associated with Sparse	Storage Property- Dynamic Calc
Attributed Dimensions are below Standard Dimension.	UDA allowed