---------- Purpose of Factless Facttable?
Answers were Sorted based on User's Feedback
Answer / kalyani
According to Kimball
"Factless fact table are the preferred method of recording
the events in the DW where there is no natural numeric
measurement associated with the event. Factless fact tables
also are used to gurantee coverage"
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kalyani
A factless fact is a fact table in which only primary keys
of the dimension tables present as foreign keys but no
individual fact clomuns.
| Is This Answer Correct ? | 1 Yes | 3 No |
What do you mean by drill across?
what are versions of cognos from starting release to latest in the market?
What are the steps to import the two data sources in framework manager?
What are all the types of gateway used in Cognos?
what was the actual purpose of portfolio in cognos ?
what is dash board?
What are different events in Report studio?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What is the difference between group and associare?
What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.