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

Where do you edit cognos sql in report studio?

3 Answers   HCL,

hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers   TCS,

can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 Answers  

6. Which of them will increase the performance?

1 Answers  

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

2 Answers   HCL,

can reportnet supports cubes???

4 Answers   IBM, Wipro,

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

0 Answers   Wipro,

What is Model Versioning or Versioning in Cognos Framework Manager?

2 Answers   Systime,

what is the main advantage of impromptu over cognos reportnet?

0 Answers  

What are the methods by which it non-durable model could be changed into the durable model?

0 Answers  

How can we do the unit testing?

3 Answers   Logica CMG,

what is an outer join? difference between left outer join right outer join with an example?

1 Answers   HCL,