Answer Posted / naveen.g

using prameters in universe level.
creating view in database level.
creating index in database leavel.
increasing araay fetch size.
increasing arry bind size.
using correct operator,expression in report level.

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6776

---

How to create Index to the table in the universe designer and how it improves the Query performence

2502

---

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4674

---

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1468

---

in sap bi we have wad, then why we go for sap bo

3327

---

What is aggregate table and aggregate fact table ... Any examples of both?

1003

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1790

---

Did you face any problems while creating reports? Name? Solutions?

3643

---

How to schedule the report in b.o?

955

---

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

970

---

what is document design in boxi,have u participate in that

2085

---

What is the difference between slice and dice and cross tab report?

995

---

Explain when we use aggregate awareness function in designer?

974

---

Explain is there any other repository domains rather than universe, security, document?

1008

---

Explain how to schedule the report in b.o?

975

---