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

What is meant by data federator and what is the use of it?

2 Answers TCS,

I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?

2 Answers Accenture,

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers

Difference between Decode and Case?

1 Answers NIIT, TCS,

Can any one say me wat does"maintanence of universe" means wit?

2 Answers Business Intelligence Analytics, NAL, TCS,

can any body tell me how to create Hyperlinks in BO XI R2?

2 Answers

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers TCS,

What is BOMain.Key?

5 Answers Cognizant,

What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers IBM,

What are the join problems comes appart from loop,chasm & fan Traps

0 Answers IBM,

What is a Set?

1 Answers

What is Complex Reports?

3 Answers TCS,

For more Business Objects Interview Questions Click Here