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?

Answers were Sorted based on User's Feedback



Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? P..

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

Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? P..

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

Post New Answer

More Cognos Interview Questions

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

1 Answers   Satyam, TCS,


Can you explain cognos planning?

0 Answers  


what are the features in cognos8ui

0 Answers   HSBC,


can you tell me what are the dimension tables are used in project

0 Answers   GalaxE,


2. What functional area you worked on.

0 Answers   IBM,






why u need to publish the package?

5 Answers   IBM,


What are the different types of OLAP. Which one is Cognos Powercube?

2 Answers   HSBC,


hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers  


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

0 Answers  


Which lifecycle we will use for reporting?

0 Answers  


How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

5 Answers   HSBC,


what is the difference between enterprise data warehouse and data warehouse

4 Answers  


Categories