3.2.3 Data File History

The Data File History screen in the OFS Cloud Service allows you to see the data files that are uploaded to the staging tables and their status.

The Data File History summary screen allows you to do the following:

• Search for data files for which the stage data loader batch is already executed.
• Move the data from stage to processing tables.
• Delete the data from the stage or processing tables.
• Scan for invalid members.
• Create invalid members.

To open the Data File History window:

1. Navigate to the Data Management Tools, select Data File Administration, and then select Data File History to display the Data File History summary screen.

   Figure 3-15 Data File History summary screen

   
   

   

   
   

   The summary screen displays the following information of the data files:

   • Batch Run ID: The ID used to run the batch.
   • File Name: The data file name.
   • File Loaded On: The date on which the data file is loaded.
   • Records Loaded: The number of records loaded using the data file.
   • Records Rejected: The number of records that are rejected from the data file.
   • View Details (Icon): Select a Batch Run ID and click the details of the data file.

   The following illustration is a sample of the data file’s details.

   Figure 3-16 File Details

   
   

   

   
   

• Promote selected files to Processing (button): To promote the selected file or files for processing. This triggers the Batch Scheduler and queues the selected file or files for processing.
• Advanced Actions (button): There are four options in the Advances Actions. The following table explains the four options and the related information that is required to complete the actions:

  Table 3-10 Advanced Actions

  	As Of Date	Table Name	Data File Specification	File Name(s)	Comments / Notes
  Delete Data from Staging	Required	Required	Required	Optional	Required
  Delete Data from Processing	Required	Required	Required	Required	Required
  Scan for Invalid Members	Required	Required	Required	Optional	Not applicable
  Create Invalid Members	Required	Required	Required	Optional	Not applicable

  • Click Delete/Scan/Create button as applicable.
    • Delete Data from Staging: The staging data uploaded from a data file will be deleted.
    • Delete Data from Processing: The processing data uploaded from a file will be deleted.
    • Scan for Invalid Members: To scan the staging data and identifying the dimension member codes present in the staging table, but not present in the corresponding dimension tables.
    • Create Invalid Members: To populate the dimension tables with members identified in the above scan.
• Help (Button): Click the Help icon to view the Data File History help.

Scan for Invalid Members and Create Invalid Members is also possible using the Scheduler Services.

Table 3-11 Scan and create Invalid Members

Task Code	Task Name	Component	Parameters
1 *	Scan_Staging_for_Invalid_Members	Scan_Staging_for_Invalid_Members	Table Name Data File Specification: select the Data File Specification name from the available list. Data File Name Fail When Invalid Members
	Create_Invalid_Members	Create_Invalid_Members	Table Name Data File Specification: select the Data File Specification name from the available list. Data File Name

* Task Code in the above table is for illustration purpose only. You can name them as per your requirements.

Promoting a Data File for Processing

By promoting a Data File for processing, you insert the Data from the staging tables to the processing tables.

To promote a Data File for processing:

1. Click on the Table Name icon to display the Category – Table Names window. This window displays the Stage Table Names where data is already loaded. The tables are categorized into different groups and are as follows:
   • Transaction Summary
   • Ledger
   • Others
   • Schedule
   • Instruments

   Each of the above categories lists the tables available to which the data is loaded. The list of categories is dependent on the Metadata from the seeded tables that come with the various OFS Cloud Services and may differ from that shown above based on the services you have subscribed.

2. Select the Table for which you want to see the File History from the list.
3. Select the relevant As Of Date from the drop-down list. This drop-down list displays different As-of-Dates. These dates are based on processed or not processed data loading. For example, if you have already processed some data on a previous date, this drop-down displays that date and displays the current date.
4. Click on Promoted to Processing and select the following options:
   • All: To display all the Data Files that are specified on the selected As-of-Date.
   • Yes: To display only the Data Files that are already specified and processed on the selected As-of-Date.
   • No: To display only the Data Files that are specified but are in the queue to be processed on the selected As-of-Date.
5. Click the Search icon to display the Data Files information as per the option you selected in the previous step.
6. Select one of more Batch Run IDs that you want to promote for processing and click the Promote selected files to Processing button. This triggers the Batch Scheduler and schedules the Batch for processing. You can monitor the status using the Monitor Batch screen.

Reloading a Data File

OFS Cloud Services allow you to reload a Data File. For the detailed instructions on Reloading the Data File, see the Scheduler Service section.

Note:

While defining the Task, ensure that you select Delete Data Loader from the Component drop-down list.