---------- 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 |
-------------How you design DWH?
how can you set the image in the report
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
What is Stich Query in Reportnet?
Why do we create shortcuts in framework manager
What is zero-foot print?
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.
What is minimum version of internet explorer to run the Cognos report.
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
what are versions of cognos from starting release to latest in the market?
how u migrate the reports from impromptu to reportnet???
What is Normalization?