Install SAP BusinessObjects Planning and Consolidation 7.5

[Former Member]

Purpose                                                                                    

The posting describes the steps to Install SAP BusinessObjects Planning and Consolidation (BPC) 7.5 .  The installation will be done in two servers, a database server and SAP BPC server which will have application server/web server component for SAP BPC.

I have used SAP BPC documentation however it took me sometime to complete the installation successfully so I wrote the instructions below based in my experience

1. Build a Database Server

1.1        Install windows 2008 R2 64 bit and install the latest service pack/updates

1.2        Install SQL 2008 R2 Enterprise edition 64bit for production environment  or developer edition for test environment

• Create Active directory account will be used to run SQL server Services (Company\dbuser_xxxx) where xxxx are the suffix of the server name for example Company-devdb3 should use dbuser_devdb3
• Grant the dbuser_xxxx right to lock pages in memory as below 
• Start SQL 2008 R2 setup program >> Installation >> New installation or add to an existing installation 
• Setup support Rules  from will showup so Click OK
• Enter Product key then Click Next
• Check I accept License Terms >> Click Next
• Setup support files form will showup >> Click Install
• Click Next>> Select Server feature installation then Click Next
• Select the following features:

1. Database Engine services
2. Full-Text Search
3. Analysis services
4. Reporting Services
5. Business Intelligence development studio
6. Client Tools connectivity
7. Integration services
8. Client tool backwards compatibility
9. Management Tool – Basic

• Click Next >> Click Next
• Specify the Instance ID >> Click Next >> Click Next
• Click Use the same account for all SQL server services and enter AD user/password created earlier
• Set SQL Server Agent Startup type to Automatic
• Click Next
• In Database engine configuration specify SQL server administrator >> Click Add and select the AD group will administer database engine >> Select Mixed mode and Sa password >> Click Next
• In Analysis service configuration specify users have administrative permission  Analysis service >> Click Add and select the AD group will administer Analysis service >> Click Next
• Click Next >> Click Next >>  Click Next >> Click Next
• Click Install ( installation will take around 20 minutes)
• Install the latest SQL service pack/updates

1.3        Enable TCP/IP >> Open SQL Server Configuration Manager >>SQL Network Configuration >> Protocol for Microsoft SQL Server >>  TCP/IP >> Set Enable to Yes >> OK1.4        Navigate to C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer >> Editrsreportserver.xml file >>  change set “SecureConnectionLevel” Value=”0″ instead of  21.5        Grant the SQL services AD account that run Analysis service sysadmin role in the database engine, this really important because if you don’t do that the installation of SAP BPC will fail. During the installation of SAP BPC it create database called appshell as  part of the sample application so  Analysis service will connect to appshell database to create the cube so if  SQL services AD account (Company\dbuser_xxx) doesn’t have access to appshell  database the process will fail and you will end up with having incomplete appshell

2. Install SAP BusinessObjects Planning and Consolidation (BPC)

SAP BPC application/web server are in the same server  2.1        Install windows 2008 R2 64 bit and install the latest service pack/updates2.2        Prerequisites:

• Install SQL 2008 R2 Shared features:

Start SQL 2008 R2 Setup program and install the following features:

1.       Business Intelligence development studio
2.       Client Tools connectivity
3.       Integration services
4.       Client tool backwards compatibility
5.       Management Tool – Basic

You must install these SQL features otherwise you will get odd error message at the end of installing SAP BPC

• Install MSXML 4.0 SP2 or later
• Install ADOMD.NET 9.0
• Install Microsoft Report Viewer 2008 SP1
• Install Microsoft SQL Server 2005 backward compatibility
• Install .Net FrameWork 3.5 and IIS:

In Windows 2008 R2 Open Server manager >> Roles >> Add roles >> Click Next >> Select Application Server >> Click Add required features >> Click Next >> Click Next >> Select Web Server (IIS) supports >> Click Add required features >> Click Next >> Click Next >> Check Custom Loggingand ODBC Logging, ASP Then Check IIS 6 Metabase compatibility >> Click Next >> Click Install

• Install the Anti-Cross Site Scripting Library:

Download the Anti-Cross Site Scripting Library file AntiXSSLibrary.DLL from the SAP Cryptographic Software download area Save the extracted file (AntiXSSLibrary.DLL) locally to c:\BPC_MS\Library2.3        Service-Level AccountsService accounts are Windows domain IDs with access to all Planning and Consolidation servers with varying levels of privileges:

• Create System Admin ID AD account something LikeBPC_sysadmin_svcTst for Development environment, add it local administrators group in the BPC server(application/Web server), grant it sysadmin role to MS SQL Server,  add to administrator role on analysis services(OLAP),  grant it admin access to reporting services home folder(Browser, Content Manager, My Reports, OutlookSoft Report Viewer, Publisher, Report Builder)
• Create Admin ID AD account something Like BPC_dmin_Tst for Development environment, add it local Power users group in the BPC server(application/Web server), grant it public role to MS SQL Server,
• Create User ID something Like BPC_user_Tst for Development environment, grant it public role to MS SQL Server.

2.4        Install SAP BPC

