Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 9th, 2011

 

A regular dimension organizes the information.
It is stored in a hierarchy, from the highest level of granularity to the lowest.
It usually has multiple levels.
Each level requires a key and a caption.
Regular dimension contains descriptive and business key information.

A measure dimension is a collection of facts.
Measure dimension are created based on one or more query subjects that have a valid relationship between them.
Here, only the measures are visible in the model measure dimension. Query items, such as keys, are hidden.
Model measure dimensions should be composed of only quantitative items.

You can create dimension as follows
Select a namespace or folder where you want to place the dimension.
Click Actions
Click Create
Measure Dimension / Regular Dimension

For Measure Dimension you drag Model Objects to measure box
For Regular Dimension you Click Add Hierarchy and then drag objects from the items box to the Hierarchies box.