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
Post a Comment