Answer / kalyani

According to Kimball

"Factless fact table are the preferred method of recording
the events in the DW where there is no natural numeric
measurement associated with the event. Factless fact tables
also are used to gurantee coverage"

Answer / kalyani

A factless fact is a fact table in which only primary keys
of the dimension tables present as foreign keys but no
individual fact clomuns.

------Diff B/W DrillThrough and master and Detailed Report?

2 Answers   IBM,

---

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

0 Answers  

---

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

7 Answers   Cap Gemini, iFlex,

---

Diff b/w surrogate Key and Primary Key?

2 Answers   Cap Gemini,

---

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

3 Answers   ComNet,

---

How can create users and permissions in cognos?

0 Answers  

---

how to perform single sign in cognos by using url?

0 Answers   IBM,

---

What is the difference between macro & Parameter

1 Answers   IBM,

---

what is difference btw summary filter and detail filter, plz explain with example

10 Answers   IBM, TCS,

---

Hey Techies, Could you please tell me about query processing? and what is database only and what is Limited locale? brief plz..

2 Answers   Atos Origin,

---

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers  

---

How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).

1 Answers  

---