RCA Open Source Application: ROSA Manual/Unit 5 - Populating Your Own RCA Database/Step 3

 Table of Contents   edit

• Introduction
• Limitations of ROSA
• RCA Modeling
  • Cost Objects in an RCA Model
  • Planning Outputs and Primary Costs
  • Relationships in an RCA Model
  • Storyboard of the Get Well Manufacturing Model
• Demonstration of the Base Model
  • Step 1: Discover RCA
    • Analyze Rates
    • Analyze Resource Pools
    • Analyze Product Cost
  • Step 2: Play with the RCA Model
    • Maintain Resource Pools
    • Maintain Products
    • Maintain Primary Cost
    • Maintain Consumptions
    • Maintain Capacity
    • Update Rates
• Unit 5 - Populating Your Own RCA Database
  • Step 3: Build an RCA Model
    • Import Master Data and Values
    • Importing of Resource Pool & Business Process Master Data from a source file
    • Importing of Product Master Data from a source file
    • Importing of Primary Costs & Consumption Quantities from a source file
    • Importing of Capacity Quantities from a source file
    • Final Step
• Appendix A. Palo Installation Guide

POPULATING YOUR OWN RCA DATABASE

Step 3: Build an RCA Model

---

Figure 32- ROSA Main Menu page, Step 3

Under the Installation section described in unit 4 (refer to page 19), select Custom Model and acknowledge the pop-ups about the model.

Click on the Check the Server Connection button shown in Figure 15, to ensure you are now connected to the ROSA_Sample_Database.

Important Note: To see the results of what you have imported between each process completed, it is wise to make use of the Palo menu options “Modeller” and “Paste View”. When using the “Paste View” functionality be sure to open a new Excel workbook sheet each time so that you do not corrupt the existing ROSA workbook sheets.

The Modeller displays the structures of the model’s dimensions and their elements. The two dimensions Sender (Provider) and Receiver (Consumer) at this stage will show only the top parts of the cost object structure.

The Paste View function allows you to look at transactional data by creating customized reports. From the ‘Page Selector’ frame, drag-and-drop elements to the column- or row title frames. The reports under Step 1 of the menu are all customized reports using the Paste View function. Therefore, it is not a requirement that you construct your own reports. This paragraph is merely to make you aware of the model’s functionality, should you find the standard reports insufficient for your purposes.

The process of building your own model starts by using the Import Screen, and will include the four import steps as follows:

• Importing of Resource Pool & Business Process Master Data
• Importing of Product Master Data
• Importing of Primary Cost and Consumption Quantity Planned Values
• Importing of Capacity Planned Quantities

---