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?

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

what is difference between folders and category ?

4 Answers   Tech Mahindra,


how u link universes of same functional domain ?

2 Answers   Business Intelligence Analytics, IBM,


I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,


generally how do we get information for creating universes and reports

1 Answers   Satyam,


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

2 Answers   TCS,






How to get two dimension objects in a same block which are comming from two different contexts ?

1 Answers  


What would you consider as your biggest achievement and why?

0 Answers  


Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance

1 Answers  


what is prompt? Cascading prompt? Syntax

5 Answers   TCS,


What is shortcut join?could give any one example?

8 Answers  


What is the difference b/w the simple Universe and Complex Universe?

2 Answers  


5.what is slowly changing dimension ?

2 Answers   IBM,


Categories