Answer / vams_gk

to inprove the performence of the reports we have multiplw
ways in my view. for example

1)generate LOV for required objects
2)use aggregate tables in universe design
3)use pre defined conditions and formulas.
4)check context (if there resolve it)
5)check loops (if there resolve it through alias table)


if u did u all these at universe level,when u generate the
report at query panel level automatically performence will
increese

Answer / ratnakar neti

To improve the performance of Reports we have to check the
following .
1.check the number of subreports.If more number of
subreports are there it will kill the performance of the
report
2.check the loops. We have to reduce the no.of loops to
increase the performace of report
3.generate the Lov's

Answer / babu

Report performane will improve by the given following
things.

1. Should disable LOv's for unnessary measure objects.
2. Create conditions at Universe level and try to reduce
the variable's and bulit complex logic's in universe and
database level.
4. use query level filters.

Can we link the oracle and excel universess?

1 Answers  

---

When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,

---

Explain the difference between detect alias and detect context?

0 Answers  

---

what is projection function in SAP BO

1 Answers   Cap Gemini,

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

3 Answers   iFlex,

---

what is static filter and dynamic filter

1 Answers  

---

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers   Wipro,

---

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

0 Answers  

---

what is confirm dimension ?

11 Answers   IBM, Wipro,

---

Pls Explain about the different between 6.5 & Xi R2

2 Answers   IBM,

---

U r project in which stage in implementation?

0 Answers   Accenture,

---

why less number of records in loop? why more number of records in traps?

1 Answers   Wipro,

---