Analysis of Setting Dense & Sparse Dimensions

Analysis of Setting Dense and Sparse Dimensions

Example for setting as Dense or Sparse

Scenario:
 Design the outline for Mobile Shop

Description about Mobile Shop:
In that Mobile Shop, they are maintaining different product line such as (Mobile phones, Tabs, Mobile Phone Accessories) and located in different regions.

Dimensions involving in the outline:

• Period
• Accounts
• Scenario
• Product
• Region

Analysis to set dimensions as Dense or Sparse:

• What are the products selling in that shop are fixed for a time. It may not be updated daily but it may update for a month or every six months or a year based on the product release.

            So we declared Product dimension as Sparse.

•  Coming to Region dimension it also same as like product dimension.

             So we declared Region dimension as Sparse.

•  The members involved in the account dimension never be fixed, it will have some fluctuations.

            So we declared Account dimension as Dense.

•  In Period dimension, the new date will be appended daily.

            So we declared Period dimension as Dense.

•  In version dimension, we perform some Dynamic calculations for some members.

            So we declared Version dimension as Dense.


How to order the dimensions in Essbase outline?
Place the largest dense dimension as first followed by smallest dense dimension.
Immediately followed by the smallest sparse dimension and largest sparse dimension.

 (i.e.)

Dimension with Time Tag

↓

Dimension with Account Tag

↓

Largest Dense dimension

↓

Smallest Dense dimension

↓

Smallest Sparse dimension

↓

Largest Sparse dimension

↓

Non Aggregate Sparse dimension

↓

Attribute Dimension