I see... So the aggregations are not updated along with the other cube objects even when the cube is fully re-processed... Isn't this a bad thing? I...

Hi guys,

Sorry for the confusion. I meant to ask if it is really important to keep the member count updated before re-processing. And, yes, I was going to...

Thanks, your advice worked!

Didn't have to dig around with Google though. I saved the package as a VB file and then snooped...

"WIth the dims not set to 'changing' , have you tried processing them (incrementally) as a seperate activity to processing the cube (ie right click on dim and then process...

"Definitely don't need to have a changing set to ROLAP. If you check the BOL entry re: changing dimensions, it indicates that you only need to change some of...

Hmmm..., no they're not. I considered defining them as such but:

(1) From what I understood from the documentation, this only optimizes the dimensions for constant updates to the underlying...

"So if possible try incremental update of dimension and then process the cube and then check whether you can see the updated record."

I've tried it already and it doesn't work....

Currently, I have 1 cube and 6 shared dimensions. The fact table has at least 2 million rows. The smallest dimension table has 600 rows while...

Thanks for the second opinion.

The design document I'm looking at does not really specify what will be done with the OLAP system that...

Hi,

Thanks for the reply. I've solved the problem now, but not in the way that you suggested. Neither of the two service packs (2 or 3) for SQL...