1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

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

Where will you find the address of repository in Business Objects?

4 Answers  

Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?

2 Answers  

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

6 Answers  

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers  

In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 Answers  




What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

7 Answers   TCS,

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  

What Is Snow Flake Schema?

0 Answers   Informatica,

What is Cartesian product?

14 Answers  

in universe perameter u dont give the option multiple contexts ,what is the impact in report level

2 Answers   Accenture,

Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,

what is the use of merge option in webi reports? explain with example?

2 Answers   TCS,

For more Business Objects Interview Questions Click Here
Categories