Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 10375 Views
- Mphasis, I also Faced
- E-Mail Answers
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
how to connect datamarts
What is catalog and types of catalogs in cagonos and which is better?
what are the special features in cognos reportnet?
What are the types of folder present in cognos?
how you provide security to reports? How you provide security to packages ?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Name the types of report?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Explain what is the difference between native sql and cognos sql?
Why cognos decision stream is used?
What are all types of Batches?
how to perform back drill through in cognos 8 what is the use of it
What junk dimension contains?
What is metric store database?
What do you understand by the term 'aggregate advisor?'
