Interested to Buy Any Domain ? << Click Here >> for more details...
how we improve the performance of report and universe?
- 4 Answers
- 15322 Views
- Accenture, IBM, I also Faced
- E-Mail Answers
Answer Posted / sourabh
For performance of universe
1. One should never make alias of Fact tables, that
make universe very slow.
2. More number of contexts should be used rather than
creating aliases of tables.
3. Measure function must have projection function set
to Database delegated.
For report performance
1. It is better to make SQL Queries rather then using
sub reports in report.
2. Drill down Dimensions being used on report should
have hierarchy defined.
3. Create index awareness in objects.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the data types present in bo and what happens if we implement view in the designer and report?
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.
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
When to use local filter and when to use global filter?
What is top business?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
In banking domain how many Fact tables,Dimension table are present?
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
Explain what would you consider as your biggest achievement and why?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Did you face any problems while creating reports? Name? Solutions?
Explain the difference between detect alias and detect context?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
can anybody tell me about complicated object you have created
