how can we join two classes with full outer join.in join dialog box only one o

how can we join two classes with full outer join.in join
dialog box only one outer join check box is checked another on
e gone .for this any property is there in universe designer?

Question Posted / siddu.cherla

2 Answers
8653 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can we join two classes with full outer join.in join dialog box only one outer join check box ..

Answer / vikram

To be more elaborate:While designing the Universe,
1: Click the Parameter Tab of the Universe parameters
window.
2: There you can see a list of all the parameters the
designer uses. Select the ANSI 92 parameter. By default
its value is set as 'NO'. Change this value to 'YES'by
typing/overwriting in the same text box.
3: Now click on the 'CHANGE' tab to confirm the changed
value.
4: Save the Universe and go to the Query Panel to check
for the change. Now you will be able to select both the
check boxes to achive 'FULL OUTER JOIN'.

Cheers: :) Vikram

Is This Answer Correct ?

20 Yes

0 No

how can we join two classes with full outer join.in join dialog box only one outer join check box ..

Answer / prathish thomas

Include ANSI 92 in the Parameters in the universe, you will be able to select both check boxes to create a full outer join.

Is This Answer Correct ?

17 Yes

1 No

Post New Answer

More Business Objects Interview Questions

Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers Cap Gemini, Infinity, TCS,

I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?

2 Answers Patni,

what is diff between Decode and case ? Give some Example?

2 Answers

What are alertors in Business Objects?

5 Answers

What is the difference between Boxir2 and Boxir3?

1 Answers

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

4 Answers

what is optional prompt in boxi r2

4 Answers Mind Tree,

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers

1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?

1 Answers BNP Paribas,

how to connect the hyperlink in webi reports?

7 Answers TCS,

What is slicing and dicing in business objects?

4 Answers

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

0 Answers TCS, UST,

For more Business Objects Interview Questions Click Here