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
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 |
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 |
What is Designer?
What is the link option in the reporting Environment?
What are different types of saving options in web intelligence?
What is global filters and local filters
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
How we can add a comment in universe...?
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?
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 ..
how did u give developed universe to ur client?
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?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
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?