SAP Business Planning and Consolidation 10, version for Microsoft
SAP EPM add-in for Microsoft® Excel
Web Services Enhancements (WSE) 3.0 for Microsoft® .NET
November 2013
EnglishEnglishOnly
SAP AG
Dietmar-Hopp-Allee 16
69190 Walldorf
Germany / Strategic Financial Planningwith SAP Business Planning and Consolidation for the Microsoft platform
(EA6)
Building Block Configuration Guide

SAP Best Practices Strategic Financial Planning on SAP BPC MS (EA6) Configuration Guide

Copyright

© 2013 SAP AG or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

National product specifications may vary.

These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Please see for additional trademark information and notices.

Revision / Change Date / Description
0 / Nov 2013 / Initial
1 / June 2014 / SAP Business Planning and Consolidation version for the Microsoft platform only

Icons

Icon / Meaning
/ Caution
/ Example
/ Note
/ Recommendation
/ Syntax

Typographic Conventions

Type Style / Description
Example text / Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths and options.
Cross-references to other documentation.
Example text / Emphasized words or phrases in body text, titles of graphics and tables.
EXAMPLE TEXT / Names of elements in the system. These include report names, program names, Transaction Codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE.
Example text / Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools.
EXAMPLE TEXT / Keys on the keyboard, for example, function keys (such as F2) or the ENTER key.
Example text / Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.
<Example text> / Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.

© SAP AGPage 1 of 11

SAP Best Practices Strategic Financial Planning on SAP BPC MS (EA6) Configuration Guide

Content

1.Purpose

1.1Audience

1.2Prerequisites

1.3Application set up

1.4Software Version Requirements

1.5Restoring the SAP Strategic Financial Planning rapid-deployment solution

1.6Copying the Environment

1.7Connecting to the New Environment

1.8Deleting Master and Transaction Data from the Copy

1.9Additional configuration steps

2.Glossary

3.Appendix

SAP Business Planning and Consolidation, version for the Microsoft platform

© SAP AGPage 1 of 11

SAP Best Practices Strategic Financial Planning on SAP BPC MS (EA6) Configuration Guide

Strategic Financial Planning with SAP Business Planning and Consolidation for Microsoft: Configuration Guide

1.Purpose

The purpose of this document is to validate the software installation for SAP Strategic Financial Planning rapid-deployment solution for Microsoftand to describe theimplementation of the custom objects required in therapid-deployment solution.

Install and validate all related SAP Business Content for the solutionin the Microsoft environment, before developing the objects defined in this document. This process includes all steps defined in the building block (EA6) Strategic Financial Planning with SAP Business Planning and Consolidationfor Microsoft Configuration Guide.

This guide provides a procedure to restore the SAP Strategic Financial Planning rapid-deployment solution for Microsoft Platform. It is comprised of the following sections:

  • Software Version Requirements
  • Restoration Requirements
  • Restoring SAP Strategic Financial Planning rapid-deployment solution
  • Copying the Application Set

This guide details the one-time steps to enable the SAP Strategic Financial Planning rapid-deployment solution.

1.1 Audience

This guide is intended for the technical consultants and personnelresponsible for the deployment of the SAP Strategic Financial Planning rapid-deployment solution. It is assumed that the personnel have been trained in SAP Business Planning and Consolidation 10.0 administration and configuration.

1.2Prerequisites

Perform the following prerequisites before installing and configuring the SAP Strategic Financial Planning rapid-deployment solution:

  • Before configuring this rapid-deployment solution, use a unique services offering or other means to ensure that the software listed in the previous table has been installed and is available.
  • Complete and validate the scoping questionnaire.
  • Confirm that the list of all other prerequisites has been validated.

1.3Application set up

Validate that SAP Business Planning and Consolidation 10.0 Version for Microsoft platform is Version 10.0 Service Pack 10.

Validate that the SAP EPM add-in can be accessed via Excel.

Validate that the SAP EPM add-in Patch level is SP14 (minimum).

Validate that the application can be accessed via Web front end.

For additional validation information, refer to the installation guide SAP Business Planning and Consolidation 10.0 version for Microsoft platform.

Execute Lite Optimization (application process) to ensure that packages are working properly.

1.4Software Version Requirements

For information about the software requirements for this rapid-deployment solution, see the Software Requirements guide for this solution.

1.5Restoring the SAP Strategic Financial Planning rapid-deployment solution

The application set is restored on the Microsoftplatform using its standard software backup/restore feature.

Requirements: Planning and Consolidation server is installed and user access to the Planning and Consolidation Server Manager is granted.

The following procedure is used to restore the SAP Strategic Financial Planning rapid-deployment solution:

  1. Extract files from the archive SFP_SHELL.zip, in a dedicated directory of the computer or on a network destination.
  2. When the extraction finishes, verify that the destination directory contains a file named SFP_SHELL,which is the name of the backup file.
  3. Open Server Manager (SAP BusinessObjects > Planning and Consolidation > Planning and Consolidation Server Manager)
  4. Choose Restore Environment from the Environment menu.
  5. Using the folder icon, navigate to the location of the backup file. After selecting the backup file in the Environment Folder, the locations for Webfolder, FileDB, andSQL Databaseare automatically populated.
  6. Choose Nextto proceed to screen labeled Step 2.
  7. Verify defaults and choose Next to proceed to screen labeled Step 3.
  8. Verify defaults and choose Next.
  9. Restart the system to restore the SFP_Shell environment. Do you want to continue? dialog box opens.
  10. Choose Yes to start the restoration process.
  11. Upon completion of the restore, a message appears indicating successful restoration.

