BWOH based BO Reporting Performance enhancement steps

general discussion
1

Hi Friends

We are on HANA 1.X(DB) | BW 7.4 | BO 4.1

Prior migration we were using NonHana DB,Post migration we are using HANA-DB, could you please suggest possible modes/configuration areas where we can embed required parameters/property modes for better reporting performance in correlation with HANA

Regards
Bose

crystalrepxi (BOB member since 2010-09-02)

2

[Moderator Note: Moved from WebIntelligence XI to General Discussion]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

So the real question is: What is there to do to your SAP BW System (powered by HANA) to be optimally configured for HANA, right?

Andreas :de: (BOB member since 2002-06-20)

4

A simple internet search for HANA tuning turned this up as first result:

http://help.sap.com/hana/SAP_HANA_Troubleshooting_and_Performance_Analysis_Guide_en.pdf

Oh and this, further down the first page of results:

http://help.sap.com/saphelp_hanaplatform/helpdata/en/ad/5476a85ee2428185c001491232ad2a/content.htm?frameset=/en/d4/0b7097811a4b82ac46d491e9044bac/frameset.htm&current_toc=/en/85/d132c3f05e40a2b20c25aa5fd6331b/plain.htm&node_id=82

5

Hey Andreas 8) ,

Surely this is something that cannot be simply performed by using a few posts on the internet?

I suspect tuning HANA is a very specific skill and is different for each environment?
In addition there will be legacy stuff that will perform better if re-written using its proprietary language etc?

Cheers,

Mark.

Mak 1 :uk: (BOB member since 2005-01-06)

6

Hi All

Many Thanks for your responses.

I was mistaken during my post. my requirement in brief as below

Frontend/Reporting : BO 4.X
Backend: BW 7.4
Underlying DB for BW: HANA-DB(1.X)

In the sense we are using BW based Infoproviders as source in defining Universes & BICS connections but not HANA-DB

Post migration we can see performance increase in BW but couldn’t see the same in BO, Could you suggest your experiences please

Regards
Bose

crystalrepxi (BOB member since 2010-09-02)

7

You really need to go and do some research yourself…there really is a lot to learn.

You didn’t state what version of Business Objects 4x.

Here’s a couple of recommendations to get you started?

Have you converted the infocubes to the HANA optimized type?
Ref. BW on HANA and the Query Execution Mode and SAP Notes 1682992 and 1734002 for further information.

Check if modifying the execution mode and / or the infocube type improves the performance of BW queries.
See SAP Note 2016832 that describes how to adjust the query execution mode.

:?: Are you sure BICs is the best connection to use when connecting to infocubes on HANA?
:?: Also are you sure your BO server is of a good spec?
:?: Are you suffering from network latency?
:?: Are all the servers involved in the same data centre?

So much to cover, either research yourself, or engage some professional consultancy to get the job done.

Mak 1 :uk: (BOB member since 2005-01-06)