Posted on

BPC 7.5 MS Prerequisites

Though the install guide for BPC provides the prereqs, I find I have to bounce around in the doc to find them. Here they are as of 8/3/2011:

Pre-Requisites:

App Server: OS (pick one preferably x64):

  1. Windows Server 2008 R2 Standard or Enterprise Edition with or without Hyper-V
  2. Windows Server 2008 Standard or Enterprise Edition with or without Hyper-V
  3. Windows Server 2008 Data Center with or without Hyper-V
  4. Windows Server 2003 Standard or Enterprise Edition SP2
  5. Windows Server 2003 R2 Standard or Enterprise Edition SP2

Database Server: OS (pick one preferably x64):

  1. Windows Server 2008 R2 Standard or Enterprise Edition with or without Hyper-V
  2. Windows Server 2008 Standard or Enterprise Edition with or without Hyper-V
  3. Windows Server 2008 Data Center with or without Hyper-V
  4. Windows Server 2003 Standard or Enterprise Edition SP2
  5. Windows Server 2003 R2 Standard or Enterprise Edition SP2

Service Accounts:

  1. SQL Server
  2. BPC SysAdmin
  3. BPC Admin
  4. BPC User

NOTE: These are domain accounts.

Have available, but do not install:

Database (pick one):

  1. SQL Server 2008: SP2 with Cumulative Update 1 for SP2.
  2. SQL Server 2008 R2: Cumulative Update 5.
  3. SQL Server 2005: If you wish to use 2005 ask me for SP and CU

BPC:

  1. BPC 7.5 MS setup

Misc:

  1. SQL Server 2005 Backward Compatibility Components

From SAP Marketplace website (SAP Cryptographic Software) :

  1. AmyuniPDF.exe
  2. XceedZip.dll


Posted on

Re-installing BPC 7.5 MS

Some notes from re-installing BPC 7.5 MS.

  1. Backup AppSets
  2. Thru Server Manager, document existing settings
  3. Reboot the application server
  4. Rename the AppServer, ApShell and ApShellExtra databases
  5. Rename the AppServer, ApShell and ApShellExtra Data folders
  6. Uninstall BPC either thru Add and Remove Programs (Win Server 2003) or the new Win Server 2008 method
  7. Remove the BPC application folder (Not the data folder)
  8. Remove any remaining BPC COM+ objects
  9. Remove any remaining BPC, OutlookSoft and SAP registry entries
Posted on

SAP Central Management Console and Windows AD Authentication

When changing Domain Controllers for a UMS/CMS server you need to modify the krb5.ini file. In our case that file was located in C:WinNT. Simply adding another kdc line, saving the file and restarting TomCat updates the system.

AD.ourdomain.COM = {
kdc = NewDCName.AD.ourdomain.COM
kdc = OldDCName.AD.ourdomain.COM
default_domain = AD.ourdomain.COM
}

Prior to this update, I was receiving this error:

Account Information Not Recognized: Active Directory Authentication
failed to log you on. Please contact your system administrator to make
sure you are a member of a valid mapped group and try again. If you are
not a member of the default domain, enter your user name as
UserName@DNS_DomainName, and then try again. (FWM 00006)

Posted on

FWM 01003 null When Logging Into Central Management Console

When logging into the SAP Central Management Console used for managing security in UMS, I received the following error:

Server not found or server may be down (FWM 01003) null

Thanks to this post, it turns out that the CMS.exe process was not running. I could tell by looking in Task Manager. To start the process:

  1. Run Central Configuration Manager
  2. (Re)start Server Intelligence Agent
Posted on

Copying VM While Running

NOTE: I receive a checksum failure error during vm-import when following this method.

To copy a VM while it is still running:

  1. Create a snapshot
  2. Export as backup
  3. Import the backup

Here are the details:

Create a Snapshot

  1. ssh into XenServer
  2. run xe vm-snapshot vm=”VM Name” new-name-label=”Name the snapshot”
  3. when it completes write down the UUID returned

