BW Query Performance

[Former Member]

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

[edwin_harpino]

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-b61...

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

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

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

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

oss note

557870 'FAQ BW Query Performance'

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

hope this helps.

[Former Member]

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

[Former Member]

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

[Former Member]

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

Thanks for your assistance.

Regards,

Niki Nguyen

Valero Energy

[Former Member]

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