Best Practice for caching AAO Analysis Views?

[Former Member]

Morning all -

I was wondering if there is a document that exists which explains the best practices for caching the underlying BEx where an Analysis View sits?

We are on BW 7.4 and my cache mode is set to D which seems to be recommended option for performance. We do not use Hana.

I have heard about people setting up a process chain to cache certain objects. Any thoughts?

Thanks for your time!

[Former Member · Accepted solution]

Have a look at the paragraph "Priming the Cache (Filling the Cache)" in this document:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0ebfba1-5a1a-2d10-82b5-fdddc1e59...

[Former Member · Accepted solution]

I'll take a look.

Thanks!

[Former Member · Accepted solution]

There isn't a version of this doc for BW 7.4? Reason why I ask is because the Cache Mode's are different now in BW 7.4

I am still looking into the cache settings & values.

Thanks!

[Former Member · Accepted solution]

This wiki for example seems to give a decent overview of the cache settings:

OLAP Cache - SAP NetWeaver Business Warehouse - SCN Wiki

Google on "Cache bw 7.4" should give quick results as well

The prinicple of filling the cache has not changed (basically scheduling the queries in background, either via Broadcasting, APD, publication of a Webi containing the query,....)