Answer / vaibhav

A fact-less fact is a fact table in which only primary keys
of the dimension tables are present as foreign keys but no
measure/fact columns.
There are 2 types of factless fact table:
a) Event Tracking Tables: A table that records an event.
Example: A table that records student attendance. It
contains date_key, student_key, teacher_key, course_key,
without any measure section.
b) Coverage Tables: A table to answer questions about
things that didn't happen.
Example: An ordinary fact table cannot answer questions
like "Which products were on promotion that did not sell?",
because it contains only the records of products that did
sell. A table contains date_key, product_key, store_key,
promo_key and without measure section is used to answer
such questions.

Answer / gopal

Fact less fact table does not contains any facts or measures

Ex-student attendance-Yes or No
Gender-M or F

if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

2 Answers   WNS,

---

what is the different between primarykey and surrogated key.. why we are going for surrogatekey...

1 Answers  

---

I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

0 Answers  

---

I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,

---

what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,

---

What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,

---

what is exact catalog size?

4 Answers   IBM,

---

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

0 Answers  

---

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

0 Answers  

---

what is requery in cognos?

0 Answers   HMN, Satyam, TCS,

---

What are all the types of indexes in Cognos?

0 Answers  

---

what is report burn and where it occurs

3 Answers   IBM, Target,

---