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

What is limited local? and the uses?

2 Answers   Ness Technologies,

---

While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,

---

These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

2 Answers   IBM,

---

15. If I select the current month and year how can we display previous 11 months data?

2 Answers   TCS,

---

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

0 Answers  

---

can any one explain about blue prints&performance tuning in cognos? 

1 Answers   TCS,

---

what is the security module used in cognos?

2 Answers   Cognos, IBM,

---

HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?

4 Answers   IBM, TCS,

---

Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

2 Answers   IBM,

---

where we use page break  and page set. with example?

1 Answers   CNSI, IBM,

---

what is mean by complex starschema ,star schemagrouping?

0 Answers  

---

2.How do you drill through report from Report Studio to Analysis studio?

3 Answers   IBM,

---