what is fact less fact give me proper example?
Answers were Sorted based on User's Feedback
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 |
Answer / gopal
Fact less fact table does not contains any facts or measures
Ex-student attendance-Yes or No
Gender-M or F
Is This Answer Correct ? | 1 Yes | 0 No |
write a query to display the departments with no employee?
how to access the database directly from cognos reportnet
What is the deployment requirements used in cognos?
What do you mean by query studio?
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
What are the different kinds of panes included in cognos?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Explain is there any comparison available for cognos reportnet vs crystal reports?
What are all the components of Report Studio?
Explain about embedded & standalone filters?difference between them
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?
How do you Parametermap variables in Quiries?