what are determinants?
Answers were Sorted based on User's Feedback
Answer / pagu
Determainants are used for
-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.
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / palzkumar
Determinants define functionality dependencies between Query Items. Use determinant to avoid double counting in de-normalized data
Is This Answer Correct ? | 1 Yes | 0 No |
=> Determinants reflect granularity by representing subsets or groups of data in a query subject and used to ensure correct aggregation of this repeated data.
=> Determinants are most closely related to the concept of keys and indexes in the data source and are imported based on unique key and index information in the data source.
=> By modifying Determinants, you can override the index and key information in your data source,replacing it with information that is better aligned with your reporting and analysis needs.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / madhoo
Determinants are used for to improve the query performance
these are like .... 1. Computer system and network capacity
2. Schema design
3. Database objects
4. Best practices for writing queries
5. Physical storage layout
6. Parallel query and Red Brick Warehouse configuration
computer host loaded correctly and network traffic problem
should be overcome....
A well designed Schema has most effect on query performance...
Database object give good performance .....those are Indexes
and predefined objects...
There are so many ways to write query on a logic...but with
the help of best practices only we can write well
performanced query.
.........
Any question on cognos and Sql .....let me wake up for
them at Cognos.madhoo@gmail.com
Is This Answer Correct ? | 3 Yes | 3 No |
Can you define folder?
How to create a Ratio in Cognos Report studio Reports?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What is the diff between Drill through reports and Master detail reports?
data import to models, datastores,stored processed, is there any other way to import data?
What is the importance of having monitor service in cognos?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
-----------Types of Fact Tables?
6 Answers Bank Of America, CTS,
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar
What's the differance between each studio in cognos 8?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
What is the difference between ‘macro’ and ‘prompt?