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
Explain about scorecarding?
Can you define pivot?
What r the names of the reports that you prepared?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
How do you improve the performance of the Cognos Analytics report
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What junk dimension contains?
Define metrics studio?
How do we drill through from a powerplay cube to reportnet?\
How can I schedule reports in cognos?
-----------Diff b/w OLAP and RDBMS?
Can you define materialized view?
How can you link a query to a data container manually in Report Studio?