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 SAP BusinessObjects Planning and Consolidation (BPC) 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 the latest SQL service pack/updatesġ.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.Click Install ( installation will take around 20 minutes).Click Next > Click Next > Click Next > 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.
The posting describes the steps to Install SAP BusinessObjects Planning and Consolidation (BPC) 7.5.