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 |
Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance
1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?
How can we change any header or footer for a group of reports
1 Answers Satyam, Tech Mahindra,
Can we test the report other than manual testing?
1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
In framework Manager, what is a stitch query and is it good or bad?
Define report item?
5. Which type of report you build more, list, crosstab or chart and why?
I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh
faq's on cognos
What is meant by Reportstudio shortcut?