At an interview, I was told that the data was pre-processed and loaded
into memory ready for querying??

I had no clue of what the interviewer was talking about. Is this
possible? if so, can you please elaborate a little or show me where can
I read about this?

Thanks

Ken

you can cache data in a cube (using AS2005) by using the cache keyword into
the calculate statement.
this will preload the data you want in memory.

you can also execute MDX queries using an external script and this will fill
the cache regarding these queries.

sample cache usage: (from BOL)
Scope (Customers.Geography.USA);
Sales = 1.1 * (Sales, Time.Year.PrevMember);
Cache (Sales, Time.Year);
End Scope;

"SQL Ken" <SQLken (AT) gmail (DOT) com> wrote

The CACHE statement is not supported in AS 2005 and should be removed from
Books Online in the next refresh.

I'm not sure what the interview was talking about. I would guess it was
generally about warming the server cache -- which you can do by sending
typical queries to the cube. A simple way to do this would be to run
Profiler against the server and then choose typical queries from the log and
re-run them when you restart the server.

If the interview was about AS 2000 then dimensions in AS 2000 are
memory-resident...

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jeje" <willgart (AT) hotmail (DOT) com> wrote