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

Xoomworks SAPInsider Q&A transcripts still available.

By: Nicolas Henry| April 9, 2015 SAP BI Mobile Purchase to Pay Dashboards

What’s Slowing Down Your BI Reports? Q&A on End-to-End Analysis of SAP BusinessObjects BI Performance with Johann Kottas Reporting on SAP BW without BEx: Q&A on SAP BusinessObjects Analysis and WebI Best Practices and Capabilities with Tom Kornfeld

Read More

Johann Kottas Performance Q&A Q23: What are the performance bottlenecks we can anticipate when using Production environment on VMs?

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

If all CPUs are dedicated then it should be similar to a physical server, aside from potentially having the disks on a share across the network However, if CPUs are not dedicated I believe you’re not technically supported, plus you do not have the resources you think you might…

Read More

Johann Kottas Performance Q&A Q22: In Webi is it better for performance to use one complex dimension/measure or is it better to combine more simple dimensions/measures?

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

In general the further back you can push your calculations, the better. However it is best to test and compare both scenarios.

Read More

Johann Kottas Performance Q&A Q21: Can you speak to how much overhead is added when executing a report via BW over HANA versus a direct query against HANA? Let’s say the BEx query would be very simple in terms of exception aggregation and unit of measure conversions, etc., but heavy in terms of objects used and high record volume. Is the overhead significant?

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

The impact from high data volumes will be comparable in both cases. In case of BW on HANA the most significant overhead comparing to direct reporting on HANA can come from BICS protocol and generation of Transient universe

Read More

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

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