Hi,

I am testing proactive caching on dimensions on SQL 2005 Enterprise Edition.
So, I have a very simple parent-child dimension table and simply try to
create a ROLAP dimension based on it with proactive caching.
Build works, deploy fails with the following metadata error (sorry, it's in
french):

Error 1 Erreurs dans le gestionnaire de métadonnées. L'objet de mise en
cache proactive de la dimension MOLAP « Offer Dim TR » n'a pas de durée
définie pour l'intervalle de latence, la valeur de remplacement de
l’intervalle de latence ou l'intervalle de reconstruction forcée. 0 0
This looks very strange since the dimension's storage mode property is set
to ROLAP and not MOLAP.

Is this feature not supported ? is there a way to perform this correctly ?

Many thx & rgds
Francois

I can't read the French so I don't know the exact nature of the error.
But from my understanding of proactive caching - it is meant to work
with MOLAP storage. It proactively reprocesses the MOLAP storage when
the underlying data changes, so it does not make sense to try and setup
proactive caching for ROLAP storage.

HTH

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <6D12778A-FC8C-4009-B4B1-624C9A01B324 (AT) microsoft (DOT) com>, "=?Utf-
8?B?RnJhbmNvaXMgQmFiaW4=?=" <Francois Babin (AT) discussions (DOT) microsoft.com>
says...