You more than likely have a non-unique key value in either your fact table or dimension table. Instead of joining unique value with another unique value you have an instance...

I have found a problem running packages within packages that loads AS cubes. I did all the ETL processes to load my star schema tables and after that it kicked...

Be sure to do a REFRESH on the cube database. One other note: If you have the cube processing in its own DTS package and you are executing this package...

Open Analysis Manager and right click on "Analysis Servers" folder. Select "About Analysis Services" and a window will appear.

8.00.194 means no Service Packs

8.00.382 means SP1 has been installed

8.00.532 means...

I was having some memory problems too but not exactly like the ones you are having. I had the SP2 installed and it resolved the problems. Hope this helps you...

Skip...

Dave,

Thanks for your suggestion. It was not the exact solution but it helped me find the problem. A row in the repository database that defined one of the cubes...

Paul,

In order for the new measures to show up in the fact table, you have to refresh the data source. In Analysis Manager, select the Data Source folder for the...

Paul,

You have to rebuild the dimension structure and then it will reflect the changes in the cube. Under Shared Dimensions right click on the dimension you have changed. Select Process...