cancel
Showing results for 
Search instead for 
Did you mean: 

LOCAL OLAP CACHE AND GLOBAL OLAP CACHE

Former Member
0 Kudos

what is local olap cache and global olap cache...

what is the difference between ....can you explain scenario plz...

will reward with points

thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Cache will be stored in the main memory and the local cache will be access by the same user in the same session on the same or different application server while global cache can be shared across all application servers over different users.

thanks.

Wond

Former Member
0 Kudos

could you please bit descriptive ....you are saying to use gloabal cache ... where can we find out which one we are using,... how can we access global cache...

iam not clear...

plz reply

thanks

Former Member
0 Kudos

In RSRT click on properties and you will see various type of settings at query level as well as infoprovider.

Check this

http://help.sap.com/saphelp_nw70/helpdata/en/41/b987eb1443534ba78a793f4beed9d5/frameset.htm

thanks.

Wond

Former Member
0 Kudos

Hello GURU

Local cache is specific to a user, before BW 3.0 it was only local cache available...if a user run the query data will come to cache from infoprovider and next time same query will not go to Data base instead it will fetch data from cache memory...this cache will be used only for that particular user...if some other user try the same query it will not pick up dta from cache.....

BW 3.0 onward we have global cache which means several user can access same cache for the same query or data which is related in cache...

Thanks

Tripple k

Answers (0)