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 Designer?

2 Answers  


What is the link option in the reporting Environment?

3 Answers  


What are different types of saving options in web intelligence?

7 Answers  


What is global filters and local filters

3 Answers   IBM,


WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers  






How we can add a comment in universe...?

1 Answers  


GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?

1 Answers  


if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

1 Answers   TCS,


how did u give developed universe to ur client?

1 Answers  


1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?

4 Answers   IBM,


What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  


Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

2 Answers   HCL,


Categories