Rebuilding the OLAP cube removes my new dimension (SQLServer2000)

W

Wouter

I created a new dimension in the OLAP cube like this:

In Analysis Manager:
-add new dimension to MSP_ASSN_FACT
-add new available dimension to MSP_PORTFOLIO ANALYZER
-starting to process the database immediately after this actions gives a
'Cannot save Object inside a Decision Support Objects (DSO) Transaction' error
-restarting Analysis Manager makes it possible to process the database

After this, the new dimension can be used in the views.

To my disappointment, every time the cube is being rebuilt, the new
dimension disappears.

Where did I go wrong?
 
Top