Answer / madhulika

Universe supports these joins mainly:
1.Equijoin
2.Non-equi join
3.Theta join
4.self join
5.s/c join
6.Outer join
7.Inner join

Answer / sam

we have Inner Join, Outer Join, Left Join, Right Join, Full
Outer join

Answer / ansari

Inner Join, outerjoin, left, right outer join, full outer
join

What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?

3 Answers   Perot Systems,

---

When we can use multiple sql statement for each measure? and multiple sql statement for each context?

2 Answers  

---

Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

2 Answers   iFlex,

---

Tell me the difference between cmc and cms?

4 Answers   Wipro,

---

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,

---

How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?

2 Answers  

---

What is the test methodology for testing BO Universes?

3 Answers   Cisco, TCS,

---

What are the security level used in BO?

6 Answers   Oracle,

---

Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please

1 Answers   HCL,

---

How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.

1 Answers   Cognizant, WinAlliance,

---

How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?

1 Answers   WinAlliance,

---

how u restrict the values?to display 5 values insted of 10 values?

4 Answers  

---