Database Seperation

J

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
 
G

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.
 
J

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
 
G

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.
 
Top