i have 2 fact and 2 dimension tables in my universe . my question is how get th

i have 2 fact and 2 dimension tables in my universe . my
question is how get the data with two fact tables in a report?

Question Posted / siddu.cherla

4 Answers
12631 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact..

Answer / sivakumar

Two Fact tables can be Joied through an confirmed dimension.
So any of the dimension should have the feature of
confirmed dimension.

Is This Answer Correct ?

12 Yes

2 No

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact..

Answer / sreedhar

There should be a dimension that will connect those two
fact tables which we call it as "Confirmed Dimension"

Is This Answer Correct ?

10 Yes

1 No

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact..

Answer / siddu

to create a derived table from two facts and you can use the derived table columns in report level

Is This Answer Correct ?

5 Yes

6 No

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact..

Answer / pradeep

Create a Short cut join between the two fact tables in the
universe.

Is This Answer Correct ?

2 Yes

8 No

Post New Answer

More Business Objects Interview Questions

Can we link the Universes from two different sourcess?Explain?

2 Answers IBM, Oracle,

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

0 Answers Patni,

Explain which versions are used in the bo dashboard work?

0 Answers

Can we take report on Excel in Business Objects?

6 Answers Business Intelligence Analytics, Oracle,

what is the difference between breaks and sections?

3 Answers IBM,

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

0 Answers

What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?

1 Answers NSE,

WHAT IS CARDINALITIES OF JOIN?

3 Answers

What is Complex Reports?

3 Answers TCS,

1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?

1 Answers IBM,

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

2 Answers Wipro,

What is diff between InfoView and Zero BOAdmin (ZABO)?

2 Answers Nucleus Software,

For more Business Objects Interview Questions Click Here