Answer Posted / sathyasheelanbe

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

Can anybody tell me what are the tuning problems?

2041

---

What is top business?

1058

---

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 ?

2053

---

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2902

---

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2184

---

Explain what are the measure objects?

982

---

Explain about alerts in bos, under what situation we need to use alerts?

1048

---

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1099

---

What is difference between custom hierarchy and report based hierarchy?

1008

---

What is the difference between condition & filter?

1452

---

Explain is data mart?

1011

---

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...

2092

---

explain in detail about type 3?

1011

---

Give some information on report bursting?

988

---

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1145

---