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
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