How to connect three fact tables?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1628


Can you define materialized view?

621


what is model and say about process how to create model and how to test model?

559


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

1693


explain how to create powerplay reports?

611






What is the difference between Standard and Metrics folder?

573


Why is auto-regression used in forecasting used on cognos platform?

542


What is the importance of having monitor service in cognos?

583


What do you understand by ‘ibm predictive maintenance and quality’?

565


Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4214


how can you get the errors in job? when loops are araised we get error?

1654


please please give me some banking calculations in framework manager.

1657


What is Additive function?

1558


Can you define folder?

565


Write types of folders present in cognos?

570