PERFORMANCE
TUNING
200.
What
are the data load tuning one can do?
Load
balance on different servers
Indexes
on source tables
Use
fixed length files if data is loaded from flat files and put the file
on the application server
Use
content (SAP delivered) extractor as much as possible
Use
“PSA and Data target in parallel” option in the InfoPackage
Start
several InfoPackages parallel with different selection options
Buffer
the SID number ranges when lot of data is loaded at once
Load
Master Data before loading Transaction Data
Watch
out the ABAP code in transfer and Update rules – This might slow
performance
201.
What
are the general tuning guidelines?
Archive
and delete old data
Use
line item dimensions for large dimensions
Use
MultiProviders to parallel query on the basic InfoCubes
Use
the BW statistics InfoCube to monitor performance
Reporting
authorizations slow the performance
Web
reporting is faster than BEx reporting
Use
the aggregate hierarchies to minimize the roll-up time
Use
parallel upload and activation of ODS objects
Disable
the BEx reporting flag if ODS is not used for reporting
202.
Ways
to improve the performance
Define
as many dimensions as possible.
Create
aggregates
Check
and define Line Item Dimension
