How to connect three fact tables?
Answers were Sorted based on User's Feedback
Answer / shree uday
As per Srini post, Confirmed Dimension is right,
If a dimension table which is shared by more than one fact
table is called Confirmed Dimension.
But its not advicable, Coz, it will take a time and also it
going to be trouble.
The primary condition is both the dimension should equal
For eg,Time dimesion.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramana reddy
hi,this is ramana reddy from chennai.i hope that everone is
correct their way but thing is to that ,we can conncect 1 r
more then one fact table by using "aggregate awareness"
concept and this process we use to call "fact constilation".
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / ganesh
we can connect two r more fact tables using dimension tables
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prit
if i got u, i would like to know what if i join these 3
tables(nothing but FACT Table) with their keys. Raman, is
COGNOS provides AGGREGATE AWARENESS concept??
Is This Answer Correct ? | 0 Yes | 1 No |
How can you link a query to a data container manually in Report Studio?
Write types of folders present in cognos?
Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.
can you tell me what are the dimension tables are used in project
Can i apply drill through on master detail relationship report?
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
How to test a cube?
Once reports are delivered to client, how will they inform back? If they are experiencing any problem in the reports.
data import to models, datastores,stored processed, is there any other way to import data?
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
explain how to create powerplay reports?
What is difference between drill through and drill down?