• Log on with a domain user ID (System Admin ID created in 2.2.3) to the server where you are installing SAP BPC server.
• Download BPC Setup to local disk
• Launch startup from BPC setup folder
• Click Install Server on SQL 2008
• Click Next >> accept the license agreement then Click Next
• Select Custom Multi-server >> Set SLD in System ID >> Click Next
• Select Microsoft Windows in authentication method>> Click Next
• Set Services accounts >> Click Next

•   Enter the required server info, set SQL Server name, OLAP, Insight OLAP and reporting services to the database server name prepared in step 2.1. set Local data path to C:\BPC_MS\Data >> Click Next >>
• Enter the path and file name for anti-cross site scripting Library, set it to C:\BPC_MS\Library\AntiXSSLibrary.dll >> Click Next
• Set Program Path to  C:\BPC_MS >> Click Next
• The installer will start install SAP BPC and will take around 20 minutes

2.5       Required Post-Installation Steps

• Config XMLA to use dedicated IIS application with 32 bit enabled

1. Add application Pool>> set the name to BPC_XMLA>> Set Enable 32-bit application to True
2. Navigate to Sites >> Default Web site >> OSoft >> Advanced Settings >> set application pool to BPC_APP and Click OK
3. Navigate to Sites >> Default Web site >> XMLA >> Advanced Settings >> set application pool to BPC_XMLA and Click OK

• Removing Default Access to the BPC Management Console(http://servername/ManagementConsole), by default every user in Active directory have access so we want limit access BPC administer

1. Create Local group in BPC server, the name of the group name should beBPC_ManagementConsole
2. Add AD users or group you want grant access to the BPC management console to BPC_ManagementConsole local group in the server
3. Remove inherited permissions from managementConsole folder , Open IIS manager >> Default Website >> ManagementConsole >> Right Click >> Edit Permissions>> Security >> Advanced >> Change Permission >> uncheck Include inheritable permissions from this object’s parent>> Click Add >> Click OK >> Click OK >> Click OK
4. Grant Management Console IIS Identity pool access to ManagementConsole Folder. Open IIS manager >> Default Website >> ManagementConsole >> Right Click >> Edit Permissions>> Security >> Edit>> Add “IIS AppPool\BPC_ManagementAP” >> Click OK >> Click OK >> Click OK  If you don’t grant the Management console pool you get error message when you access it throw  http://BPCServerName/ManagementConsole
5. Remove the group shouldn’t have access management Console, Open IIS manager >> Default Website >> ManagementConsole >> Right Click >> Edit Permissions>> Security >> Edit >> Select Users >>Click remove >> Click Add>> add BPC_ManagementConsole local group >> Click OK >> Click >> Click OK

• Setting Up ODBC Logging in IIS for the Default Web Site

1. Create a Microsoft SQL Server user to access AppServer as the default database. Grant it db_Owner database role on AppServer database.
2. Create ODBC datasource(BPC_ManagementDSN system DSN)  Enter the Microsoft SQL Server user information
3. Enable the default website to use ODBCLogging by running Command Prompt as administrator:

C:\Windows\system32>cd  C:\windows\system32\inetsrv
appcmd set config -section:ODBCLogging -datasource:BPC_ManagementDSN -tableName:BPCLog -username:BPC_ConsoleUsr -password:Test321
Applied configuration changes to section “system.webServer/odbcLogging” for “MAC
HINE/WEBROOT/APPHOST” at configuration commit path “MACHINE/WEBROOT/APPHOST”
C:\Windows\System32\inetsrv> appcmd set sites “Default Web Site” -logFile.logFormat:Custom -logFile.customLogPluginClsid:{FF16065B-DE82-11CF-BC0A-00AA006111E0}
SITE object “Default Web Site” changed
C:\Windows\System32\inetsrv>

• Set COM+ Object Application Pooling Pool Size
  

  Set the application pooling pool size for the COM+ componentsEverest Update, OSoftSystemConfig, K2Processing, andOsoftDataService as below:
  Choose Start Administrative Tools Component Services COM+ applications, Right-click the application, Choose Properties, then on the Pooling & Recycling tab, change the application pool size to 5

• Setting Memory Recycling in the IIS Application Pool

To run large requests, you configure Internet Information Services (IIS) to restart a worker process in an application pool so that it is recycled after using a set amount of memory. To configure a worker process to be recycled, take the following steps:

1. Start Internet Information Services (IIS) Manager on the Application server.
2. Expand the local computer, and expand Application pools.
3. Right-click the application pool that contains the Osoft virtual directory (BPC_APP), then select advanced settings.
4. From the Recycling, Virtual memory limit (in KB), enter 1843200 (the maximum amount), and then select OK.

• Set 3GB Support for Memory on the COM+ Object

1. Open Component Services on the application server.
2. Choose the Everest Update component in COM+ Applications tree.
3. Open the Properties menu using the right-click menu.
4. Open the Advanced tab.
5. Select the Enable 3GB support option, then click OK.

Changing this setting is a potential solution if you receive an Out of memory exception error while running logic.

3. Install SAP BPC Language Package

3.1        Download BPC Language Pack from http://service.sap.com/swdc

3.2        Navigate to BPC_LanguagePack on the BPC server, click on “Setup.exe” to start the installation >> Click Next>> accept the license agreement and click on Next >> Click Next>> The installation starts >> The installation is finished.