User`s guide

Adding subfolders and subcategories to the repository..........................................................98
5.4
To add a new subfolder or subcategory..................................................................................99
5.4.1
Adding items to the repository...............................................................................................99
5.5
Adding a text object or bitmap image.....................................................................................99
5.5.1
Adding a text object or bitmap image - another method........................................................100
5.5.2
Adding a custom function.....................................................................................................100
5.5.3
Adding a command...............................................................................................................101
5.5.4
Using repository objects in reports ......................................................................................101
5.6
Adding a text object or a bitmap image to a report...............................................................102
5.6.1
Adding a custom function to a report....................................................................................102
5.6.2
Adding a command to a report.............................................................................................103
5.6.3
Adding a list of values to a parameter...................................................................................103
5.6.4
Modifying objects in the repository.......................................................................................103
5.7
To modify a repository object...............................................................................................104
5.7.1
Updating connected repository objects in reports................................................................104
5.8
To set the update option......................................................................................................105
5.8.1
Deleting items from the repository.......................................................................................105
5.9
To delete an object from the repository................................................................................105
5.9.1
Using Undo in the repository................................................................................................106
5.10
Designing Optimized Web Reports.....................................................................................107Chapter 6
Overview..............................................................................................................................107
6.1
Key strategies for optimizing web reports............................................................................108
6.1.1
Scale with SAP BusinessObjects Business Intelligence platform .........................................108
6.2
Evaluation times for date functions in SAP BusinessObjects Business Intelligence platform .109
6.2.1
Making the right design choices...........................................................................................110
6.3
Using faster report formats..................................................................................................110
6.3.1
Choosing between live and saved data................................................................................111
6.3.2
Designing summary reports.................................................................................................112
6.3.3
Using subreports carefully....................................................................................................113
6.3.4
Using other design elements effectively...............................................................................115
6.3.5
Designing reports to maximize data sharing.........................................................................115
6.3.6
Streamlining your reporting environment..............................................................................116
6.4
Selecting the fastest database and connection....................................................................116
6.4.1
Using table indexes..............................................................................................................116
6.4.2
Improving table-linking choices.............................................................................................117
6.4.3
Using thread-safe database drivers......................................................................................117
6.4.4
Using stored procedures for faster processing.....................................................................118
6.4.5
Using enhanced record selection formulas ..........................................................................119
6.5
Pushing down record selection—an example.......................................................................119
6.5.1
Record selection performance tips.......................................................................................120
6.5.2
2012-03-145
Contents