-----------Types of Fact Tables?
Answer Posted / abd hfz
There are two types of Fact Tables namely :
1) Cummulative Fact Table : Facts collected over a period
of time are called CFT. This contains mainly Additive facts.
2) Snapshot Fact Table: Facts collected at the particular
time are called SFT. This are mainly Semi/Non Additive facts.
Also,
Fact less fact table : which has only FK and does not
contain any measures. eg: Visitors to the office
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how you migrate reports to cognos 8 from previous versions?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What are the ways to import data into catalog? what is the role of cognos comsultant?what actually it
means?pls reply 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 9. What was the most complex type of report you dealt with?
if ur report having report filter save the report.open u r
report in cc the report filter doesnt work means it does n't
any values what we do for this situation?where we rectify
this?please please ans me...... ----------------Describe DWH Architecture? Helow,
i have a problem with runing-total function when i use it
for a calculate row (for example : i need to diplay a
running-total of total units ?) what r the reports u faced critical and how it can be solved
.. any once can u give a best ans for interviw what is the procedure for scheduling conditional rendering? 2. What functional area you worked on.
How create measures and dimensions? What is the deployment requirements used in cognos? explain how to create powerplay reports?