OLAP-Cache filling and report retrieval from cache
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.
Calmonth : 201006
Plant : A1 to A3.
OLAP cache is filled with the above selection1.
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.
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.
Selection1: Calmonth : 201006 and Plant : A1 to A2
Selection2: Calmonth : 201006 and Plant : A3 to A4.
Calmonth : 201006 and Plant : A2 to A3.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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