Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly determinants are used in cognos framework
manager?
- 4 Answers
- 26895 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kavitha
A query subject that behaves as a dimension has multiple
levels of granularity and will be joined on different sets
of keys to fact data
| Is This Answer Correct ? | 21 Yes | 5 No |
Answer / lakshmi reddy
in framework manager if u are working with more than one
fact table then u have to check the granularity if fact
tables having different granularities i mean supose in one
table u r maintaining high cardinality in one table u r
maintaining low cardinality finally we may get over counting
to overcome that we use determinants in framework manager
where we have to group the repeated query items
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / janni
determinants is nothing but relation ship between query tables.
| Is This Answer Correct ? | 4 Yes | 34 No |
After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
can reportnet supports cubes???
what is filter?give me one example that you created a report in your project?
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
can you apply grouping on crosstab?
What is snapshot ?
how to connect datamarts
What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....
How you drill from powerPLay to Impromptu?Explain all Steps?
Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480
Teradata 
