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
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is model? Explain is there any comparison available for cognos reportnet vs crystal reports? How to do Performence Tunning in Cognos Reports? How is cognos model organization works? How create measures and dimensions? Can you define drill across? dumps needed ASAP for - C2020-180 Cognos IBM Certification How can we import Excel data in to FWM?Wt is mean by Ragged
dimensions?where can we observe the Regular dimensions &
measure dimensions? how to develop dynamic dashboards, and what is the difference between static
and dyanmic dashboards in report studion and need with example. plz mail me
on this email id vasucognos4@gmail.com What is defined as catalog and types of catalogs in Cognos? Hi All,
I have 1.6 years of experience in cognos in India. I always
wanted to do a MS program to earn some money in US. But I
think I am little late in taking the decision. As If I have
to write my GRE it will be August or September of 2012 and
will have to apply for fall 2013 as fall 2012 admissions are
almost done now.
So my concern is how will be my career do if my MS is at
this stage,. i,.e. 3 years experience in Cognos and 2 years
MS program in and again looking for job in U.S. Have I been
too late in taking the call? I heard that MIS (Managing
Information Systems) is having very good placements now.
So guys, please advice me in taking the decision to have a
good career and also in terms of earning money as I have few
financial problems to solve (which I am hoping to solve when
I get job in US after completion of my MS program).
Thanks a lot friends. I really appreciate and thank one and
all for their valuable comments in this site. 1. We have been asked to add summary information to
sales reprasentatives performance report. The report needs
to be grouped by country and city to compare performance
between areas Also we need to include revenue totals for
each city and each country. What is the report studio? Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
