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

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,

How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers Rolta,

In banking domain how many Fact tables,Dimension table are present?

0 Answers TCS, UST,

What is the server based ranking? and its usage?

2 Answers

Hi any done business objects certification.i am expecting some help from them.

6 Answers

what is profile and packages in BOXI??

1 Answers

What is sdlc in bo?

2 Answers

What is BOMain.Key?

5 Answers Cognizant,

my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers

HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

2 Answers

. In production reports, some dimensions are missing. how do you load these dimensions in production

2 Answers TCS,

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,

For more Business Objects Interview Questions Click Here