Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what are the filters in framework manager and report studio?
What is Additive function?
New coloums are added in database, then how you know in report level
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
What are the considerations regarding performance kept in mind while setting up cognos?
What is dtm?
difference between impromptu and cognos8
What is the complex report you faced in real time?
What is cognos connection?
5. Which type of report you build more, list, crosstab or chart and why?
What is the deployment requirements used in cognos?
how u will design the report if the objects are available
Give me any example of semi and non additive measures?
What are all types of Batches?
-----------With out using DrillThrough how to do Reports?
