BPC Dimension Members and Office Version

To specify which version of Excel is used when working with Dimension members look at the tblDefaults table with the row containing KeyID MEMBERSHEET_VERSION.

You can change this to 2007 or 2003

Make sure to install MS Data Connectivity Components on the application server as well. See Note: 1289927 and this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8
C28-4598-9B72-EF94E038C891&displaylang=en

SAP Cryptographic Software (XceedZip.dll, Anti-Cross Site Scripting and AmyUniPDF)

To download the XceedZip.dll, Anti-Cross Site Scripting and AmyUniPDF files for BPC go to:

SAP Service Marketplace > SAP Support Portal > Software Downloads > Software Download Center > Installations and Upgrades > Browse our Download Catalog

On the page displayed you will find a link to SAP Cryptographic Software.

Updating BPC Service Pack Work Instruction

Document Server Manager settings

Make a copy of BPC web.config
Make a copy of server level .NET Framework v.2.0 machine.config and web.config

Verify the Office and admin clients can connect

• Run a report
• Manage dimensions

Restart all servers before applying any updates to ensure nothing is locked or open.

Make backup of AppServer DB

Run Startup.exe

Some BPC NW Commands

In SAP GUI using se80 will show tables.

These table prefixes mean the following:

• uj - BPC related
• uja - AppSet
• ujj - Journal
• uje - Security

rsa1 - Data Warehousing Workbench: Modeling (view AppSet, dimension attributes and raw data here)
su01 - Create Users
snote - Run Note Assistant

SAP Supported SQL and Windows Server Versions for BPC

Windows Server

BPC 7.5 SP04 or later:

Windows Server 2008 R2 Standard or Enterprise Edition with or without Hyper-V
Windows Server 2008 Standard or Enterprise Edition with or without Hyper-V, or
Windows Server 2008 Data Center with or without Hyper-V
Windows Server 2003 Standard or Enterprise Edition SP2
Windows Server 2003 Standard configured on the SQL database or OLAP server components only
Windows Server 2003 R2 Standard or Enterprise Edition SP2

SQL Server

BPC 7.0 and 7.5 support:

SQL 2008: SP2 with Cumulative Update 1 for SP2.
SQL 2008 R2: Cumulative Update 5.

"The ABAP server specified in the server configurtion file is not reachable

Problem

When trying to log into the launch page on BPC NW 7.5 I receive either a timeout error or this:

• The ABAP server specified in the server configurtion file is not reachable

Investigating further I find I cannot login to SAP Login

When trying to login to SAP Logon 710 I get:

partner '192.168.1.40:sapdp00' not reached.
WSAECONNREFUSED: Connection refused

SAP Support suggested:

Connection refused errors are normally triggered in two situations:

- There is a firewall in the way of the connection rejecting the
communication
- The service is not running on the server

It seems that the problem here is that you are not being able to reach
the server. If you try to do a telnet test like:

telnet 192.168.1.40 3200

Are you able to open the port or you receive an error too?

I in fact cannot telnet to port 3200

Solution

• Open SAP Management Console
• SAP Systems > SPC > dublin 0 (our ABAP / NW server)
• Right click on dublin 0
• Click Start...

SP 2010: Create New Web Application and Site Collection

Create New Web Application

IIS Web Site

1. Description: MOSS Web App - 80 (Consider TurtlePoint Web App - 80)
   
2. Port: 80
   

Application Pool

1. App Pool Name: MOSS Web App - 80 (Consider TurtlePoint Web App - 80)
   
2. Account: spAppPool
   

Database Name and Authentication

1. DB Name: MOSS_WebApp_Content

MOSS_WebApp_Content DB created
MOSS Web App Web - 80 Site created
MOSS Web App - 80 App Pool created


Create New Site Collection

Title and Description

1. Title: Turtle Point

Template Selection

1. Collaboration > Blank Site
2. Activate these Site Collection Features
   
1. SharePoint Server Enterprise Site Collection
   
2. SharePoint Server Publishing Infrastructure
3. SharePoint Server Standard Site Collection
4. Publishing Approval Workflow if desired
3. Activate these Site Features
   
1. SharePoint Server Enterprise Site
2. SharePoint Server Publishing
3. SharePoint Server Standard Site
4. Team Collaboration Lists
   

Primary Site Collection Administrator

1. TURTLELLC\Administrator

No new database, web site or app pool created