Install SAP BusinessObjects Planning and Consolidation (BPC) 7.5


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 >> OK

1.4        Navigate to C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer >> Edit rsreportserver.xml file >>  change set “SecureConnectionLevel” Value=”0″ instead of  2

1.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/updates

2.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 Logging and 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\Library

2.3        Service-Level Accounts

Service 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 Like BPC_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 be BPC_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+ components Everest Update, OSoftSystemConfig, K2Processing, and OsoftDataService 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

Advertisements

About Tarek

I have been working in IT for years and I thought it might be good to share my experience using real life scenarios.
This entry was posted in SAP BPC and tagged . Bookmark the permalink.

One Response to Install SAP BusinessObjects Planning and Consolidation (BPC) 7.5

  1. SAP BPC says:

    Really good piece of knowledge, I had come back to understand regarding your website from my friend Sumit, Hyderabad And it is very useful for who is looking for SAP BPC.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s