Checking Real Time Progress Status for Data Maps and Smart Push

When pushing data using data maps and smart push, you can view comprehensive information about each job's operations, including the completion status and duration in Jobs.

A sub-status field provides the detail of the specific operation being performed as part of the submitted job, such as clear data, export data, and so on. For parent-child job relationships, the parent job displays the current ongoing child job, while each child job features the specific operation being performed as part of its execution. The sub-status field is cleared after a successful completion of the job. If a job encounters an error, the sub-status field remains as is and it is not cleared.

The benefit of using the job status for pushed data maps and smart push enables customers to monitor jobs by providing meaningful details instead of just the processing state and without having to open the details of each individual job. Customers can easily identify when a job is blocked. For example, if an exclusive operation like "Clear Data " is being performed through some process on a target ASO cube and the customer tries to perform clear operation through a data map on the same cube, the sub- status indicates that the cube is waiting.

Note:

For Enterprise Profitability and Cost Management customers, sub-status details are only available on the Jobs Detail page and not on the Jobs listing page.

During the execution of the Data map job, the following sub-statuses are introduced when the Clear Data option is set to "Yes":

1. Preprocessing and validating data map.
2. Exporting data.
3. Clearing data.
4. Transforming and Importing[Transforming file [File_Getting_Executed] Of [Total_Number_Of_Files]]/Transforming and Importing[Importing file [File_Getting_Executed] Of [Total_Number_Of_Files]](At step 4 one of the above messages is displayed.)

During execution of the Data map job, the following are the sub statuses which are being introduced, if clear data is selected as "No":

1. Preprocessing and validating data map.
2. Exporting data.
3. Transforming and Importing[Transforming file [File_Getting_Executed] Of [Total_Number_Of_Files]]/Transforming and Importing[Importing file [File_Getting_Executed] Of [Total_Number_Of_Files]](At step 3 one of the above messages is displayed

The messages displayed on the Job Details page when the Clear Data option is set to "Yes" may include:

The possible steps to be executed for this job are:

1. Preprocessing and validating data map.
2. Exporting data.
3. Clearing data.
4. Transforming and Importing files.

The messages displayed on the Job Details page when the Clear Data option is set to "No" may include:

The possible steps to be executed for this job are:

1. Preprocessing and validating data map.
2. Exporting data.
3. Transforming and Importing files.

During the execution of a smart push job, the following sub-statuses are shown for parent and child jobs:

1. Run_Status: [Executing Child Job 1 Of 5: Child_Job_Name] → Parent Job Sub Status (1 and 5 are not static value, these are dynamic values which indicate which child job is being executed among the total number of child jobs).
2. Run_Satus: [ Sub_Status ] → Child Job Sub Status For Example = Processing: [Step 1 Of 5: Validating](1 and 5 are not static value, these are dynamic values which indicate which step is being executed among the total number of steps).

The following sub-statuses are shown for a child job:

1. Validating.
2. Fetching target data.
3. Fetching source data.
4. Transforming.
5. Clearing and pushing data to target.
6. (Append "Waiting" message to the step) For Example - In case of clear data if cube is busy result will look like "Processing: [Step 5 Of 5: Clearing and Pushing data to target[Waiting].]

Message displayed in job details:

The possible steps to be executed for this job are:

1. Validating.
2. Fetching target data.
3. Fetching source data.
4. Transforming.
5. Clearing and pushing data to target.

During execution of Strategic Modeling related jobs, the following sub-statuses for parent jobs are:

1. Informs the job name currently being executed, for example: Run_Status: [Executing Child Job 1 Of 5: Child_Job_Name] (1 and 5 are not static value, which are dynamic values indicating the child job is being executed among the total number of child jobs).
2. Child Job Sub Status: Run_Status: [Step 1 Of 5: Validating.](1 and 5 are not static value, which are dynamic values indicating the step is getting executed among the total number of steps).

During execution of Strategic Modeling related jobs, the following sub-statuses for child jobs are:

1. Validating.
2. Fetching target data.
3. Fetching source data.
4. Transforming.
5. Clearing and pushing data to target.

Message displayed in job details:

The possible steps to be executed for this job are:

1. Validating.

2. Fetching target data.

3. Fetching source data.

4. Transforming.

5. Clearing and pushing data to target.

For Strategic Modeling to Strategic Modeling type data maps, child jobs are created based on the target model name. The child jobs are executed in the following combination: Scenario, Value, Time Periods, and Cell Text. Each of the combinations of selected models as part of target are called. The sub-status of the parent job displays as "Processing Models" and in child jobs the sub-status is:

1. Fetching Source Data.
2. Clearing and pushing data to target.

The message display in job details shows:

1. Fetching Source Data.
2. Clearing and pushing data to target.

When a job is triggered from Strategic Modeling but the parent job is not created by the data maps layer, no sub-status of the parent job is available. The sub-status for child jobs is set and displayed on the Job listing page.

To check the real-time progress status for data maps and smart push:

1. From the Home page, click Application, click Jobs.

   

2. Optional: Perform the following task(s):

   • To filter jobs and activity by criteria such as date or job type, click .

   • To search for job by name, enter text in the Search, and then click .

3. Optional: To view the details of the job, click the job name.

   

   The sub-status of a job is only updated when you click Refresh.