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 Q7: What is the most effective way to improve the performance of opening a large pre-generated, pre- cached report instance, other than reducing the amount of data within the report?

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

I take it you are opening a scheduled report instance in native Webi format, where the Web Intelligence Processing Server has processed the report and uploaded the instance to the Output FRS? Because the time for connectivity to the DB and micro cube population already took place, it will likely be the creation of the […]

Read More

Johann Kottas Performance Q&A Q6: Dashboards question on UI components vs Excel functions: If I have 10 BEx query sources that need to be shown dynamically on user selection on a chart, is it better to have 10 charts that are dynamically displayed? Or one chart that reads from a spreadsheet array that is populated using vlookup of the 10 queries? And what about UI components vs. Excel logic?

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

vLookup should be avoided at all costs and will seriously impact performance. Dynamic visibility of multiple charts is the most straightforward solution. However, the BEx queries can be triggered as and when needed upon a condition, so you then have the best of both worlds by having a single chart (always best to use the […]

Read More

Johann Kottas Performance Q&A Q5: I would be interested to know how to make Design Studio dashboards run faster when using BEx queries as a data source? Especially compared to Qlickview, performance times are poor in Design Studio 1.3 SP2.

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

For Design Studio content that is processed on the BOE stack, you will typically find the following areas in the processing stack: Session generation for Analysis Application Service (includes security calls/InfoStore & CMS time) Processing of Design Studio Report components : Validate security: CMS core server calls for authentication and security checks Set Template and […]

Read More

Johann Kottas Performance Q&A Q4: When should we blame file store, CMS DB and Webi for performance problems in Webi reports? And what is the solution?

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

You can use the approach explained in the examples above: Find out first where you have a bottleneck or degradation. It is not common that the retrieval action from file store is causing delay. CMS Infostore queries, however, can be grounds for concern. Find out which queries in particular are holding up your execution. Solutions […]

Read More

Johann Kottas Performance Q&A Q3: How does the assessment change if you have, for example, a WebI refresh via JDBC on a HANA sidecar?

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

The same method can be applied however the fetch phase for JDBC happens by Web Intelligence Processing Server inproc. There is no outsourcing to connection server or DSL Bridge, but it’s done by CS JNI Engine inside WIPS. So to capture the JNI call stack you will need to update the cs.cfg under /dataAccess/connectionServer The […]

Read More

Johann Kottas Performance Q&A Q2: How do you actually pinpoint where a slowdown is taking place once the trace is set up?

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

Once you have an overview of the architectural workflow involved, you can determine the best method to capture where time is exactly spent during refresh execution. First, take several measurements without any traces or transactions enabled. Once you get a steady measurement, work out next how much overhead the enabling of traces and/or transactions add […]

Read More

Johann Kottas Performance Q&A Q1: Let’s start with an example of how you would assess time spent at each processing layer?

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

Let’s look at time spent per processing layer for a Web Intelligence refresh via OLAP BICS in BI 4.1 to HANA on BW. It is vital that you first work out the different processing layers involved. Make use of the SAP Client plugin to launch a BOE session. Activate the trace for the workflow you […]

Read More

We are looking for a well-organised, engaging and conscientious individual to join our team to help run our office

By: Nicolas Henry| April 9, 2015 logo

Xoomworks is a well established IT/Management consultancy based in the heart of London. We are looking for a well-organised, engaging and conscientious individual to join our team to help run our office. The Role: Office Support – to provide comprehensive administrative support to our London office. Hours: 10:00 – 15:30 Your responsibilities will include but […]

Read More

Dmitry Shustov is joining our BI team on the 1st April.

By: Nicolas Henry| March 27, 2015 Dmitry Shustov

Dmitry is a Principal Consultant at Xoomworks. Before joining Xoomworks he spent over 7 years with SAP as a SAP BW/HANA expert. Working in SAP Dmitry often dealt with big and complex BW/HANA solutions all over the world delivering assessment and optimization services, administration workshops for BW and HANA, participating in SAP global escalations and […]

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