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 Q20: How can we capture the runtime breakup of a scheduled Webi Report?

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

You can use the same method as explained in my example at the start of the Q&A, and use the plugin from the CMC to run the job as now. Or you set traces on low for the services involved via the CMC. But this could cause a large overhead if you have a heavy […]

Read More

Johann Kottas Performance Q&A Q19: For my Dashboard tool application, the BI Launchpad takes too much time to open – not less than 45 seconds, sometimes even 1 minute. How can we optimize the opening of dashboards?

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

If backend processing I suggest starting with analysis of the footprint and processing on the local client. You can use httpwatch Basic for the initial view.

Read More

Johann Kottas Performance Q&A Q18: The company I work for recently upgraded from SAP BusinessObjects XI 3.1 to SAP BusinessObjects BI 4.1 version. We are still using Universe Design Tool (.unv) for our universes. I would like to ask you what are the compelling reasons to move the universes to Information Design Tool (.unx)? From a back-end perspective using UNX based queries consume more resources, which could affect performance, I believe.We’re using mostly Oracle databases.

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

To be honest the benefits in moving when using more traditional relational data sources aren’t as great… using UNX will push your query to the DSL Bridge stack, which allows you to use the Java parameters on the DSL bridge to tune it. But other than that I don’t see a huge benefit (unless you […]

Read More

Johann Kottas Performance Q&A Q17: Question on WebI using hierarchies from BEx queries: Let’s say I have a hierarchy characteristic in my BEx query. In the query panel, I choose to display specific levels of the hierarchy in the report. This drastically slows down the report. When no levels are specifically chosen, the report is much faster. I might be wrong, but shouldn’t the data retrieval be faster in the former case?

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

Most probably different BICS calls to BW are used to get the whole hierarchy or particular level (nodes) of this hierarchy. In the second case there could be many small calls causing a performance issue. You can investigate it by collecting ST12/RSTT traces and check SAP notes looking for optimizations related to particular BICS calls.

Read More

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

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