OLAP cache..

[Former Member]

Hi friends , I have gone through a lot of documents regarding olap cahe for improving the performance of query , i got the function of this olap cache , but very confused in the steps .

Can anybody tell me the steps regarding how to improve query perofrmance using OLAP cache .

Thanks..

[Former Member]

Hi Niyati,

For Cube indexes:

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a6473e07211d2acb80000e829fbfe/content.htm

For ODS indexes:

http://help.sap.com/saphelp_nw04/helpdata/en/e6/bb01580c9411d5b2df0050da4c74dc/content.htm

Bye

Dinesh

[Former Member]

Hi Niyati,

Like DB table indexes the cube indexes searches and fetches the data faster there by improving query performance.

You can create the index in RSA1 -> Cube -> Manage -> Performance tab -> indexes.

Bye

Dinesh

[Former Member]

Thanks guys i have awarded pts to u, can u please explain me how the indexs are useful for improving the query performance , and how to create them.

thanks ..

[Former Member]

Hi

Refer this

Assign points if useful

Thanks

N Ganesh

[Former Member]

Hi Niyati,

There is a presentation on OLAP cache in http://service.ssap.com/bi. That should help you.

Bye

Dinesh