Export as Backup

  1. ssh into XenServer
  2. xe template-export template-uuid=”UUID from step 3 above” filename=”Name the .xva file”
  3. View progress in XenCenter

Import the Backup

  1. ssh into XenServer
  2. xe vm-import filename=”Name the .xva file to import” sr-uuid=”SR to restore it to”

Hints:

Use df -ha to view existing disks and available space
Use xe sr-list to find the sr-uuid needed in Import the Backup step 2.

Posted on

Viewing Data in a NW AppSet

Often I need to know where data is when testing after an upgrade or install. For the NW version do the following:

  1. Login to SAP GUI
  2. Start transaction RSA1
  3. If prompted, decide whether to view or not view the documentation
  4. In the Modeling pane, click InfoProvider
  5. In the large pane on the right, expand Business Planning and Consolidation
  6. Expand your AppSet
  7. Right click on your Application, then select Display Data
  8. If an information dialog appears about too many characteristics, click the green check

At this point a dialog appears with all the dimensions and their properties. So for example, the P_Activity dimension shows 4 rows:

  1. [ ] [ ] CALC[P_ACTIVITY]
  2. [ ] [x] CALC[P_ACTIVITY]
  3. [ ] [ ] P_ACTIVITY
  4. [ ] [x] P_ACTIVITY

Notice there are white check boxes and greyed out check boxes. The grey boxes that are checked indicate the ID for the member, the non checked contain the name. So check the white check box like this to get ID and Name:

  1. [ ] [ ] CALC[P_ACTIVITY]
  2. [ ] [x] CALC[P_ACTIVITY]
  3. [x] [ ] P_ACTIVITY
  4. [x] [x] P_ACTIVITY

Do this for every dimension you want to view with your results. Notice the SignedData row at the end, this is the actual value column. Then:

  1. Click the green check.
  2. Clicking the Fld Selectn for Output button
  3. Click the Select All button
  4. Click the Clock with a green check button
  5. You return to the previous screen
  6. Click the Clock with a green check button again
  7. Your data displays

Once I know where data is located I can run reports in the Excel client.

Posted on

BPC Server Version

For the official list of both MS and NW versions, see SAP Note 1366676

Some MS Versions

BPC 7.5

7.5.102 : SP01
7.5.103 : SP02
7.5.104 : SP03
7.5.105 : SP04
7.5.106 : SP05

BPC 7.0

7.0.114 : SP05
7.0.115 : SP06
7.0.116 : SP07


NetWeaver Version

To find the version of NetWeaver BPC is running on:

  1. Start SAPGUI
  2. On the menu bar click System > Status…
  3. In the SAP System data section:
    1. Component version will give you some information
    2. Click the magnifying glass button below that field to see details:
      1. SAP_BASIS indicates the version of NetWeaver. In the screen shot below
        1. Release 701 means version 7.0 EHP1
        2. Level 0005 means SP5
      2. CPMBPC indicates the version of BPC
        1. Release 750 means 7.5
        2. Level 0007 means SP7
System Status
Component Information

Thanks to Stuart Gunter’s post

Posted on

Clearing All Rows From All Tables

This couple of SQL statements will delete all the rows from all tables.

  1. It disables referential integrity
  2. DELETES or TRUNCATES each table
  3. Enables referential integrity
  4. Reseeds rows with identity

— disable referential integrity
EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’
GO

EXEC sp_MSForEachTable ‘
IF OBJECTPROPERTY(object_id(”?”), ”TableHasForeignRef”) = 1
DELETE FROM ?
else
TRUNCATE TABLE ?
‘
GO

— enable referential integrity again
EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’
GO

— This will reseed each table [don’t run this exec if you don’t want all your seeds to be reset]
EXEC sp_MSForEachTable ‘
IF OBJECTPROPERTY(object_id(”?”), ”TableHasIdentity”) = 1
DBCC CHECKIDENT (”?”, RESEED, 0)
‘
GO

Thanks to Mauro Cardarelli’s post