SAP EPM add-in for Microsoft® Excel
Web Services Enhancements (WSE) 3.0 for Microsoft® .NET
November 2013
EnglishEnglish Only
SAP AG
Dietmar-Hopp-Allee 16
69190 Walldorf
Germany / Strategic Financial Planning with 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 http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.
Revision / Change Date / Description0 / Nov 2013 / Initial
1 / June 2014 / SAP Business Planning and Consolidation version for the Microsoft platform only
Icons
/ 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 AG Page 11 of 11
SAP Best Practices Strategic Financial Planning on SAP BPC MS (EA6) Configuration Guide
Content
1. Purpose 6
1.1 Audience 6
1.2 Prerequisites 6
1.3 Application set up 6
1.4 Software Version Requirements 7
1.5 Restoring the SAP Strategic Financial Planning rapid-deployment solution 7
1.6 Copying the Environment 7
1.7 Connecting to the New Environment 8
1.8 Deleting Master and Transaction Data from the Copy 8
1.9 Additional configuration steps 9
2. Glossary 10
3. Appendix 11
SAP Business Planning and Consolidation, version for the Microsoft platform 11
© SAP AG Page 11 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 Microsoft and to describe the implementation of the custom objects required in the rapid-deployment solution.
Install and validate all related SAP Business Content for the solution in 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 Consolidation for 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 personnel responsible 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.2 Prerequisites
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.3 Application 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.4 Software Version Requirements
For information about the software requirements for this rapid-deployment solution, see the Software Requirements guide for this solution.
1.5 Restoring the SAP Strategic Financial Planning rapid-deployment solution
The application set is restored on the Microsoft platform 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, and SQL Database are automatically populated.
6. Choose Next to 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.6 Copying the Environment
The SAP Strategic Financial Planning rapid-deployment solution is 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), select Add a New Environment.
3. Enter a 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.7 Connecting 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.8 Deleting 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 deleting the sample data, the application is ready for your client-specific data 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_UNIT and 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_PARTNER and 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 CURRENCY and Maintain Dimension Members.
14. Either replace EUR or enter a new reporting currency ID.
When adding a new reporting currency, but keeping EUR
a. Enter Y on the Reporting column for the new currency.
b. Remove the Reporting column Y designation for EUR.
15. Select Save to Server.
16. 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, select Clear package and choose Run.
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.9 Additional configuration steps
Modify configuration for your specific requirements and add additional tasks as necessary (For example, configuring the Time dimension).
2. Glossary
Term /Abbreviation / Meaning/CommentRDS / 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 application support, 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 / http://help.sap.com/bopacms100
SAP Business Planning and Consolidation version for the Microsoft platform Help page
© SAP AG Page 11 of 11