where exactly determinants are used in cognos framework
manager?
- 4 Answers
- 25768 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sajj
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
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 ? | 19 Yes | 0 No |
Post New Answer View All Answers
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
What is called Cognos powerplay?
hi my name is siraj i want to know cognos queriy language
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Can you explain new content durability?
Can you define cognos powerplay?
What are all the types of report?
where you can save the report net documentation in our local system?
Can you define a query subject?
What are all the types of indexes in Cognos?
What is cognos powerhouse?
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
--------------Diff b/w ODS and OLAP?
can you tell me what are the dimension tables are used in project
----------------Describe DWH Architecture?
