how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u
take ?
Answer Posted / anil kumar ganga
To increase the performance in designer
1. Use as much conditions as possible
2. Use array fetch parameter
3. Limit the number of rows in Universe parameters as per
ur need
4. Resolve loops completely etc.,
To increase performance in reports:
1. Avoid usage of more variables
2. Use indexes on columns
Still more points are there, i didn't remember. Any body
can continue this post
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain about a time when you discovered a more efficient way to do a work task?
Explain about alerts in bos, under what situation we need to use alerts?
What is Indexing? how did u implement indexing?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Did you face any problems while creating reports? Name? Solutions?
Explain how we drill up week to month?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain in detail about type 2(scd),
What is aggregate table and aggregate fact table ... Any examples of both?
Can we create universe with no cache??
Difference between b.o 5.1 and 6.1b?
Explain the difference between union and group?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain when to use local filter and when to use global filter?