Creation of Regular and Measure Dimension

[rama83]

Hi All,

I am new into the Cognos 8.2 Modeling part.How to create regular and measure dimension in FM.

For Ex:I am having the following Dimension- 1)Country,Region,state and City
2)Year,Quarter key,Quarter Name,Month Key ,Month year,Week Key Week Day and Day key Day name

how to create regular dimension for above.
Thanks In Advance

Regards,
Rama

[Arun.J]

Right Click (Namespace) -> Create -> Regular Dimesnion

Drag the necessary query items in to the Hierarchy. i.e "year" , "Quater" , "Month" , "Weekdays"

It will default create first two levels i.e e.g  Year , Year(All) , Leave it as such.

Start from third Level . F.M will mark the "Year" Q.I as _memeberCaption, Drag the "Year Key" Q.I over it and mark it as _Business Key.

Similary Set the _membercaption and _businesskey for all the levels like  "year","Quater","month" and mark the levels as unique if needed.

similarly create for all Dimension.

Right Click (Namespace) -> Create -> Regular Measure

Drag the Fact Q.I and use show scope, set scope , remove scope to set the association.

Arun.J