Answer / amritha

I have no idea about BO6.5 however I feel that creating
Derived table must be similar in both XIR2 and BO6.5.

-right click any where in Designer.
-select Derived table from Popup menu.
-A window will open up. Give the name of the derived table,
You can specify the SQL stmt here as you do for example in
oracle(if you are using oracle DB).

Example:
select BONUS.ENAME Ename,DEPT.DEPTNO,EMP.EMPNO from
Bonus,dept,emp where EMP.DEPTNO=DEPT.DEPTNO

You can specify the join in SQL stmt if necessary.

However joining the Derived table indeed is similar as
joining a normal table.

Thanks,
Amritha

What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

1 Answers   Accenture,

---

What is the drill up , drill down, drill by , drill trough ?

3 Answers   TCS,

---

Give some information on report bursting?

0 Answers  

---

how to make a report avilable to other users?

2 Answers  

---

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

4 Answers  

---

Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that

3 Answers   BirlaSoft,

---

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  

---

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,

---

In a context can i get the data from two different factables by using the single data provider?

2 Answers   IBM,

---

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers   TCS,

---

WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI

5 Answers   TCS,

---

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

0 Answers  

---