Answer / satyanand86.m

To prevent double counting on multi fact/multi grain queries we need determinants on query subjects that have multiple level of granularity used to aggregate facts.

Answer / srinivas naidu

Determinents are new concept introduced in cognos 8 this is
used to avoiding double counting in framework
manager.......suppose if the data existing more time in
tables at that time we go for determinents(avoiding
duplicates)

Answer / sreenivas

Determients is the set of database columns that can be
used to uniquely identify set of data.
Determinants are imported based on key and index
information in the data source

Answer / gopal

By using determinants we avoid the double counting values....

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

2 Answers   Satyam,

---

How do you call a store procedure within a transformation?

0 Answers  

---

1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?

1 Answers   CTS,

---

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

0 Answers  

---

What is the use of Generated Prompt? Where is it used in realtime project?

3 Answers   HCL,

---

what are the errors faced while bursting the reports and how to solve those errors?

0 Answers   EDS,

---

I want to schedule the report as sysdate-1.....how to do

2 Answers   TCS,

---

can any one say the which is the best performance in framework manager

1 Answers  

---

Can you define metrics designer?

0 Answers  

---

Can you define framework manager?

0 Answers  

---

What are the advantages of shortcuts?

0 Answers  

---

write a query to display the departments with no employee?

0 Answers   HCL,

---