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

Difference between zabo and webi?

0 Answers

filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

2 Answers IBM,

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers

can anybody explain me in detail about software development life cycle of business objects in detail?

1 Answers

WHAT IS CARDINALITY?

7 Answers

What are the major problems will occur while migrating to the one version to another version?

2 Answers CTS,

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers

how can we overcome by loops?and also is it possible ,one user can different universe

4 Answers

i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance

3 Answers TCS,

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers

What is the difference between business requirement document and use case document.

0 Answers

Explain about derived tables?

2 Answers Cap Gemini,

For more Business Objects Interview Questions Click Here