Q1. Why do we use determinant? Please explain with examples?
Q2. What is new arrive dimensions? Please explain with examples?
Q3. Suppose we have a table which is holding a large number
of records. There are 4 columns which are very frequently
used in the Cognos reports, so can we create indexing on
those 4 columns?
Answer Posted / ssr
Let us understand the determinants in simplest terms.
Company CEO Empl
-----------------------------------------------------
Ennov Vijay Vishwas
Ennov Vijay Mritunjay
Ennov Vijay Farrukh
Company Revenue
---------------------------------------
Ennov 500000
Carrot 400000
When above 2 tables are joined on Company field and you
bring following items in the query Company,CEO, Revenue. The
following will be the output
Company CEO Revenue
-------------------------------------------------
Ennov Vijay 500000
Ennov Vijay 500000
Ennov Vijay 500000
You got three rows because Ennova had three employees, here
cognos was not able to understand that granulirity of both
these tables was different. You have to defined it
explicitely and end product of this is called DETERMINANTS.
Here in the first table you have to define 2 determinants
CEO and Company and and check the check box of group by. Now
when you run the query in cognos you will find that
repeation is not there
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is it possible to join multiple Databases in a Catalog?
What are the advantages of cognos?
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?
Can you define cognos impromptu?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What is defined as Cognos Impromptu?
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?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What are the types of studio?
What is zero-foot print?
Can you define framework manager?
what is the difference between filter and condition?