Switch database BPC

[Former Member]

Dear All..

Please Help, I installed BPC with multi server, server A for BPC Application and server B for Database. And i installed server C with database BPC. I want switch database to server C. I switch the database to server C in Server Manager --> Options --> Server Options for field SQL Server name, OLAP Server name and Insight OLAP Server name. But this not work, the application still use database in server B. Please help for this problem.....

Best Regards,

Setiadi

[sorin_radulescu · Accepted solution]

SAP BPC doesn't install any component into database. It is just create and configure tables and databaseintoSQL server.

So for sure you don't have to install anything into database. Everything is done when you are doing the installation of application server.

Regards

Sorin Radulescu

[Former Member · Accepted solution]

Dear All

I try change the database, its can move. But some error when open BPC Administration, the error message :

A dimension information file be created. There may be a network or security issue.

Error Message: There is no member cache file on the System. You have to run member processing first.

Please help for this error...

[Former Member · Accepted solution]

Hi Dharma

Not sure why you are getting this error, but have you tried to do the following in order to resolve your error:

In the Admin Console -> Refresh Client-Side dimension files

Then Export Dimension - once that has completed

Process the dimensions using the "Process members from member sheet"

Hope this Helps

Kind Regards

Daniel

[Former Member · Accepted solution]

This may occur when the field "Value", which is located in the row "FileServer (DataPath)" of the tblServerInfo table, does not have the correct information defined.

To fix this issue:

Open the SQL Server Management Studio

Connect to BPC Database Server

Expand Databases

Expand AppServer Database

Open tblServerInfo

Add the correct path of BPC Data Folder

This is an example of the row in question that needs to be modified:

ServerType    ServerName       Field       Value
FileServer    FileServer1      DataPath    Here is the place that needs to modified

[Former Member · Accepted solution]

Dear All...

Thanks.. I can switch the database. I hope no problem in the future...

Dharma Setiadi