Answer / mohanraj

Match Pattern: LIKE
Diff Pattern: NOT LIKE
Except : NOT EQUAL TO (OR) NOT IN
Both : UNION

Answer / sunder

Except:
(
SELECT DEPT.DEPTNO, DEPT.DNAME, DEPT.LOC, EMP.ENAME
FROM DEPT, EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
MINUS
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'JONES')

Both:
(
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'ADAMS'
INTERSECT
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'ALLEN'
)

Match Pattern: LIKE “ABC%”
DFFERENT PATTERN: NOT LIKE “ABC%”

What is report template in b.o?

0 Answers  

---

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

0 Answers  

---

I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

2 Answers   Rolta,

---

I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.

2 Answers   L&T,

---

1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,

---

1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 Answers  

---

1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?

1 Answers   IBM,

---

Explain how many universes can be created in a project?

0 Answers  

---

what are the day to day activities of BO administrator ?

0 Answers   TCS,

---

what is isolated joins in check integrity

2 Answers   Accenture, Polaris,

---

can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  

---

What are the data types present in bo? What happens if we implement view in the designer and report?

0 Answers  

---