BPC Archives - Turtle Works

September 22, 2017

Installing BPC 10 NW Support Packages

Before beginning, document the current install by making screen shots of the Server Manager screens into WordPad.

For the ABAP SP retrieve the .SAR file from the SAP Marketplace

NOTE: ABAP BPC Support Packages are NOT cumulative, so download all the SPs between your current version and the latest. Continue reading “Installing BPC 10 NW Support Packages”

April 3, 2014

Download Basket SAP Approval

To get items manually approved by SAP, use the XX-SER-SAPSMP-SDM component or application when submitting a support message.

March 28, 2014

BPC MS Software Support Matrix

See SAP Note 1678822 for what versions of IE, Office, Windows Server, Windows Desktop, IIS, SQL Server, Citrix and .NET are supported.

November 25, 2013September 22, 2017

Recover Existing BPC MS AppSets

I recently built a new BPC application/web server. The existing App Sets were large; in the 2 billion rows category. So doing a backup and restore would be time consuming. The backup/restore was also unnecessary because the OSoft share was not on the app server and I wasn’t bringing up a new database server. Continue reading “Recover Existing BPC MS AppSets”

June 25, 2013

NW Security for BPC Users

When using NetWeaver security (not AD or CMS) for BPC, the user must have these roles set using the SU01 transaction in order to access BPC:

/POA/BUI_FLEX_CLIENT
/POA/BUI_UM_USER
/POA/CLM_BPC_USER
SAP_BPC_BTCH_JOB
SAP_BPC_CLM_EXPORT
SAP_BPC_CLM_IMPORT
SAP_BPC_SYSADMIN

February 8, 2013

BPC Optimization Well Defined

Here is an SAP Note and an Appendix that both help define optimization and the Fact tables:

1621911 – BPC basic steps of Lite & Incremental & Full Optimization for Microsoft and Netweaver
Appendix B: FACT, FAC2, and WB Tables

August 22, 2012

Setting Up Network Load Balancing for BPC

These are some loose notes from setting up load balancing in a BPC 7.5 MS environment.

Change Virtual Server Name to the load balancing appliance on all application/web servers
Set COM+ Object Application Pooling Pool Size to 5 for Everest Update, OSoftSystemConfig, K2Processing and OSoftDataService
1. Component Services > COM+ Applications
2. Right click the application
3. Properties > Pooling & Recycling
4. Set pool size to 5
On each app server, edit the hosts file and add the virtual DNS name with the loopback address. This way when the server resolves the virtual name as part as internal processing, it resolves to itself and not another node.
Disable the loop-back adaptor. That is done in the registry. There is a MS KB article that describes the steps.
Stickiness is necessary for the admin client.
Change required to the web.config file of the Osoft website on each machine in order to ensure that the encryption keys are all the same.
Change web.config file for Management Console
Restart SendGovernor
Modify hosts file, make entry for physical app server name on each app server

July 23, 2012

Network Load Balancing and Reporting Services

Recently doing a BPC install in a Network Load Balanced (NLB) environment and ran into an error when testing the Reporting Services on the second application server. When clicking on the Report Manager URL I would receive the error:

The report server installation is not initialized

It turns out I needed to go back to the first server and run Reporting Services Configuration Manager and select Scale Out Deployment, then join server two.

May 17, 2012

EPM Add-in for BPC 10 (The BPC Office Client)

Here is some interesting info about the Office Client for BPC 10.0.

It turns out SBOP EPM Add-in Big Vol 10.0 is the 64 bit version of the client which uses .NET 4.0) This should only work with NW, because MS doesn’t support the 64 bit version of MS Office.

SBOP EPM Excel Client 10.0 is the 32 bit version.

May 4, 2012

Category: BPC