OLAP-Cache filling and report retrieval from cache

November 30 0
Advertisement
Dear All,
I am expecting good information from you guys in regards to process of OLAP-Cache filling and retrieval process.
Let's say, we have few selectios as below to fill cache.
selection 1:
Calmonth : 201006
Plant : A1 to A3.
OLAP cache is filled with the above selection1.
Selection 2:
Calmonth : 201006
Plant : A4 to A5
OLAP cache is filled with the above selection2.
When I am exeuting a query with the selections as below, how the data will be retrived? Is it from Cache memory or DB?
Selection: Calmonth 201006 and Plant A3 to A4.
Would be really Appreciate If I get some valuable information.
Regards,
KS
Advertisement
Thanks for valuable information.
I have used the mode as "Persistent Cache per Application Server" and " Transparent Table (BLOB)"
What I am realizing here is, If the query selection is different from the cache selection, it is reading it from DB though the requested data is availabe in cache as per the below eg.
Cache Memory:
Selection1: Calmonth : 201006 and Plant : A1 to A2
Selection2: Calmonth : 201006 and Plant : A3 to A4.
Query Selection:
Calmonth : 201006 and Plant : A2 to A3.
Regards,
Kanagaraj.S
OLAP-Cache filling and report retrieval from cache

Dear All, I am expecting good information from you guys in regards to process of OLAP-Cache filling and retrieval process. Let's say, we have few selectios as below to fill cache. selection 1: Calmonth : 201006 Plant : A1 to A3. OLAP cache is filled

Pre-fill the OLAP cache for a query on Data change event  of infoprovider

Hi Gurus, I have to pre-fill the OLAP cache for a query,which has bad performance. I read a doc 'Periodic Jobs and Tasks in SAP BW' which suggested sum steps to do this i hav created the setting for Bex broadcasting for scheduling job Execution with

Automatic filling OLAP Cache

Hi @ll, i am using bw 3.5.... I`ve a question as to OLAP Cache. Is there any possibility/method to fill the Cache automatically every day? Id like to use the performance enhancement of caching queries....but i would like to avoid it that the first us

Fill OLAP cache via broadcaster

Hi, I'm trying to use the broadcaster with distribution type 'Fill OLAP cache' and schedule it using " Including Event Data Changes in Process Chains ". The process chain has been adapted with the 'Event data change' process and scheduled. Proce

Fill Olap cache distribution type

Hi, I'm trying to fill the olap cache with information broadcasting, but I cannot see option "Fill olap cache" in the distribution type. Only distribution type "broadcast E-Mail" and "Broadcast to portal" are present. I reach

Query mass Broadcasting to fill OLAP cache

Hi, I have +- 50 relative small queries that I'd like to precalculate each night (push them to the OLAP cache) as these queries are displayed together in one KPI dashboard. I know the Bex Broadcaster is the tool that should be used but at this moment

Filling OLAP Cache for 3 Bex queries

Dear Experts, Here, We would required to fill the OLAP cache for four bex queries using the Broadcaster Settings. can any one please suggest for the following. how to schedule the OLAP chache filling for 3 different queries at a time. do we need to p

OLAP Cache filling using Broadcasting

Hi All, We have two BEx queries which take more than 30 minutes to complete. One is an inventory cube query and other one is a query with a lot of exception aggregation. In the Statistics, both queries show that around 90% execution time is at OLAP l

Warming up the OLAP cache

Hi, I would like to schedule execution of some queries in order to put the results in the OLAP cache for fast use. Each user run the query with very restricted selection: one period, one node in the CostCenter hierarchy and one currency type! All the

OLAP Cache not invalidating

Hello People, I am having a problem with the OLAP Cache not invalidating when new data is loaded into the basic cubes that make up a multiprovider. In detail: I can run a report from a multi provider for which I will then see a cache entry in RSRT fo

Query views are not using OLAP cache

Hi, I am trying to pre-fill the OLAP cache with data from a query so as to improve the performance of query views.  I have read several documents on the topic, such as “How to… Performance Tuning with the OLAP Cache” (http://www.sapadvisors.com/resou

OLAP Caching question

Hi I'm not sure if this is the right forum, but I figured I would ask anyways. Using the broadcaster, I have configured a couple variable settings on a query to fill the OLAP Cache. Is there a way to update the parameter settings by an api instead of

InfoProvider OLAP Cache settings

The BI nw2004s 7.0 version is support stack 12 SAP_BW level 14.  How do you set the olap cache mode to flat file at an InfoProvider level.  Via rsrt, each query can be set, but the defaults are currently 'Cache without swapping'.  Want to change that

Regarding olap cache

Hi,    Can anyone kindly tell olap cache realtime issues.         Thanks in advance. Edited by: Muddus on Mar 10, 2010 7:48 AM Edited by: Muddus on Mar 10, 2010 7:48 AMHi, To optimize the report performance we will use it. see http://help.sap.com/sap

How to understand if olap cache is used

Hi, I am trying to understand if my query uses the olap cache or not. First I executed the report with specific selections. After that, I executed the report again with the same selections but it took almost same time to bring the report output. Ther

OLAP Cache for Query Performance

Hi Experts, I have below 2 Questions before we implement OLAP Cache for our Queries: 1) We have 15 imporatant queries - which do NOT have any variable/selection screen. (question here is will it work for those kind of queries which dont have any sele

Urgent  -  OLAP CACHE MODE 5

HI All, I have heard above cache mode 5 is available. Can anyone please explain about it and also please give me the SAP NOTE number. Thanks, Prashanth.Prashanth, If you are referring to cache mode : BLOB/Cluster Enhanced (5) Typically - the OLAP cac

Impact of real time cube on query performance and OLAP cache

Hi: We have actual and plan cubes both setup as real time cubes (only plan cube is being planned against, not actual cube) and both cubes are compressed once a day. We are planning on implementing BIA accelerator and have questions related to query p

Olap cache not storing result sets for certain queries

Hi - another cache question my result set for a query is not getting set in OLAP CACHE - the query variable level is stored ok but not the result set. different queries store the result sets ok. there is nothing in the query or cube properties that s

How to empty out Olap Cache for a query?

Hi experts, I think the olap cache for a query should be resetted to zero after a data load (right?), if i have understood well how it works. Where can i check the olap cache for the query?  I'd like to ckeck the change of the Olap Cache for a specif