Question Re: BW Query Performance in Technology Q&A

BW Query Performance

Former Member — Tue, 26 Jun 2007 19:27:01 GMT

Hello SDN,

Does anyone know how to define a query to increase it performances, to make the query run faster?

The query was defined as follows:

Rows with 23-fields (3-fields are with the SAME data)

Columns Structure key figures with 3-fields

Free Characteristics with 14-fields

Please give me your input, thanks for your assistance and expertise!

Regards,

Nicolette Nguyen

Re: BW Query Performance

Former Member — Tue, 26 Jun 2007 19:31:36 GMT

Depending on your situation, you may consider the following. But which toll will help you improve the performance depends on your environment and query specifics, no of users, hardware & software config, etc.

Pl consider the following:

1. Query caching.

2. Query design ; especially avoid using "exclude" option.

3. Compression of requests from the info providers.

4. Collect BW statistics and install the BW technical content.

5. Monitor table RSDDSTAT.

6. Run RSRT and see what the system has to say abut the query.

7.last , but not the lease, look at the cube design itself and try to reorganise dimensions.

Ravi Thothadri

Re: BW Query Performance

Former Member — Tue, 26 Jun 2007 21:37:18 GMT

Hello Ravi, the info was very informative and helpful, please advice what tcode RSRT do?

Thanks for your assistance.

Regards,

Niki Nguyen

Valero Energy

Re: BW Query Performance

Former Member — Tue, 26 Jun 2007 21:41:12 GMT

RSRT is query monitor.

You can scan the query in this transaction and subject the query to various options and observe the results.

Pl explore RSRT.

Ravi Thothadri

Re: BW Query Performance

edwin_harpino — Tue, 26 Jun 2007 23:47:12 GMT

hi Nicolette,

for query design checklist, Prakash has written blogs for this, take a look

/people/prakash.darji/blog/2006/01/27/query-creation-checklist

/people/prakash.darji/blog/2006/01/26/query-optimization

check also

BW Performance Tuning Knowledge Center - SAP Developer Network (SDN)

[original link is broken]

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3f66ba90-0201-0010-ac8d-b61d8fd9abe9

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cccad390-0201-0010-5093-fd9ec8157802

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ce7fb368-0601-0010-64ba-fadc985a1f94

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/c8c4d794-0501-0010-a693-918a17e663cc

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/064fed90-0201-0010-13ae-b16fa4dab695

oss note

557870 'FAQ BW Query Performance'

and 567746 'Composite note BW 3.x performance Query and Web'.

hope this helps.

Re: BW Query Performance

Former Member — Wed, 27 Jun 2007 15:18:50 GMT

Hello Edwin,

In Prakash's blog for Query Creation Checklist, he has mentioned a lot about GLOBAL filter on the following issues:

Exclusions

Constant Selection

Time

MultiProviders

Calculated and Restricted Key Figures

Could you please clarify, what does he means by GLOBAL filter, in the query or where?

Thanks for your assistance.

Regards,

Niki Nguyen

Message was edited by:

Niki Nguyen