Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to improve the performance of the report

Answer Posted / 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

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we configure two instances of CMS pointing to two different CMS system databases?

2034


Explain what three things do you consider to be the most important factors for a manager?

1012


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3478


Difference between zabo and webi?

1110


what is xcelsius architecture?

4586


Explain the difference between detect alias and detect context?

1109


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?

1023


What is difference between webi and infoview?

1266


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1050


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2341


Explain how many universes can be created in a project?

1066


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10403


Can more than 1 metric be applied on an analytic in business objects?

2171


what will be the contents for a functional requirements specifications

2358


What sort of existing documents should business analysts refer to when starting on a new project?

1010