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?
Answer Posted / 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 |
Post New Answer View All Answers
What Is The Difference Between Oltp And Olap?
How would you format some text using css to be verdana and bold?
When to use local filter and when to use global filter?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
how to create metric universe ?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is difference between webi and infoview?
What we need to discuss with designer before starting the universe designing.
Difference between zabo and webi?
What is the difference in creating filters in designer and business objects?
Explain is there any default username & pwd for bo designer & supervisor?
Explain what are the steps to be taken to schedule the report?
What are all difference between business objects 6.5 and xi r2?
Explain about a time when you discovered a more efficient way to do a work task?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...