View Collected Data for Measures Before Running a Plan

The Collected Measure Data table enables you to view imported or collected records and their statuses without having to examine log files or run a plan. The table lists measures that were successfully populated as well as also those that weren’t for your plan. By using this table, you can quickly resolve problems in the data load process.

Just as you can use the Supplies and Demands table to view the collected or imported supplies and demands, you can use the Collected Measure Data table to view bookings, shipments, and other entities.

For example, Small Inc. imported its shipments history data using the Supply Chain Planning Shipments History file-based data import (FBDI) template. To save time and work efficiently, the company wants to ensure that data was correctly imported before running its plan. The company uses the Collected Measure Data table and selects the option to view only records with errors. The company notices that several records have an error pertaining to invalid names for the Customer Site level member. Now that the reason behind the error has been identified, Small Inc. can fix the data in the FBDI file, import the data again, and run the plan. By using the Collected Measure Data table, Small Inc. quickly identified data import-related problems and didn’t have to spend time analyzing the log files for the import or analyzing the plan after running it.

1. In the Plan Inputs work area, click the Open drop-down button.
   The Open Table, Graph, or Tile Set dialog box opens.
2. Select the Collected Measure Data table and click OK.
   The Collected Measure Data table opens in a new tab.
3. Specify your search criteria, and click Search.
   Use the Errors field to limit the records to those with errors or those without errors.

   Note: By default, the table displays only the first 10,000 records that meet your search criteria. To change this limit, you need to create and use a profile option with the MSC_COLLECTED_MEASURE_DATA_MAX_ROWS code. No indication is provided if the table has records that aren’t displayed because the predefined or user-defined limit has been exceeded.
4. Analyze the records that are returned according to your search criteria.
   The Last Updated Date column displays the date on which the records were created or last updated.
   The Refresh Number column displays the refresh numbers of the collection job sets through which the measures were populated when the FBDI templates or collections feature was used.
5. Optionally, to export the records to a Microsoft Excel file for further analysis, click Actions > Export to Excel.
   The records available in the Collected Measure Data table are exported to the file. The predefined or user-defined limit is applied when the records are exported.

   Tip: When you export the records to an Excel file, you can view more than 15 records at a time. You may find it helpful during your error analysis to view more than 15 records at a time.