BW Query Performance

[#1]

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