Answer / san

It's not at all possible to create duplicate columns in a
SQL table. The how can we delete the duplicate columns?

Answer / sathyasheelanbe

delete from tablename where rowid not in(select max(rowid)
from tablename group by primary key columnname)

Answer / subash

In this query the values will delete based on employee names

delete from emp a1 where rowid<(select max(rowid)from emp a2
where a1.ename = a2.ename group by a2.ename having count(1) >1);

How to hide objects or columns?

6 Answers   Infotech,

---

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

4 Answers   HCL,

---

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

2 Answers  

---

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,

---

i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me

0 Answers  

---

why we use aggregation in lower level

1 Answers   TCS,

---

What is security level in BO ?

3 Answers   Accenture,

---

how do u implement dense rank in bo reports?

2 Answers   CTS,

---

'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.

1 Answers  

---

Hi any done business objects certification.i am expecting some help from them.

6 Answers  

---

How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?

1 Answers  

---

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

4 Answers   CitiGroup,

---