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

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

0 Answers

What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?

3 Answers

6.what is conformed dimension? R u used?

8 Answers TCS,

what is fantrap ?

5 Answers Tech Mahindra,

What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples

2 Answers NTT Data,

what is the difference between bo and cognos?

1 Answers

Explain how to execute the plsql procedure from the report by clicking with mouse?

0 Answers

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers

1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers

How many built-in objects are created in Business Objects repository?

2 Answers

how we transport universes from business objects 6.5 to BOXI R2?

3 Answers

what are they different types of report in BO?

6 Answers

For more Business Objects Interview Questions Click Here