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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Customize OLAP cubes 1
Add new dimensions to (timesheet) OLAP cube? 1
Cube dimension rebuild error / failing 0
Enterprise Custom Project Field as an OLAP Dimension PS 2007 3
OLAP Error out of the blue 0
Adding a week dimension 1
OLAP Cube build error 6
Resource Capacity in MSP_Portfolio_Analyzer cube 4

Top