How can we create regular dimensions & measure dimensions?
Answer Posted / sunitha g
In framework manager we have to create one layer/view/namespace i.e DMR Namespace
in that we can create 2 type of dim that have regular & measure
regular:goto actions -->regular dimention or else right click on dmr namespace -->goto regular dimention
create hierarchies ,define levels,give the business key * member key options
For example : country ,State,City levels from geographical hirarchy
Measure:Its having only measure values & fact information
need to follow this process, right click on dmr-->goto measure dimention & Just drag & drop the measure what ever you need based on your requirement
Give the scope relationship between both of them
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to test reports in cognos?
What are the steps to import the two data sources in framework manager?
i have one file i saved in csv how can i take these file into framework manager
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
How to select multiple values from type-in prompt?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
tell me two or three issues from client side and how to solve those issues?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
what is the difference between filter and condition?
What do you understand by the term 'aggregate cache'?
Why are meta service important then other services?
What are initial page components of Cognos connection?
What is the difference between the content store and content manager?
Explain the different types of views used in cognos.
What is metric store database?