VERSION Category Standard SAP Business Planning and Consolidation dimension. Contains the types of data you are going to track, for example, actual, plan and target. Members are set up to store plan versions, for example, PLANV1 and PLANV2. COST_CENTER User defined Custom SAP Business Planning and Consolidation dimension in the Planning solution. The COST_CENTER dimension contains Cost Center master data populated from SAP BW InfoObject 0COSTCENTER. TRADING_PARTNER Intercompany Standard SAP Business Planning and Consolidation dimension. Contains the intercompany codes for the entities. TIME Time Standard SAP Business Planning and Consolidation dimension. The Time dimension contains the time periods for which data is stored. FUNCTIONAL_AREA User defined Custom SAP Business Planning and Consolidation dimension in the Planning solution. The FUNCTIONAL_AREA dimension contains Functional Area master data populated from SAP BW InfoObject 0FUNC_AREA. PROFIT_CENTER User defined Custom SAP Business Planning and Consolidation dimension in the Planning solution. The PROFIT_CENTER dimension contains Profit Center master data populated from SAP BW InfoObject 0PROFITCENTER. INPUTCURRENCY Currency Standard SAP Business Planning and Consolidation dimension. Contains the currencies in which a company does business. CURRENCY Currency Standard SAP Business Planning and Consolidation dimension. Contains the currencies used in company reports. R_ACCOUNT Account Standard SAP Business Planning and Consolidation dimension. Contains the method with which accounts are handled in the Rates model during currency translation with valid entries including AVG and CLO. R_ENTITY Entity Standard SAP Business Planning and Consolidation dimension. Contains a generic Global member per standard SAP Business Planning and Consolidation setup.
PROFIT_CENTER Load TRADING_PARTNER Load Transactional DELTA BW Load Transactional FULL BW Load 2.3 Confirm P_ACCOUNT Master Data runs successfully Select Data Manager → Run Package →Run Package Link→40 P_ACCOUNT Load →Run→Next→(Run) Finish. Select OK (to continue)→View Status 40 P_ACCOUNT Load Look for Status = Succeed. If OK, then close window. Under View Status, browse detail status windows to see if any known errors or issues occurred. 2.4 Connect to SAP BPC Web Administration Logon to SAP BPC Web, for example: http://<server:Port>/sap/epm/bpc/web <server.Port> are exchanged for your values Web site should allow access 2.5 Confirm changes to dimension were updated by load process Open Planning and Consolidation Administration. Select Dimensions. Select P_ACCOUNT. You are in edit mode for the P_ACCOUNT dimension. 2.6 Validate dimension update Validate the accounts designated in the ROW_SOURCE dimension property = BW Update the PARENTH1 hierarchy property as needed. View List in Hierarchy mode to check assignments. 2.7 Save dimension Save and Process to process the dimension. Select No when asked Do you want to take the system offline? Process completes without errors 2.8 Close SAP BPC Web Choose Close to exit the dimension edit process Dimension closes.
Functional Area Master Data Load Procedure Test Step # Test Step Name Instruction User Entries: Field Name: Value Expected Result Pass / Fail / Comment 6.1 Connect to Planning model Open EPM add-in and connect to the Planning model. EPM 10 connects to <Customer> environment and Planning model. 6.2 Load the SAP BW Functional Area master data Select Data Manager → Run Package → Run Package Link→ 30 FUNCTIONAL_AREA load → Run →Next → (Run) Finish. Select OK (to continue)→View Status . 30 FUNCTIONAL_AREA load Ensure that Status = Succeed. If OK, then close window. Under View Status, browse detail status windows to see if any known errors or issues occurred 6.3 Connect to SAP BPC Web Administration Logon to SAP BPC Web, for example: http://<server:Port>/sap/bpc/web <server.Port> are exchanged for your values Web site should allow access 6.4 Confirm changes to dimension were updated by data load process Open Planning and Consolidation Administration. Select Dimensions. Select FUNCTIONAL AREA. You are now in edit mode for FUNCTIONAL AREA dimension. 6.5 Validate dimension update Validate the functional area ids and descriptions imported from BW as designated in the ROW_SOURCE dimension property = BW Update the PARENTH1 hierarchy property as needed. Example: Assign ALL_FUNCTIONAL_AREA in the PARENTH1 column for base level members View List in Hierarchy mode to check assignments. 6.6 Save dimension Save and Process to process the dimension. Select No when asked Do you want to take the system offline? Process completes without errors 6.7 Close SAP BPC Web Choose Close to exit the dimension edit process Dimension closes.
Full Transaction Data Load from SAP G/L Procedure Test Step # Test Step Name Instruction User Entries: Field Name: Value Expected Result Pass / Fail / Comment 8.1 Connect to Planning model Open EPM add-in and connect to the Planning model. EPM 10 connects to <Customer> environment and Planning model. 8.2 Clear existing SAP BPC data Prepare to load new Actual data from the SAP BW source by clearing out existing data from SAP BPC by using the standard SAP BPC Clear package function. Select EPM→ Data Manager →Run Package → Data Management → Clear Clear Period YYYY.MM Parameters: Version = Actual Time = <Period> All other dimension selections should be <all> Ensure that Status = Succeed. If OK, then close window. Under View Status, browse detail status windows to see if any known errors or issues occurred 8.3 Confirm that the data Clear is complete Validate results using the Trend report. Keep the same high-level Context dimensionality set previously Select Refresh in the EPM menu. Validate YYYY.MM Net Income WEBEXCEL\REPORTLIBRARY\10 Trend.XLTX. Report refreshes successfully and YYYY.MM Net Income = 8.4a Edit and revise Package Link and load data (if using SAP ERP source) Select Data Manager → Run Package → Run Package Link→70 Transactional FULL BW Data Load→ Run → Select the Package Listed→Set Prompt→… →OK→Next Set Transformation file…→Next→Next→Next→Finish (leave default values on each Next) →View Status 70 Transactional FULL BW Data Load InfoProvider: /PKG/FP_C01 Dimension/Field List: ALL Transformation Files: BW_PKG_FP_C01_TFORM.XLS; BW_PKG_FP_C01_CONV.XLS Ensure that Status = Succeed. If OK, then close window Under View Status, browse detail status windows to see if any known errors or issues occurred
8.4b Edit and revise Package Link and load data (if using SAP S/4HANA CDS view source) Select Data Manager → Run Package → Run Package Link→90 Transactional FULL BW Data Load → Run → Select the Package Listed→Set Prompt→… →OK→Next Set Transformation file…→Next→Next→Next→Finish (leave default values on each Next) →View Status 90 Transactional FULL BW Data Load InfoProvider: /PIM/FP_V01 Dimension/Field List: ALL Transformation Files: BW_PIM_FP_V01 TFORM.XLS; BW_PIM_FP_V01_CONV.XLS Ensure that Status = Succeed. If OK, then close window Under View Status, browse detail status windows to see if any known errors or issues occurred 8.4c Edit and revise Package Link and load data (if using SAP S/4HANA source) Select Data Manager → Run Package → Run Package Link→100 Transactional FULL BW Data Load S/4HANA Cloud→ Run → Select the Package Listed→Set Prompt→… →OK→Next Set Transformation file…→Next→Next→Next→Finish (leave default values on each Next) →View Status 100 Transactional FULL BW Data Load S/4HANA Cloud InfoProvider: /PIM/FP_C02 Dimension/Field List: ALL Transformation Files: BW_PIM_FP_C02 TFORM.XLS; BW_PIM_FP_C02_CONV.XLS Ensure that Status = Succeed. If OK, then close window Under View Status, browse detail status windows to see if any known errors or issues occurred 8.5 Confirm that the data load was complete Validate results using the Trend report. Keep the same high-level Context dimensionality set previously Select Refresh in the EPM menu. Review YYYY.MM Net Income \10 Trend Report Report refreshes successfully and YYYY.MM Net Income =
Cost Center Input Form Procedure Test Step # Test Step Name Instruction User Entries: Field Name: Value Expected Result Pass / Fail / Comment 11.1 Connect to Planning model Open EPM add-in and connect to the Planning model. EPM 10 connects to <Customer> environment and Planning model. 11.2 Open input form Choose EPM → Open → Open Server Input Form Folder → Company folder → WEBEXCEL\SCHEDULELIBRARY\10 Cost Center 10 Cost Center.XLTX Input form opens without error. 11.3 Open input form for Plan data submission Choose EPM → Open → Open Server Input Form Folder → Company folder → WEBEXCEL\SCHEDULELIBRARY\10 Cost Center.xltx 10 Cost Center.XLTX Input form opens without error. 11.4 Select Cost Center parent, P_ACCOUNT parent, and VERSION by double-clicking the Excel selectors in the input template Choose OK to close dialogue Choose Refresh button P_ACCOUNT = Cost Center = Version = Plan Input form refreshes without error. 11.5 Confirm protection of Actual data On the first row of input schedule, enter data in TIME periods marked Actual (Jan/Sep2013) Choose Save Data and Refresh No data should be updated 11.6 Submit planning data & confirm in another report Choose EPM → Open → Open Server Input Form Folder → Company folder → WEBEXCEL\SCHEDULELIBRARY\10 Cost Center.xltx 10 Cost Center.XLTX Input form opens without error. 11.7 Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 10 TREND.XLTX Report opens without error.
11.8 Select a single Cost Center and P_ACCOUNT by double-clicking the Excel selectors in the input template Choose OK to close dialogue Choose Refresh button P_ACCOUNT = Cost Center = Version = Plan Input form refreshes without error. 11.9 Save Plan data On the second row of input schedule, enter values into each month of the 2013 planning horizon. Choose Save Data and Refresh Oct 2013 = 10 Nov 2013 = 12 Dec 2013 = 14 Jan 2014 = 16 Feb 2014 = 18 Mar 2014 = 20 Apr 2014 = 22 May 2014 = 24 Jun 2014 = 26 Jul 2014 = 28 Aug 2014 = 30 Sep2014 = 32 Oct 2014 = 34 Nov 2014 = 36 Dec 2014 = 38 The data is saved without error. Based on V_FLAG property values in the TIME dimension, the template should accept input in the single row for time periods Oct 2013 through Dec 2014. 11.10 Use Trend report to confirm Plan data submission Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 10 TREND.XLTX Report opens without error. 11.11 Set the Context and refresh report P_ACCOUNT = Cost Center = Company Code = Version = Plan Currency = LC Report refreshes without error 11.12 Confirm report data Verify results using a Trend report Data in the Trend report should match
matches submitted Plan data Reconcile reported values in Trend report to the input values in the Cost Center input schedule the data in the Cost Center input schedule for each month. 11.13 Close report and input form Report and input form close without error. Profit Center Input Form Procedure Test Step # Test Step Name Instruction User Entries: Field Name: Value Expected Result Pass / Fail / Comment 12.1 Connect to Planning model Open EPM add-in and connect to the Planning model. EPM 10 connects to <Customer> environment and Planning model. 12.2 Open input form Choose EPM → Open → Open Server Input Form Folder → Company folder → WEBEXCEL\SCHEDULELIBRARY\20 Profit Center.xltx 20 Profit Center.XLTX Input form opens without error. 12.3 Change Profit Center parent Select Profit Center parent using the Context bar/pane. Profit Center = Input form updates and refreshes without error. 12.4 Confirm protection of Actual data On the first row of input schedule, enter data in TIME periods marked Actual (Jan/Sep2013) Choose Save Data and Refresh No data should be updated 12.5 Submit planning data & confirm in another report Choose EPM → Open → Open Server Input Form Folder → Company folder → WEBEXCEL\SCHEDULELIBRARY\20 Profit Center.xltx 20 Profit Center.XLTX Input form opens without error. 12.6 Set Context and select dimension Select 1 Profit Center and 1 P_ACCOUNT using the Context Profit Center = PC_CU00CU00041 Input form refreshes without error.
15.24 Close reports Close both reports without saving changes Reports close without error. 15.25 Use Trend report to validate Net Income - USD Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 10 TREND.XLTX Report opens without error. 15.26 Set Context and check results Set the Context and Refresh report Leave the report open P_ACCOUNT = Company Code = Currency = USD Version = Time = Measures = YTD All other dimensions = ALL Selections are applied and the report is refreshed. Report should show YTD value for Net Income for each month 15.27 Use Trend report to validate Net Income – EUR on the BS Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 10 TREND.XLTX Report opens without error. 15.28 Set the Context and Refresh report P_ACCOUNT: A_RE_YTDNetIncome - Net Income in the BS Report refreshes without error 15.29 Verify results using a Trend Report Leave the report open Result should be equal to (LC Value * EUR AVG Rate) 15.30 Use Trend report to check CTA on Net Income value Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 10 TREND.XLTX Report opens without error. 15.31 Change the Context selection for Account and select Refresh P_ACCOUNT = A_CTAdj - CTA on Net Income Report refreshes without error 15.32 Verify the results using a Trend report Result should be equal to [(LC Value * GBP END Rate) - (LC Value * GBP AVG Rate)]
in middle of the window. 17.9 Choose Ok. On the TIME row and the DESTINATION column, choose the Add button The EPM - Member Selector window opens 17.10 On the left side, expand the "+" button for 2013, then Q1 2013. Select the box for Mar-13. Choose the rightward facing arrow in middle of the window. Mar-13 Member Only appears in the right-hand side. 17.11 Choose OK. On the VERSION row and the SOURCE column, choose the Add button The EPM - Member Selector window opens 17.12 On the left side, select Actual. Choose the rightward facing arrow in middle of the window. Actual Member Only appears in the right-hand side. 17.13 Choose OK. In the Copy window, choose Next. Choose Run. Choose the Finish button on the bottom. Message appears that Request to run the package on the server was successful. The package is now running. 17.14 Choose OK on the message. Choose View Status then on the next screen, select the Refresh Status Every 5 seconds button The Status changes to Succeeded for the Copy Package. 17.15 Close Data Manager Package Choose Close, then on the next screen choose Close. User returns to Excel session. 17.17 Open report Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY → 20 Comparison.XLTX Report opens without errors and refreshes on Open. 17.18 From the Context bar, select designated values. Double-click the Excel selectors to select: TIME Feb-13 Version 1: Actual Version 2: Plan Choose Refresh. No errors are encountered.
18.2 Open report Choose EPM → Open → Open Server Report Folder → Company folder → The Reports Templates folder is opened showing the 10 solution report templates. 18.3 Select 10 YEAR AND COMPARISON REPORT.XLTX Choose OPEN 10 3-YEAR AND COMPARISON REPORT.XLTX The report opens without error. 18.4 Set Context Set the Context bar/pane Refresh report AUDIT_TRAIL = ALL_AUDIT_TRAIL COMPANY_CODE = ALL_COMPANY_CODE COST_CENTER = ALL_COST_CENTER FLOW = F_TOTAL FUNCTIONAL_AREA = ALL_FUNCTIONAL_AREA PROFIT_CENTER = ALL_PROFIT_CENTER P_ACCOUNT = A_NET_INCOME TIME = 2013 TRADING_PARTNER = ALL_TRADING_PARTNER VERSION = ACTUAL MEASURES = PERIODIC Report refreshes without error. 18.5 Confirm data Verify that the report contains data in the ACTUAL column Actual data is displayed for one or more years. 18.6 Close report Close the report without saving changes. Report closes without error. 18.7 Open report and refresh Choose EPM → Open → Open Server Report Folder → Company folder → 20 DYNAMIC REPORT WITH DRILL IN PLACE.XLTX The report opens and refreshes without error
DYNAMIC REPORT WITH DRILL IN PLACE.XLTX Refresh report 18.8 Drill and expand report rows Double-click the total, All Company Codes rows, the report rows collapse, showing only the parent, ALL_COMPANY_CODES. Double-click the parent to the children. Choose Refresh to display ALL_COMPANY_CODES and children The children of ALL_COMPANY_CODES are contracted. Report displays children and parent 18.9 Close report Close the report without saving changes. Report closes without error. 18.10 Open report and refresh Choose EPM → Open → Open Server Report Folder → Company folder → DYNAMIC REPORT WITH DYNAMIC DIMENSION IN ROW AXIS.XLTX. Refresh report 25 DYNAMIC REPORT WITH DYNAMIC DIMENSION IN ROW AXIS The report opens and refreshes without error 18.11 Change row dimension Use the Excel drop down dimension selector to select: FUNCTIONAL_AREA. Choose Refresh FUNCTIONAL_AREA The FUNCTIONAL_AREA dimension appears on the report rows. 18.12 Close report Close the report without saving changes. Report closes without error. 18.13 Open report and refresh Choose EPM → Open → Open Server Report Folder → Company folder → DYNAMIC REPORT WITH HIERARCHY-ENTITIES.XLTX. Refresh report 30 DYNAMIC REPORT WITH HIERARCHY-ENTITIES.XLTX. The report opens and refreshes with data without error.
first row dimension. 18.18 Close report Close the report without saving changes. Report closes without error. 18.19 Open report and refresh Choose EPM → Open → Open Server Report Folder → Company folder → DYNAMIC REPORT WITH Refresh report Confirm that the report displays data 50 DYNAMIC REPORT WITH SUBTOTALS-ACCOUNTS.XLTX The report opens and refreshes with data without error. 18.20 Drill down to insert children in rows Double-click the 1st report row Note that the children are inserted. Children rows are inserted 18.21 Close report Close the report without saving changes. Report closes without error. 18.22 Open report and refresh Choose EPM → Open → Open Server Report Folder → Company folder → LAST YEAR AND COMPARISON REPORT.XLTX. Refresh report Confirm that the report displays data 60 LAST YEAR AND COMPARISON REPORT.XLTX The report opens and refreshes with data without error. 18.24 Close report Close the report without saving changes. Report closes without error. 18.25 Open report and refresh Choose EPM → Open → Open Server Report Folder → Company folder → SORT ON MEMBER DESCRIPTIONS REPORT.XLTX. Refresh report Confirm that the report displays 70 SORT ON MEMBER DESCRIPTIONS REPORT.XLTX The report opens and refreshes with data without error.
data 18.26 Confirm sorting disables drill down Note that the rows are sorted alphabetically by description Double-click the 1st row to drill down. Note the error message that prevents drill-down. Rows are sorted alphabetically by description. Drill down is disabled in sorted reports. 18.27 Close report Close the report without saving changes. Report closes without error. 18.28 Open report and refresh Choose EPM → Open → Open Server Report Folder → Company folder → SORT ON VALUES REPORT.XLTX. Refresh report Confirm that the report displays data 80 SORT ON VALUES REPORT.XLTX. The report opens and refreshes with data without error. 18.29 Confirm sorting Note that the rows are sorted by values The rows are displayed, sorted by amount. 18.30 Close report Close the report without saving changes. Report closes without error. 18.31 Open report and refresh Choose EPM → Open → Open Server Report Folder → Company folder → VARIANCE REPORT.XLTX. Refresh report Confirm that the report displays data 90 VARIANCE REPORT.XLTX The report opens and refreshes with data without error. 18.33 Close report Close the report without saving changes. Report closes without error.