Pivot Table Client Cache

#1

Hi all,

Is there any (VBA) client or server cache setting that would allow an Excel
Pivot Table built from an AS cube to be available if the AS box were
down/cube unprocessed?

Thanks in advance.

#2

Unfortunately, No. The cube must be processed for it to be queryable.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"MarkFrank" <MarkFrank (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi all,

Is there any (VBA) client or server cache setting that would allow an
Excel
Pivot Table built from an AS cube to be available if the AS box were
down/cube unprocessed?

Thanks in advance.

#3

Perhaps local cubes could be used

Think there's some restrictions to what these can do with calc members
though...

"MarkFrank" <MarkFrank (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi all,

Is there any (VBA) client or server cache setting that would allow an
Excel
Pivot Table built from an AS cube to be available if the AS box were
down/cube unprocessed?

Thanks in advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Pivot Table Client Cache

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Pivot Table Client Cache - 10-20-2005 , 05:56 PM

Re: Pivot Table Client Cache - 10-22-2005 , 01:30 AM

Re: Pivot Table Client Cache - 10-26-2005 , 06:58 AM