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
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.
Explain what are the steps to be taken to schedule the report?
How to open a universe with out using the Designer ??
Explain how many universes can be created in a project?
What is the difference between absolute and relative div positioning?
How were the reports scheduled and how to resolve unexecuted documents?
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?
When we use aggregate awareness function in designer?
What is the difference between condition & filter?
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
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?
What is aggregate table and aggregate fact table ... Any examples of both?
Can anybody tell me what are the tuning problems?
Explain is there any default username & pwd for bo designer & supervisor?
Explain what task is 98% of the required work of a business analyst?