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
What are the types of studio present in Cognos?
whats the difference between previous version of cognos and cognos 8 BI?
What are the other methods working as deployment functionality?
How do we drill through from a powerplay cube to reportnet?\
How can create users and permissions in cognos?
What you mean by drill across and what is the difference between drill through, drill across?
What are the methods by which it non-durable model could be changed into the durable model?
What are the considerations regarding performance kept in mind while setting up cognos?
What is the deployment requirements used in cognos?
how to test reports in cognos?
Write various indexes used in cognos?
what are the features in cognos8ui
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
how can I test reports in cagnos?
What is Additive function?