Populating the Target Model
- 2 Minutes to read
- Print
- DarkLight
- PDF
Populating the Target Model
- 2 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Power or Contributor user access is required for these steps.
Model > Setup > Generate Model
In Practice
Select the Target/Master model from the list box.
Scroll down to the Maps section. You should see the name of your map, the name of the Source (HACPM_Financial), the name of the Target (the Master model), and the type of transfer.
Use Generate Model to move data from the Source to the Target.
When you click Generate Model, Dynamic Planning first checks to see if the values in your Application Settings page are adequate to accommodate the dimensions and members you will be downloading from the Source.
The value in Master Model keys must exceed the number resulting from the # of members in each Key dimension multiplied by each other. For example, if you are expecting your Key dimensions to have membership of Account=80, Company=10, Department=60, Product=30, Project=40, then your Master Model Keys value must be equal to or greater than 57,600,000.
The value in Master Model Value Block Size must exceed the number results from the # of members in each Value dimension multiplied by each other. For example, if you are expecting your Value dimensions to have membership of Scenario=3, Time=15, Measures=2, then your Block Size must be equal to or greater than 90.
If Master Model keys and Master Model Value Block Size are set to an adequate value, then model generation proceeds: members and/or data are moved from Source to Target/Master according to the options you set in the Map.
If Map Type Is | And Map Transfer Is | Data Download Does This | Generate Model Does This |
Metadata | Leaf or All | Nothing. | Populates the Target with the outline of members in the dimensions, both leaf and parent, that are defined in the map. No data. |
Data (It is recommended to use the Data option only for Write-back maps.) | Leaf or All | Downloads data from Structured Planning, Consolidation, and Reporting applications to HACPM_Financial. Dynamic Planning reviews all defined maps and downloads a superset of data that covers all maps. | Populates the Target with the outline of members in the dimensions, both leaf and parent, that are defined in the map. No data is copied. To get data, you will need to explicitly run the Map using a Calculation. See “Running a Data Map Explicitly” below. |
Both | Leaf or All | Downloads data from Structured Planning, Consolidation, and Reporting applications to HACPM_Financial. Dynamic Planning reviews all defined maps and downloads a superset of data that covers all maps. | Populates the Target with the outline of members in the dimensions, both leaf and parent, that are defined in the map. Populates only the lowest-level member intersections with data. |
While the model is being generated, the status message at the bottom left of the Excel screen blinks. When complete, it says Ready. No messages are posted to the Request Status page.
At this point, you have a Source model that has been generated and contains data, and you have a Target/Master model that is generated, contains members, and may contain data depending on the Map type that you used.
Was this article helpful?