Answer / srini

Using conformed diemsion tables

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.

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".

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

Answer / ambareesh

vinod kumar reddy told wrong answer.
using pk and fk we can connect 3 fact tables

Answer / x

Through primary keys and foreign keys

Answer / chitwan

Using Stitch Query Concept.

Answer / moon

Bhadra given currect answer ....................

Answer / ganesh

we can connect two r more fact tables using dimension tables

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??

advantages of cascade prompt ???

3 Answers   iFlex,

---------------Describe OLAP Reporting and RDBMS Reporting?

0 Answers   Bank Of America,

What is the difference between low affinity and high affinity connections?

0 Answers  

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  

How can we create regular dimensions & measure dimensions?

2 Answers  

what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?

2 Answers   IBM,

Can i apply drill through on master detail relationship report?

2 Answers   TCS,

How to hide/unhide the prompts which are not used by unauthorized users?

3 Answers  

Can you define cognos impromptu?

0 Answers  

How many fact tables you have in your project?

1 Answers   HCL,

what is online view?

0 Answers   HCL,

What is the advantage of using shortcuts?

0 Answers