Predefined input tables in Integrated Margin Planning are populated with sample Excel files. You can replace the Excel loads with loads from other data sources as appropriate. The tables populate Integrated Margin Planning data sources, row sources, and dimensions.
Table 11 lists the predefined input data tables in Integrated Margin Planning and the target modeling objects and input Excel files to which the tables are wired.
Table 11. Predefined Input Tables
| Input Data Table | Target Object Type | Target Object Name | Input Excel File | Excel Tab |
|---|---|---|---|---|
| IS_MP_BOM | Dimension | BOM | imp_dimension_data.xls | BOM |
| IS_MP_CALENDAR | Dimension | Fiscal, Manufacturing | imp_calendar.csv | |
| IS_MP_CAPACITY | Row Source | Capacity_RS | imp_assumptions.xls | Capacity |
| IS_MP_CUSTOMERS | Dimension | Customers | imp_dimension_data.xls | Customers |
| IS_MP_DC_SOURCING | Row Source | DC_Sourcing_RS | imp_assumptions.xls | DC Sourcing |
| IS_MP_DEMAND | Row Source | Demand_Plan_RS | imp_datafeeds.xls | Demand Plan |
| IS_MP_DISTRIBUTION_CENTER | Dimension | DistributionCenter | imp_dimension_data.xls | DCs |
| IS_MP_EXCHANGERATES | Row Source | Currency_Exchange_RS | imp_assumptions.xls | Exchange Rates |
| IS_MP_FINANCIALPLAN | Row Source | Financial_Plan_RS | imp_datafeeds.xls | Financial Plan |
| IS_MP_GEOGRAPHIES | Dimension | Geography | imp_dimension_data.xls | Geographies |
| IS_MP_INFLATION | Row Source | Inflation_RS | imp_assumptions.xls | Inflation |
| IS_MP_INVENTORY | Row Source | Inventory_RS | imp_datafeeds.xls | Inventory |
| IS_MP_INVENTORY_DC | Row Source | InventoryDC_RS | imp_datafeeds.xls | Inventory_DC |
| IS_MP_LABORDETAILS | Row Source | LaborDetails_R | imp_assumptions.xls | Labor details |
| IS_MP_LABORRATES | Row Source | LaborRates_RS | imp_assumptions.xls | Labor Rates |
| IS_MP_MARKET_SIZE | Row Source | Market_Size_RS | imp_assumptions.xls | Market Size |
| IS_MP_MATERIALMETRICS | Row Source | Material_Details_RS | imp_assumptions.xls | Material Details |
| IS_MP_OPEN_ORDER_SALES | Row Source | Open_Sales_Orders_RS | imp_datafeeds.xls | Open Sales Orders |
| IS_MP_OVERHEAD_EXPENSES | Row Source | Overhead_Expenses_RS | imp_assumptions.xls | Overhead Expenses |
| IS_MP_PLANT_SOURCING | Row Source | Plant_Sourcing_RS | imp_assumptions.xls | Plant Sourcing |
| IS_MP_PLANTS | Dimension | Plants | imp_dimension_data.xls | Plants |
| IS_MP_PRODUCTS | Dimension | Product | imp_dimension_data.xls | Products |
| IS_MP_SHIPPED_ORDER | Row Source | Shipped_Sales_Orders_RS | imp_datafeeds.xls | Shipped Sales Orders |
| IS_MP_TRANSPORT_COST | Row Source | Transport_Cost_RS | imp_assumptions.xls | Transport Cost |
| IS_MP_TRANSPORT_DETAILS | Row Source | Transport_Details_RS | imp_assumptions.xls | Transport Details |
| IS_MP_TRANSPORT_MODE | Dimension | TransportMode | imp_dimension_data.xls | TransportModes |
| IS_MP_WIP | Row Source | WIP_RS | imp_datafeeds.xls | WIP |
| IS_MP_WIP_DC | Row Source | WIPDC_RS | imp_datafeeds.xls | WIP_DC |