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

can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?

3 Answers  

---

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.

3 Answers  

---

Can anyone plz tell me How to create universe in business objects enterprise 11.5

3 Answers  

---

why measure objects are semantically dynamic?

1 Answers  

---

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,

---

---

How to import BIAR file in bo?

1 Answers   Emirates, Zensar,

---

What is the difference between Boxir2 and Boxir3?

1 Answers  

---

What is report template in b.o?

0 Answers  

---

can any one tell me how to create a new universe from scrach with step by step process.

4 Answers   HCL,

---

any difficulitis have you phase while creating bo reports and how did u solve it

0 Answers  

---

WHAT IS CARDINALITY?

7 Answers  

---

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

2 Answers   Patni,

---