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
what will be the contents for a functional requirements specifications
How we drill up week to month?
What is a fantrap in business objects?
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 difference between zabo and webi?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is difference between webi and infoview?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain is there any default username & pwd for bo designer & supervisor?
How to open a universe with out using the Designer ??
What would you consider as your biggest achievement and why?
What is package in BO
Explain in detail about type 2(scd),
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!