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);

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 Answers  

---

how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????

2 Answers   Infosys, Keane India Ltd,

---

what is merged imension in 6.5 and webi

1 Answers  

---

WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI

5 Answers   TCS,

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

3 Answers  

---

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

0 Answers  

---

5.what is slowly changing dimension ?

2 Answers   IBM,

---

What is the difference between the public object&schema object?

0 Answers  

---

How maually can i define ? If thousends of records exists in a table?

1 Answers   Infotech,

---

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

0 Answers   TCS,

---

What are the Users and Usergroups?

1 Answers  

---

wha is the difference b/w merge dimension and combining two different data providers?

1 Answers  

---