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
- 10279 Views
- Mphasis, I also Faced
- E-Mail Answers
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 are various types of gateways in cognos?
what are the filters in framework manager and report studio?
How Metrics Studio is better than Report Studio?
Can you define set to be cardinality?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What is the difference between Open Connection command ang Open Session Command?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
how to explain health care project and which reports we can create in health care doain?
can you tell me what are the dimension tables are used in project
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
What is dtm?
What is Additive function?
How do you Parametermap variables in Quiries?
Tell me about Dnamic and Static Dashboards?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
