1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

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 do u mean by variable functions ?

2 Answers  

What are the difference between merge,auto merge and extended merge ?

1 Answers   Cap Gemini,

what are the disadvantages of alias?

6 Answers   Patni,

what are the tables used in health care domain project and columns used in report?

0 Answers   IBM,

What is the difference between user and versatile user?

0 Answers  




how u restrict the values?to display 5 values insted of 10 values?

4 Answers  

what is aggregate navigation?

3 Answers   Countrywide, CTS, HCL,

Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx

4 Answers  

There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?

2 Answers  

Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

3 Answers   AOL,

how to do Ad-hoc reporting ?

6 Answers   IBM,

what is traffic lighting in business objects?

1 Answers  

For more Business Objects Interview Questions Click Here
Categories