Database Seperation

[Jerry Yasir]

Hi

I have a little query.
1. Can i seperate Project Server and OLAP cube Databases. If Yes then
how and What are the settings.
2. How can i clean the existing OLAP cube Database inside Project
Server Database.

Regards,
Jerry

 

[Gaurav Wason]

Jerry,

Are you trying to seperate MSP_Cube tables from project server database.
Then you cannot seperate them. But you can migrate OLAP Repository to SQL DB
from Access. Let me know.

 

[Jerry Yasir]

Gaurav

Yes i am probably thinking that i can seperate the MSCUBE tables from
my Project Server database. I have once seen a OLAP Cube database in
my SQL Server but i dont remember how. But any way are you sure that
we cant not create a seperate database for OLAP Cube?

Regards

Jerry
MCP-PS

 

[Gaurav Wason]

Yes I am sure you cannot seperate OLAP Cube tables As far as I know these
table are used to build the olap cube not to run it. You can have your
analysis server running on a different machine.

Let me know if this answer's your question.

 

[Jerry Yasir]

Thanks Gaurav

My query was answered!

Regards

Jerry
MCP-MSP