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

----------------Describe DWH Architecture?

1 Answers   Bank Of America,

---

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  

---

Can you define report item?

1 Answers  

---

How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?

1 Answers   Polaris,

---

How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..

2 Answers   IBM,

---

What is Model Versioning or Versioning in Cognos Framework Manager?

2 Answers   Systime,

---

how to do page breaks in cognos 8 Report studio pls give the navigation

4 Answers  

---

How do you call a store procedure within a transformation?

1 Answers  

---

1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?

2 Answers   Cognizant,

---

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

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.

1 Answers  

---

Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !

3 Answers  

---