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
- 10421 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
How to apply securities for reports in cognos connection?
What are the services provided in cognos 8?
is cognos 7 is better than cognos 8
-----------Diff b/w OLAP and RDBMS?
1. Explain your project.
How security is concerned with Reportnet? Explain its implementing steps.
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
How do we drill through from a powerplay cube to reportnet?\
What is dtm?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What are all the types of indexes in Cognos?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Explain difference between powerplay transformer and power play reports?
---------------Tell me about DWH Concepts?
Can you define transformer?
