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

2.How do you drill through report from Report Studio to Analysis studio?

3 Answers   IBM,

What is the use of cognos decision stream?

0 Answers  

How to hide the prompts

4 Answers  

how to find the rank in report studio? i need steps for this question.

2 Answers  

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,

Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.

2 Answers  

How many types of models are present in cognos.?

4 Answers  

what is report view?

4 Answers   Cap Gemini,

I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?

2 Answers   IBM,

What is Portal Tab?

1 Answers  

How you drill from powerPLay to Impromptu?Explain all Steps?

2 Answers  

What is the difference btw reportnet - Report studio and cognos 8 - Report studio

3 Answers   Dominion,