Difference between standard dimension and attribute dimension

Sno
Characteristics
Standard Dimension
Attribute Dimension
1
Definition
Standard dimension is tells about the core components of business plan
Attribute dimension is used to group and analyze standard dimension members based on their characteristics
2
Storage
Can be dense or sparse
Sparse only, attribute dimension must be associate with sparse standard dimension only
3
Formulas
Formulas can be associated with standard dimension members
Formulas cannot be associated with standard dimension members
4
Storage properties
Storage properties can be store data, dynamic calc & store, dynamic calc only, share, never share, label only
Storage property dynamic calc only
5
Consolidation properties
+,-,*,/,%,~,^
attribute calculations done through five default functions names sum, count, min, max, avg
6
Shared members
Allowed
Not allowed
7
UDA
Allowed
Not allowed
8
Two pass calculation member property
Allowed
Not allowed
9
Position
Position in the outline is a head of all attribute dimensions
Position in the outline is last
10
Member selection
A member can be text, Boolean, numeric and date
Text
11
Example
Account(Dense)
Period(Dense)
Product(Sparse)
Market(Sparse)
Producttype
Market region
productcolor


Comments