Answer Posted / bhadra
Any two fact tables are connected via a dimension table only
so to connect 3 fact tables we connect each two of them
using a dimension table in between them
Join the primary key from the fact table to the foriegn key
in dimension table
F1 - D1 - F2 - D2 - F3
F* are the fact tables and D* are dimension tables
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Is it possible to join multiple Databases in a Catalog?
What is a Query Subject?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
How to deploy from one server to another server?
What are the message flows?
what are the dimensions that you have in your current project?list them?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
How can I test reports in cagonos?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
-----------Diff b/w OLAP and RDBMS?
What is called Cognos powerplay?
What is difference between content store and content manager?
Give me any example of semi and non additive measures?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw