Tuesday, July 29, 2008

OLAP Database Created Outside of Project Server

Failed to build the OLAP Cubes. Error: Analysis Services Session Failed with the following Error: Cannot Overwrite an OLAP Database Created Outside of Project Server or by Another Project Server Site


Issue: Analysis Database for OLAP got corrupted
Resolution:
1) Login to Analysis Services Machine as Administrator
2) Start All Programs Microsoft SQL Server 2005 SQL Server Management Studio
3) On Server Type Select Analysis Services Enter Correct Server Name Click Connect
4) Expand Analysis Server Databases "DBName" (Cube Name)
5) Right Click and Delete
6) Re-build the OLAP cube via Project Web Access

1 comment:

Gilberto Verástegui said...

Not an expert in PS, i'm just trying to fix it.If i delete this DB will i lose everything?