Deleting OLAP Cub DB's

[shahid_chowdhury]

We have created some OLAP Cube DB's as tests and want to delete these from PS
2007 Analysis Services. Wondering what Impact this will have on the system
and if this is advisable.

The resaon for deletion is we don't want to see these DB's when creating
news views and simplify managing the CUBES and reports.

Thanks in advance for anwers.

Shahid C.

 

[Paul Conroy]

If the databases are no longer being used, then you can delete them with no
impact.

--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[Marc Soester [MVP]]

Hi Shahid,
You are able to delete the project server OLAP cube db from Analysis
Services at any time. When you want to have the db back all you need to do is
rebuild the cube using Project Server and the OLAP cubes will appear again
hope this helps

 

[shahid_chowdhury]

Hello,

This was a DB permission issue on SQL backend. Account did not have
permission, now its working fine.

Thanks.