#SAP #CrystalReports Performance Tips

Per my previous posting, http://www.bloomconsultingbi.com/2013/02/crystal-reports-possibility.html I've been getting re-familiar with Crystal Reports, Business Objects Enterprise, XCelcius.

And in order to do that I posted a few blogs to install Crystal Reports 2011, http://www.bloomconsultingbi.com/2013/02/installing-sap-crystalreports-bi.html as well as installing Crystal Enterprise 2011, http://www.bloomconsultingbi.com/2013/02/installing-sap-crystal-server.html .

Much of Crystal Reports hasn't changed much over the years, however, much has.

And the changes appear to be good ones.

And the project I'm interviewing for has to do with increasing performance on Sub-Reports pointing to SAP Business Warehouse Accelerator, which basically takes cubes in a Universe and compresses them for optimal speed.

However, I've summarized a few tips from researching the internet and they are as follows:
  1. Driver - verify the correct one is used
  2. Creating the report - makes a difference if you File->New vs. Toolbar->New
  3. Saving the report - makes a difference if you File->New vs. Toolbar->New
  4. Configuring the Toolbar - set default to not use Query Driver
  5. Use BW Publishing to deploy reports - affects Params static vs. dynamic and show Hierarchy's
  6. Params - better to create variables in BW
  7. Verify DB, if underlying cube has changed
  8. Avoid PageNofM and Page#
  9. Avoid multiple data sources
  10. Schedule batch reports
  11. Sub-Reports - *** On-demand increases performance
  12. Sub-Reports - Linked vs. Unlinked - linked adds logic to Record Selection
  13. Sub-Reports - placement in main reports matters - avoid placing in details
  14. Performance Information - new feature displays stats on Main & Sub Reports
  15. Perform Grouping on Server
And some links: 

This list is basically a 'cheat sheet' for if I do get the project I'm interviewing for.

Although it's part time for 1-2 weeks, it would be a great challenge to identify the slowness of the sub-reports.

We'll see what happens...

and here's a posting on how to install Crystal Server...


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder