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
- 10435 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anirban pal
Q1.
Determinants define functional dependencies between query
items. It is used to avoid double counting of data is
denormalized data sources. Determinants are used to
-Add information about dependencies between columns to avoid
double-counting.
-Specify the granularity of a de normalized query subject to
control grouping and double-counting.
-Uniquely identify the row of data when retrieving text blob
data.
-Override the determinants imported from the data source
that conflict with relationships.
e.g.
Determinant and Dependent
The terms determinant and dependent can be described as follows:
1. The expression X Y means 'if I know the value of X, then
I can obtain the value of Y' (in a table or somewhere).
2. In the expression X Y, X is the determinant and Y is the
dependent attribute.
3. The value X determines the value of Y.
4. The value Y depends on the value of X.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
How can we create a dynamic column name in cognos?
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)
Explain about Parametermap?
What are differences between Reporter report and Explorer report?
How to create a Ratio in Cognos Report studio Reports?
-----------What is member Description?
What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
can any one explain about blue prints&performance tuning in cognos?
------------- How to identify the Revenue Column in Report?
I have to apply drill through 1,2,7 out of 10 in order method, how can i do?
How to hide the prompts
Teradata 
