Move consolidated data to reporting solutions

Consolidated data can be moved from Financial Consolidation to our Data Integration database, making it readily accessible for import into the Financial Planning & Analysis (FP&A) application and other reporting solutions. This data mobility is a fundamental objective of the Prophix One Platform, and it is accomplished by using Data Integration to retrieve consolidation data and move it to the Staging Database in the Prophix Cloud, facilitating easy importing for users of FP&A and other reporting solutions.

What type of data can be exported?

These four types of data can be exported:

  • Consolidated data

  • Dimension structures

  • Local data (Pre-consolidated data) (*)

  • Detailed transactional data (Drill-across data)

  • CashFlow

  • Consolidated data by POV

  • All dimension groups

Export consolidated data

  1. Go to the Automation > Jobs > Schedules page.

  2. In the Job Type field of the Details tab, select Export to Reporting Solutions.

  3. In the Data type selection field, select the type of data you want to export.

    Types of data that can be exported include:

    • Consolidated data

    • Dimension structures

    • Local data (*)

    • Detailed transactional data

       Caution:  During the transfer of detailed transactional data, there is a possibility of overwriting data in all tables. To retain past transactional details, export data from multiple periods and use that as a safeguard.

    • CashFlow

  4. Choose periods from the Periods table.

    • To select all the periods, select this box: (on the table header, beside Code column).

  5. Optionally, use (the toggle switch) as follows:

    • Click once to display only the selected periods.

    • Click again to display only the unselected periods.

    • Click once more to display all the periods (both selected and unselected).

  6. Provide the information required in all the other fields.

     Note:  This icon, , now appears beside every field that has a tooltip. Click on the icon to display the purpose of the parameter and how it is used.

  7. You have these options:

    • To run the job immediately select and click .

    • To run the job at a later time, proceed to the Schedule tab and schedule the job to run at a later time. For more information on job scheduling, see Schedule tab in the Job Schedules article

     Tip:   If the DI Studio Job runs successfully (you can check for the status of the job on the Jobs tab of the Job Schedules page), it is confirmation that the data from the table in the source has been moved to the assigned table in the staging database.

-------------------

(*) This is applicable only when exporting to a reporting solution. On the System Configuration page, the administrator can switch between Local Data and Locally Adjusted Data with the L Journal Entry Type option.

By default, the L Journal Entry Type option is not selected, and the application uses Local Data. However, when selected, the application uses Local Adjusted Data.

Export Cashflow information

  1. In the Data type selection field, choose CashFlow .

  2. For Data, choose either Adjusted Bundles or Group Adjusted Bundles.

  3. In the Custom Report section, select one or more cashflow-type reports to define the structure of the export.

     Note:  These reports are created Reports > User Reports > Define User Reports.

  4. Choose one or more time Periods for which you want to export the data.

  5. Specify the Time reference: month or period.

Export Consolidated data by POV

  1. In the Data type selection field, choose Consolidated data.

  2. Choose one or more time Periods for which you want to export the data.

  3. Select the Consolidated data by POV option.

  4. Use the Point of View field and Target default member keys to configure the POV for the report.

Export all Dimension information

To export all dimension groups in a single job:

  1. In the Data type selection field, choose either Local Data . or Consolidated data.

  2. Choose one or more time Periods for which you want to export the data.

  3. Click in the drop-down list of the Dimension Group column and select All.

Job output

For detailed information about the output generated by the Export to Reporting Solutions job via the Staging Database, refer to Export to reporting solution job output.