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?
Answer Posted / 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 |
Post New Answer View All Answers
what is model and say about process how to create model and how to test model?
how to connect datamarts
How do you improve the performance of the Cognos Analytics report
What is called materialized view?
what are the dimensions that you have in your current project?list them?
How to Reset Pagenumbers in one report.
Explain the different types of views used in cognos.
What are the types of hierarchies?
Can you define set to be cardinality?
hi my name is siraj i want to know cognos queriy language
What is a Framework manager?
-----------------What is Determination Model?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
How is possible this scenario using in type-in prompt.?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com