How to Download Data from the Structured Planning, Consolidation, and Reporting Applications into Dynamic Planning
  • 4 Minutes to read
  • Dark
    Light
  • PDF

How to Download Data from the Structured Planning, Consolidation, and Reporting Applications into Dynamic Planning

  • Dark
    Light
  • PDF

Article summary

  1. Log in to Dynamic Planning and select the application that you want to connect to the Structured Planning, Consolidation, or Reporting application.
  2. Select Manage > Application Administration > Application Settings. Horizon Uri, Soap Uri, and Tenant Code are protected fields. You must call HA Support to change them.
    1. Fill in the Username and Password under Horizon Uri.
    2. Fill in the Horizon Tenant Code.
    3. Fill in the Username and Password under Soap Uri.
    4. Click Save.
  3. Select Manage > Application Administration > Metadata Download.
    1. Click Run. This command creates and populates a model of type Source called HACPM_Financial.
      ModelingImagesDataIntegration-CoreFunctionalSpecHowtoDownloadDatafrom.png
  4. Select Manage > Application Administration > Application Statistics. Under Source Models, you will see HACPM_Financial, its disk usage, number of records, and dimension information.
    ModelingImagesDataIntegration-CoreFunctionalSpecHowtoDownloadDatafrom1.png
    1. Copy the list of dimensions, member count, and hierarchy levels to a separate spreadsheet. Then decide and mark which dimensions will be Key, which will be Value, and which you do not plan to use.
      1. Key: dimensions and members will change; generally more dimension members.
      2. Value: dimensions and members that don’t change much and that are always populated with data; generally fewer dimension members.
      3. You cannot use the AttributeHierarchy and Attribute dimensions.
      4. BudgetEntity is optional.
    2. Multiply the Member Count for all Key dimensions together. This number is your minimum Master Model Keys value.
    3. Multiply the Member Count for all Value dimensions together. This number is your minimum Master Model Value Block Size value.
    4. Go back to Manage > Application Administration > Application Settings and increase the values, if necessary, of Master Model Keys and Master Model Value Block Size to accommodate the capacity that you expect to have in your Target model. Save your changes.
  5. Select Model > Setup. Here you will create the Master/Target model that will contain a subset of data downloaded from Structured Planning, Consolidation, and Reporting applications.
    1. In the Model field, type in a name for this model.
    2. In the Type field, select Master.
    3. In the Dimension area, paste in the names of the dimensions and their types, from the previous step, that you want to use in the model.
    4. Click Save.
      ModelingImagesDataIntegration-CoreFunctionalSpecHowtoDownloadDatafrom2.png
  6. Select Model > Map. Here you will specify which members of the Source dimensions will be copied to the Target/Master.
    1. In the Target Model field, select the name of your Master/Target model, created in the previous step.
    2. In the Name field, type in a name for this map.
    3. In the Type field, select Both.
    4. In the Source Model field, select HACPM_Financial.
    5. In the Transfer field, select Leaf.
    6. In the Source to Target Map table, list all the dimensions in the Source in the first column (Source Dimension). Omit AttributeHierarchy and Attribute (and optionally BudgetEntity) from the list.
    7. If you want all members from this dimension, select AllMembers in the second column (Source Filter), then in the third column (Source Value), select None.
    8. If you want a subset of members from this dimension, select the appropriate item from the drop-down list, then in the third column, specify a member name (for MemberAndBelow or FixedMember) or level number (for LevelAndAbove).
    9. If you don’t want this dimension in your Target model, select DimensionFilter from the drop-down list, then in the third column, specify one member from that dimension that is associated with the data you are copying from Structured Planning, Consolidation, and Reporting applications.
    10. For the Measures dimension, select FixedMember in the second column, then in the third column, type either YTD or MTD.
    11. In the fourth, fifth, and sixth columns, you will specify the corresponding Target Dimension, Target Filter, and Target Value to go with the first three columns. Specify None for all three columns if the Source Filter is DimensionFilter.
    12. Click Save.
      ModelingImagesDataIntegration-CoreFunctionalSpecHowtoDownloadDatafrom4.png
  7. Select Model, and Calculation to create a calculation that will download the data. Data Download is a Type option in the Calculation.
    1. In the Model field, select the Master/Target model from the drop-down list.
    2. In the Name field, give the Calculation a name, such as DataDownload Calc.
    3. In the Run in Background field, select Yes.
    4. In the Success Notification and Failure Notification fields, enter your email address.
    5. Under Type, select Download Data.
    6. Under Name, type None.
    7. Click Save.
    8. Click Run.
    9. Click Refresh occasionally until the download is 100% complete and watch the Last Run Status field. You will receive an email when the calculation is complete.
  8. Select Model > Setup.
    1. In the Model field, select the Master/Target model from the drop-down list.
    2. Click Generate Model. This command copies leaf-level data from the Source (HACPM_Financial) to the Master/Target.
      ModelingImagesDataIntegration-CoreFunctionalSpecHowtoDownloadDatafrom7.png
  9. Select Model > Calculation to view and run the default calculation.
    1. In the Model field, select the Master/Target model from the drop-down list.
    2. In the Name field, select the name of your model from the drop-down list. (The default calculation has the same name as the model.)
    3. In the Run in Background field, select Yes.
    4. In the Success Notification and Failure Notification fields, enter your email address.
    5. Click Save.
    6. Click Run.
    7. Click Refresh occasionally and watch the Last Run Status field. You will receive an email when the calculation is complete.
      ModelingImagesDataIntegration-CoreFunctionalSpecHowtoDownloadDatafrom8.png
      Now your Master/Target model is populated with both leaf-level and parent data, and it is ready to use in Views and Reports.
  10. Select Model > Calculation. Now you will create a calculation to run whenever you want to repeat the download steps to download fresh data from the Structured Planning, Consolidation, or Reporting application to your Source model.
    1. In the Model field, select the Master/Target model from the drop-down list.
    2. In the Name field, type a name, such as Core App DW Download.
    3. In the Run in Background field, select Yes.
    4. In the Success Notification and Failure Notification fields, enter your email address.
    5. Under Type, add two commands using the drop-down: DownloadMetadata and DownloadData. Under Name, type None.
    6. Click Save.
      ModelingImagesDataIntegration-CoreFunctionalSpecHowtoDownloadDatafrom9.png
  11. Select Model > Calculation. Now you will create a calculation to run whenever you want to erase what is in your Master/Target model and get fresh data from the Source model.
    1. In the Model field, select the Master/Target model from the drop-down list.
    2. In the Name field, type a name, such as Model Refresh.
    3. In the Run in Background field, select Yes.
    4. In the Success Notification and Failure Notification fields, enter your email address.
    5. Under Type, add three commands using the drop-down: ClearModel, GenerateModel, and Aggregation. Under Name, type None.
    6. Click Save.
      ModelingImagesDataIntegration-CoreFunctionalSpecHowtoDownloadDatafrom10.png

Was this article helpful?