1.6Copying the Environment

The SAP Strategic Financial Planning rapid-deployment solutionis delivered with an environment named SFP_SHELL. The shell environment contains all the Planning models, dimensions, reports, and input forms for this solution.

To begin using the SAP Strategic Financial Planning rapid-deployment solution, copy the SFP_SHELL environment.

Provide a name for the copy, suitable for your client. After completing the copy, delete the master data from the copy environment (refer to next step detailing this activity.) Master data and transaction data are now ready to be loaded.

Do not change the SFP_SHELL environment. Retain it as a future point of reference.

Use the following procedure to copy the SFP_SHELL environment:

  1. Logon to the SAP Business Planning and Consolidation Administration console and highlight SFP_Shell in the Navigation Pane.
  2. In the Action Pane (upper right corner),selectAdd a New Environment.
  3. Entera name and description for the new environment and verify SFP_Shell is selected under Which environment would you like to duplicate?
  4. Click the green arrow to proceed to Step 2. Unselect Database Records and select the green arrow to Add a New Environment.

Results: When the copy completes, the new environment is available in the Planning and Consolidation Administration console.

1.7Connecting to the New Environment

Verify connection to the new environment using the following steps:

  1. Open Excel and select the EPM tab.
  2. Select Log On. The EPM Logon dialog box displays.
  3. Select the additional options button to the right of the Connection field. The EPM Connection Manager dialog box is displayed.
  4. Select Create. The Create Connection dialog box is displayed.
  5. For the Connection Type, select Planning and Consolidation, version for the Microsoft platform.
  6. Enter a desired Connection name and the Server URL and select Connect.
  7. Populate the Environment field with the copied environment name and the Model field with SFP.
  8. Select the new environment and the model that to be uses for this connection. Select OK.

1.8Deleting Master and Transaction Data from the Copy

The environment as copied contains master data and sample transaction data. Some of that master data is deleted and some is retained, as described in this section. All of the transaction data is removed. After deletingthe sampledata, the application is ready for your client-specificdata to be loaded.

Remove Master Data

Use the following procedure to delete master data from the copied environment:

  1. Using the connection to new environment, open the SAP Business Planning and Consolidation, version for the Microsoft platform Web page.
  2. In the Launch box on the right side of the home screen, select Planning and Consolidation Administration. The Administration client is opened.
  3. Select Dimension Library. The dimensions list is displayed.
  4. Select BUS_UNITand Maintain Dimension Members. The Business Unit dimension members are displayed.
  5. Delete all members except ALL_BUS_UNIT.
  6. Select Save to Server.
  7. Select Process Dimension and select OK.
  8. Select TRADING_PARTNERand Maintain Dimension Members. The Trading Partner dimension members are displayed.
  9. Delete all members except ALL_TRADING_PARTNER and TP_NONE.
  10. Select Save to Server.
  11. Select Process Dimension and select OK.
  12. Perform the following steps only if the reporting currency is not EUR:
  13. To specify a reporting currency other than EUR, select CURRENCYand Maintain Dimension Members.
  14. Either replace EUR or enter a new reporting currency ID.

When adding a new reporting currency, but keeping EUR

  1. Enter Y on the Reporting column for the new currency.
  2. Remove the Reporting column Y designation for EUR.
  1. Select Save to Server.
  2. Select Process Dimension and select OK.

Remove Transaction Data

Use the following procedure to delete transaction data from the copied environment:

  1. Open Excel and select the EPM tab.
  2. Select Log On. The EPM Logon dialog box is displayed.
  3. Select a connection and select OK.
  4. Enter logon and password as required.
  5. Select Run Package from the Data Manager tab.
  6. From the Data Management folder, selectClear package and chooseRun.
  7. Select ACTUAL and PLAN from the P_VERSION dimension and then OK.
  8. Select Next three times and then select Finish.
  9. Repeat these steps to remove transaction data for each model.

1.9Additional configuration steps

Modify configuration for yourspecific requirements and add additional tasks as necessary (For example, configuring theTime dimension).

2.Glossary

Term /Abbreviation / Meaning/Comment
RDS / rapid-deployment solution
SAP Business Planning and Consolidation / SAP Business Planning and Consolidation, version for the Microsoft platform
EPM or EPM 10 / Enterprise Performance Management (EPM Version 10)
P&L or PL / Profit & Loss statement or Income Statement
BS / Balance Sheet
CF / Cash flow Statement
Actual or Actuals / Actual GL/ECC results of the Company in ECC
Plan or Forecast / Used interchangeably to refer to future performance results of the Company. There is neither distinction nor difference between a Plan and Forecast process in the RDS.
MD / Master data, or the metadata that shapes a cube
TD / Transaction data, or the information that fills up a cube
SAP Business Planning and Consolidation Administrator / Technical applicationsupport, in context of data integration as the role helps manage the master data and transaction data loads
Input Forms / Previous name of Input Templates in the application

3.Appendix

SAP Business Planning and Consolidation, version for the Microsoft platform

For more information about SAP Business Planning and Consolidation version for the Microsoft platform, see the SAP Help Portal

Topic / Guide/Tool / Quick Link
SAP Business Planning and Consolidation version for the Microsoft platform / SAP Help Portal /
SAP Business Planning and Consolidation version for the Microsoft platform Help page

© SAP AGPage 1 of 11