Hi, How the relations will be exists in DMR models if u have
any idea please explain me
Answer Posted / chiru
After completing ur DMR Models, u will get Dimensions Tables i n Dimesnsion Tab and Measure Tables at Measure Tab on..If u want to check whether is relation between Dimension Table and Measure Table, just click on Measure Table, then an yellow colour display on dimension table, it implies relation is there between both tables.. . On right Corner in framework Manager there is scope icon.. by using scope icon we can set the hireriachy levels in relation between Both tables.
For example In Dimesion Table we have Region---Country--- city
By using scope we can set the relation uption Country Level only..............
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
Mention the difference between ‘macros’ and ‘prompt’?
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?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What are the types of catalogs in cognos?
difference between impromptu and cognos8
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
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.
------------ Diff b/w MemberCaption and MemberDescription?
What is difference between data mart and data warehouse?
What is Bitmap Index?
faq's on cognos
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
what is the procedure for scheduling conditional rendering?