How can we create regular dimensions & measure dimensions?
Answers were Sorted based on User's Feedback
Answer / amar
In Framework Manager
Go to Actions Menu--> Create ---> select regular dimension or
measure dimension ( what you want to Create ).
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is Correlated sub-query? Please explain
What snowflake and Starschema?
what is meant by roll up and roll back in dataware housing????
4 Answers Covansys, IBM, Wipro,
what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me
what is report studiio and how to start it?
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.
how to access the database directly from cognos reportnet
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
how to perform back drill through in cognos 8 what is the use of it
I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!
write a query to display the third record from the employee table?
what is the meaning of drill down and drill up in COGNOS 8BI