ways to Boost BEx Query Performance?

[Former Member]

Hi,

What are different ways to boost BEx query performance?

Thanks in advance.

[Former Member]

First try to boost the data model, make sure you are accessing data from cube and the cube is also modeled (Dim and fact table ratio).

1. Indexing, partitioning of the cube.

2.Creating aggregates on the cube.

3. Cube compression.

<b>In front end side:</b>

1. Make sure you hit the cache if it exist.

2. Make sure your query is well designed (Avoid, exception).

3. Limit the data to be processed.

<b>Basis side:</b>

More application server.

Memory, limited user

Network bandwith

for detail please check this link.

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=query+performance&cat=sdn_weblog

thanks.

Wond

[Former Member]

Please search SDN Harshal there are lot of threads having discussed abt the same.

[Former Member]

Sorry Jr Roberto, I will make sure to search from next time.

Thank you.