Full Transaction Data Load from SAP G/L Procedure Test Test Step Name Instruction User Entries: Expected Result Pass / Fail / Step # Field Name: Value Comment 8.1 Connect to Planning Open EPM add-in and connect to the EPM 10 connects to <Customer> model Planning model. environment and Planning model. 8.2 Clear existing SAP Prepare to load new Actual data from the Clear Period YYYY.MM Ensure that Status = Succeed. BPC data SAP BW source by clearing out existing Parameters: If OK, then close window. data from SAP BPC by using the standard Version = Actual Under View Status, browse detail SAP BPC Clear package function. status windows to see if any known Time = <Period> →Run Select EPM→ Data Manager errors or issues occurred All other dimension selections → → Package Data Management should be <all> Clear 8.3 Confirm that the Validate results using the Trend report. WEBEXCEL\REPORTLIBRARY\10 Report refreshes successfully and data Clear is Trend.XLTX. YYYY.MM Net Income = Keep the same high-level Context complete dimensionality set previously Select Refresh in the EPM menu. Validate YYYY.MM Net Income → → 8.4a Edit and revise Select Data Manager Run Package 70 Transactional FULL BW Data Ensure that Status = Succeed. Package Link and Run Package Link→70 Transactional Load If OK, then close window → load data (if using FULL BW Data Load→ Run Under View Status, browse detail SAP ERP source) Select the Package Listed→Set InfoProvider: /PKG/FP_C01 status windows to see if any known →OK→Next Prompt→… errors or issues occurred Dimension/Field List: ALL Set Transformation file…→Next→Next→Next→Finish Transformation Files: (leave default values on each Next) BW_PKG_FP_C01_TFORM.XLS; →View Status BW_PKG_FP_C01_CONV.XLS
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
A93_BPC101_BPD_EN_XX.docx