SSAS Cube Lifespan

[RileyCat]

I am a relatively newbie to SSAS although I am an experienced SQL programmer.

My question is about CUBE's. What is the lifespan of a cube?

i.e., I have a CUBE with a datasource to a SQL table that is updated nightly. How/when does the associated CUBE get updated? Does the user have to "Reconnect" or "Refresh" the CUBE to see the new data, or is there an automated way to update a CUBE when it's host table on the SQL side is updated?

Thanks!

Stay Cool Ya'll!

-- Kristin

 

[RiverGuy]

It's called cube processing. You schedule processing events. This can be to process an entire SSAS database, one or more dimensions, one or more cubes, one or more partitions of a measure group, etc.

There is also proactive caching, which I have never used, and I don't know anyone personally who has.

http://www.mssqltips.com/tip.asp?tip=1563