how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u
take ?

Answer Posted / poonam tekchandani

To increase the performance in universe:

-as possile as use less number of joins
- avoid use of user objects
- use aggregate awareness

To increase the performance in reports:
- avoid use of user objects

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about a time when you discovered a more efficient way to do a work task?

848


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1972


Explain in detail about type 1?

879


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1650


What is the profile and package?

2052


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2043


What is Indexing? how did u implement indexing?

1985


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1683


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

1834


Explain what are the steps to do to use alerts in bo?

794


Explain the data types present in bo and what happens if we implement view in the designer and report?

768


What is the difference between datawarehousing and businessintelligence?

832


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

1836


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

4495


What is difference between webi and infoview?

872