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
What do you mean by query studio?
---------------Describe OLAP Reporting and RDBMS Reporting?
Which lifecycle we will use for reporting?
What is the model filter?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What do you understand by user class in cognos?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is Additive function?
Explain what is the difference between native sql and cognos sql?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
4. How many dimensions did you use in your reports?
Can you define dimension?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
Can you define bitmap index?