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.

Answer / palzkumar

Determinants define functionality dependencies between Query Items. Use determinant to avoid double counting in de-normalized data

Answer / satya/gunu

=> 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.

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

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers   Infosys,

---

what is textsource variable

2 Answers   HCL,

---

What is the difference between List and Cross tab? Could some on explain with an example..

2 Answers   Barclays,

---

we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer

4 Answers   IBM,

---

---------------What is Dimension?

2 Answers   Bank Of America,

---

i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??

1 Answers   TCS,

---

3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?

3 Answers   CTD, Wipro,

---

Can you define dimension?

0 Answers  

---

-----------Types of Fact Tables?

6 Answers   Bank Of America, CTS,

---

----------0Diff b/w Report Functions and Database functions?

1 Answers   IBM,

---

2. What functional area you worked on.

0 Answers   IBM,

---

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

6 Answers   HCL,

---