BI Blog

Get the latest BI insights from our experts

blog image

Subscribe to BI Blog

Get periodic updates and news delivered to your email

Johann Kottas Performance Q&A Q16: Can we do a parallel processing of BEx queries on the BW side if my Webi report is using multiple BEx queries, so that the performance will increase?

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

It’s not driven by BW but by the reporting application. Webi does execute all calls to BW serially, even the grouping sets.

Read More

Johann Kottas Performance Q&A Q15: We’re seeing a lot of questions about common performance holdups. Can you list some that are easily overlooked?

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

Initial concern is often lack of server resources; configuration or setup (distribution) matters. Those reservations certainly need verifying and in large enterprise systems with clustered CMS, the distribution of services is an important aspect, as is the heap assignment and configuration. Those anxieties can be easily validated. My suggestion is to start with analyzing a […]

Read More

Johann Kottas Performance Q&A Q14: What do you suggest for BusinessObjects 4.1 based on MS SQL server (extracted data from SAP with Data Services, based on standard SAP RapidMarts)?

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

If there is a specific issue it may differ, but in general, the traces that have been discussed using the client plugin will be a good start. Ensuring indexes are created, maintained and rebuilt on the SQL Server side through the DS job will also be of use. Does the connection use SSO to SQL […]

Read More

Johann Kottas Performance Q&A Q13: Question on Design Studio data volume limitations: There is a limit of 50K records for data from the universe. Are there the same limitations for data from NetWeaver or HANA, and is it possible to change these limitations?

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

There should not be any limit for the result set of standard DS components. Extension components developed with SDK are limited with 10,000 cells. SAP recommends keeping the number of cells below 10K for good performance.

Read More

Johann Kottas Performance Q&A Q12: Is it possible to precalculate SAP BusinessObjects Analysis for Excel reports, similar to the instances for WebI reports? Or any other possibility for very fast report response time without HANA?

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

Are you referring to SAP Analysis edition for MS Office? In that case you will have to install Analysis BI platform Add-On. Once done, you can schedule Analysis workbooks in the BI Launch Pad and the Central Management Console.

Read More

Johann Kottas Performance Q&A Q11: BusinessObjects publications sent to a fileserver in PDF format take way too much time! For 4,000 files, it can take 5 to 10 hours. How can we achieve improved throughput? FYI – the same WebI report refresh online (in the Launchpad) completes within 10 minutes.

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

a lot will depend on the publication setup, the report design/universe feeding the publication, content type, your server capacity and the setup and report bursting method used. For example, I have witnessed a large overhead with one database fetch for all recipients as the bursting method. With output in native Webi format, a lot of […]

Read More

Johann Kottas Performance Q&A Q10: Report performance is inconsistent, making it very difficult to analyze. Any suggestions?

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

My suggestion is to start taking on the exercise (as explained in the examples at the start of the Q&A) to find out where time is exactly spent for several executions. You can now compare the output between a fast and slow execution and check where the inconsistency occurs.

Read More

Johann Kottas Performance Q&A Q9: Where should we start when a regularly scheduled report that never had an issue starts to fail frequently?

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

Johann Kottas: What message are you getting for the failure in the Instance Manager? That might give you an indication already during which part of scheduling process workflow the issue occurs. There will be interaction between CMS, Job Server, Processing Server, Input FRS and Connection Server. If you see exception logging activated via BO_trace.ini, it’s […]

Read More

Johann Kottas Performance Q&A Q8: We have some data load that takes longer on the first day of week, especially when the data source is based on view, but it is fine during rest of week. Any suggestions?

By: Nicolas Henry| April 9, 2015 SAP specialist John Kottas

I’m not entirely sure what you mean by data load. Are you talking about ETL or report refresh? My guess would be that you have an ETL process running over the week and the “view” you talk about needs to be refreshed and all the calculations done on Monday and you are hitting the cached […]

Read More

What can we do for you?

Our Business Intelligence experts would love to hear from you. Just send us an email or call and we'll get back to you.

phone

+44 (0)20 7400 6120

+44 (0)20 7400 6120

Xoomworks Ltd,
Dunstan House, 14a St.
Cross Street, London, EC1N 8XA