on 01-11-2007 5:44 AM
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..
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Niyati,
There is a presentation on OLAP cache in http://service.ssap.com/bi. That should help you.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.