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

Explain about embedded & standalone filters?difference between them

1 Answers  

Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

7 Answers   IBM,

advantages of cascade prompt ???

7 Answers   iFlex, Oracle,

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

3 Answers  

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

0 Answers   IBM,

How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

0 Answers   HCL,

What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....

4 Answers  

how to get the all values from a prompt using 'ALL' use and display value in prompt

3 Answers  

wat is called Model dimension?

0 Answers   IBM,

17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

3 Answers   TCS,

After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,

What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.

1 Answers