Problems Consolidating OLAP Databases

[plaztik]

Hello all,

I am working on a project using MS OLAP.

Three phases of the project are already complete.

Unfortunately, each of these phases was placed into a separate Analysis Services database.

The connection strings and shared dimensions are the same for all 3 databases.

For performance and design reasons, I thought it would be a good idea to consolidate all these databases into one master database.

-------------------------------

CURRENT:
Phase 1 Database
> Phase 1 Cubes
> Time dimension
> Geography Dimension
> Part Dimension

Phase 2 Database
> Phase 2 Cubes
> Time dimension
> Geography Dimension
> Part Dimension

Phase 3 Database
> Phase 3 Cubes
> Time dimension
> Geography Dimension
> Part Dimension


DESIRED RESULT:
Consolidated Database
Phase 1, 2, 3 Cubes
> Time Dimension
> Geography Dimension
> Part Dimension

-------------------------------

I created a new database, and thought it would be easy to copy and paste all the cubes to it. I was wrong.

I am able to copy the Phase 1 cubes (along with all dimensions). However, I am unable to paste any cubes from Phase 2 or Phase 3.

The error that I receive is "Cannot paste cube [Phase 3] into database [Consolidated Database] because supporting dimension Geography already exists."

But, this dimension is EXACTLY the same in all Phases. All cubes from all phases need to use the same set of shared dimensions.

Does anyone know how to get around this without having to rebuild all the additional cubes? The amount of work required for rebuilding would be quite significant, and I am concerned about missing things in doing so.

Any help would be greatly appreciated.

Thanks!

 

[ram1975]

If i understood your problem correctly, it is related to partitions. As you are saying u already have three different databases. In the first phase database, create two more partitions and change the fact table location accordingly.

I hope this should solve your problem.