The Integrated Margin Planning model loads data from predefined input data tables (see Predefined Input Tables.) Once it is loaded into the input tables, the data can be propagated into the model, where it is available to use.
The data is loaded into the predefined tables from Excel files located in <imp_install>\custom\data. If desired, you can edit the Excel files or replace the Excel loads with direct ETL loads.
The predefined input tables include the following information:
Dimensional data—All dimensional data, including member names and hierarchies
Assumptions data—All business assumptions and drivers driving the model calculations
These assumptions can be changed to “bootstrap” the system with a starting point on assumptions. Assumptions data can be managed within Integrated Margin Planning, or it can be refreshed from a source system on an ongoing basis.
Transactional and Plan Data Feeds From Other Systems—These data feeds can be changed to load from actual sources of data if desired.