Re: Pre-query data and load into memory!!??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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/ShowForum.aspx?ForumID=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@xxxxxxxxxxx> wrote in message
news:eHdJqw4wGHA.4596@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxx> wrote in message
news:1155713713.248129.22310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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





.