cancel
Showing results for 
Search instead for 
Did you mean: 

Will BW indexing help Webi reports performance

sateesh_kumar1
Active Contributor
0 Kudos
57

Hi Experts,

Environment

BO Version:4.1 SP3

Reporting Database:BW 7.4 sp3

Recently we have applied the OSS note :. 0001898395 so that we enabled index on the master data.

We have applied the note and had the index on the 0profit_ctr in the Infoobject: 0mat_plant.

Reports are fast in BEX side but there is no difference in webi reports performance.

Our opinion is if BEx performance is increased obviously WEbi performance also should increase.

Please post your experiences..

Thank you,,

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Several things will affect the report speed. Note that there are two halves to it - the data source fetch time and the report render time.

Data source fetch time is the time that it takes for all the data to be returned. BO will always look slower than the native tool because the native tool starts spooling out results as soon as it retrieves the first one - the more data returned, the slower BO will look by comparison.

Report render time will depend upon the number and complexity of variables as well as the number of rows returned.

Reducing the volume of data with correct aggregations and filters rather than summing and filtering at report level are the two best ways to improve performance without database/universe access.

sateesh_kumar1
Active Contributor
0 Kudos

Hi Mark

Thank you for response. What exactly we want to know is , is indexing only works when refreshing BEx from BW and not from BO?

How to check stats whether indexing is getting hit when running the BEx query.

Former Member
0 Kudos

I would imagine that you'd look to the equivalent of the person who is the DBA in an Oracle/SQL world and get them to see the actual query that hits BW.

Certainly from a relational database point of view, I can see the SQL that hits the database and what indexes (if any) are used.