1 / 25

SCPM Forecast Macro Tool Overview

IBM SCPM Forecast Macro Tool is an Excel-based tool that allows offline work with Forecast, Commitment, and more. Steps included for downloading, loading, updating data, and uploading to SCPM. Save updates in SCPM-format flat files.

edaley
Download Presentation

SCPM Forecast Macro Tool Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IBM SCPM Forecast Macro Tool January 2, 2020

  2. Forecast Macro Overview

  3. SCPM Forecast Macro Tool • A Microsoft Excel-based macro-driven spreadsheet • Based on your SCPM role permissions, it enables you to work offline with previously-downloaded data measures: 1. Forecast 4. Proposal 2. Commitment 5. Commodity Risk 3. Order Book 6. RSC Stock • Displays the SCPM data in IBM “horizontal” format that includes: • Collaboration Dimensions, Data Measures and Time Buckets • Attribute data including SubGeo and Order Type or Document Number • Allows users to save updates to Forecast, Commitment, or CRA data as SCPM-format flat files, in preparation for upload to SCPM

  4. 1 5 2 4 E2open SCPM 3 Process Flow • There are five steps you complete when using the tool: • Download SCPM-format flat file data from SCPM • Load the data files to the tool • (converts vertical to horizontal) • View and update the data in the tool • Save the updated data • (converts horizontal to vertical) • Upload the flat file data to SCPM

  5. Downloading the Macro Tool

  6. SCPM-MacroTool.xls Downloading the Macro Tool • From the Navigation Tree, click the [+] icon left of Upload /Download • Click Macro Tool to access the File Download window • Click the Save button to save the Macro Tool to your hard drive 1 3 2

  7. Loading Data into the Macro

  8. Starting the Macro • When you open the tool, Excel presents the Tool Splash Screen • Click the Open DownloadFile button 1

  9. Uploading Data to Tool • At the Open File dialog box, select the SCPM flat files you want to upload to the Tool. • Click the Open button to upload the files to the Tool. Note: You can press the <ESC> key to cancel the upload process. 1 2

  10. Using the Forecast Macro

  11. Tool Display • After the tool finishes converting the SCPM-format flat files to IBM “horizontal” format, it displays the data and tool functions in a second Excel tab

  12. Tool Display A A • The tool user interface has four sections: • Input Modifiers • Collaboration Data Elements • Data Measures and Daily Buckets • Macro Buttons D B C

  13. Input Modifiers B A • The Input Modifier section displays the Input Modifiers you selected: • Operation – the File Upload Type (Load or Update), it is modifiable • Delta Options – the Calculated Delta method and Include RSC Stock option, both are modifiable

  14. Collaboration Data Elements • Domain – required data for upload process, always IBM Broker Domain

  15. Data Measures and Daily Buckets B A Uploaded Calculated • Data Measure – uploaded and calculated data measures: • RSC Stock – uploaded SCPM flat file data (read-only) • Forecast – uploaded SCPM flat file data (modifiable) • Order Book – uploaded SCPM flat file data (read-only) • Proposal – uploaded SCPM flat file data (read-only) • Commitment - uploaded SCPM flat file data (modifiable) • Commodity Risk – uploaded SCPM flat file data (supplier cannot view, modifiable) • Delta – calculated data (computation set by Input Modifier or Delta Options settings) • Cum Delta – calculated data (= Current Delta + Previous Cum Delta) • Daily Buckets – daily buckets as set by Input Modifier

  16. Macro Buttons A B C • There are Update, Copy, and Save macros: • Update Macros • Copy Macros • Save Macros • Clicking the button executes the macro process

  17. Updating FC Version or Doc Number

  18. Updating FC Version • Allows you to update Forecast version number.

  19. Updating Data Measures

  20. Copy Proposal • Copies Proposal data to the Commitment data measure:

  21. Copy Forecast • Copies Forecast data to the Commitment data measure:

  22. Copy Order Book • Copies Order Book data to the Commitment data measure:

  23. Saving Macro Data

  24. Saving Forecast, Commit, and CRA Data • Clicking the Save Forecast, Save Commit, Save CRA, Save Order Book, or Save RSC Stock button prompts the tool to save the Forecast (A), Commit (B), Commodity Risk (C), Order Book (D), or RSC Stock (E) data as an SCPM format flat file. Note: Each of these is a separate file that you have to upload. E A D B C

  25. Saving Forecast, Commit, and CRA Data • When you click a Save button, the tool first converts the data to SCPM-format before displaying the Save As dialog box • At the Save As dialog box appears, enter the file name for the new file and click the Save button. • When you are ready, you can use the SCPM Upload feature to upload the data to the system. Note: SCPM will only let you upload data measures that your role has permission to update. Work In Progress Tip At any time, you can save the macro tool and data you are working with by following the Menu Path: FileSave As. You must save the file as an Excel format and the file name must be less than 25 characters. 1

More Related