Page Comparison

Anchor
_Toc534679168 _Toc534679168

Add a Schedule

In Manage Mart window, you can create a schedule for the Data Mart.

To add a Data Mart schedule:

1. In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
   You see the Data Mart workspace.

2. Click the Schedules link.
   You see the Data Mart Schedules dialog box. 

3. Click Add.
   You see the Data Mart Schedule Definition dialog box.

4. In the Description box, provide a description of the schedule field.

5. Under Schedule Type section, select the type of schedule for the field. Options include:
   - Build All. Displays the Scheduled Models dialog box, allowing you to assign models to schedules. See Assign Models to a Build All Schedule for details.
   - Selective Build. Displays the Data Mart Schedules dialog box, allowing you to select the fields that are populated for a specified schedule when you submit the model on a scheduled basis. See Copy a Schedule  for details.

6. Click Snapshot to select Default or one of the snapshots you have defined.

1. See Create Multiple Snapshots of Your Data for more details.

2. In Date Rule for As of Date, select a date rule that translates the server date, for which the PACE event package is submitted, into an appropriate effective date for storage of this data in the Mart.
   Typically, the Data Mart event package runs in the early post-midnight hours of an overnight update cycle. This means that the server date is set at the real-time date that overnight processing occurs, which typically is one business day after the appropriate effective date for storing the Mart data.You probably do not want the real time server date of overnight processing to be the effective date of the data you are posting, so if you use a Prior Business Date rule, you can make the prior business day the effective date of the data.

3. Under Using section, select a single date rule or a set of date rules specific to each type of data. See Submit Models as Ad Hoc for detailed information about date rules.

4. In the Comments box, provide descriptive comments, if any.

1. Under Languages section, select Submit All Languages selected for the Model to submit the model for all the languages, if you have set up the language options for the model.

2. Choose Select Specific Languages to Submit to submit only specific languages of the model for submission and click Select Languages to select the specific languages for the model.

1. Under Currencies section, select Submit All Currencies selected for the Model to submit the model for all alternate currencies you have set up for

1. the

1. model.

2. Choose Select Specific

1. Currencies to Submit to submit only specific currencies of the model for submission and click Select Currencies to select the specific currencies for the model.

2. Click Additional Options to set the data status and logging level.
   You see the Additional Options dialog box.

3. Click Set Fund Approval Status As to determine the approval status for the funds. Options include:
   - Preliminary. Allows you to overwrite data rows with a new Submit process.
   - Final. Protects data from being accidentally overwritten.
   - Other Statuses. Select another Status type if you have added them.

1. See Manage Mart Data Status for additional information.

2. Select Save Diagnostics check box to include diagnostic details in the execution log for this submit process.

3. Click OK to close the Additional Options dialog box.

4. Complete the fields on the Schedule Definition dialog box as needed and click OK to save the schedule.

Anchor
TKCopyschedule TKCopyschedule

Copy a Schedule

In the Data Mart Schedules dialog box, you can copy a schedule.

To copy a Data Mart schedule:

1. In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
   You see the Data Mart workspace.

2. Click the Schedules link. 
   You see the Data Mart Schedules dialog box.

3. Click Copy.
   You see the Copy Schedule dialog box.

4. Enter a name for the copied schedule in the Copy as field.

5. Click OK.
   The copied schedule is added to the list of available schedules.
   When you copy a Build All or Selective Build schedule, a new schedule is created that inherits all the configuration settings and the date rule of the original schedule. The new schedule is automatically selected in all models in which the original schedule was selected. When you copy a Selective Build schedule, all fields from the original schedule are copied into the new schedule.

Anchor
_Toc534679170 _Toc534679170

Select Fields for a Schedule

You can specify which fields are populated when you submit the model on a scheduled basis. The selected fields are populated for all schedules that are assigned to that model.

To select fields for a schedule using the Data Mart Schedules dialog box:

1. In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
   You see the Data Mart workspace.

2. Click the Schedules link.
   You see the Data Mart Schedules dialog box.

3. Select the Selective Build for which you want to select fields.

4. Click the Details link.
   The selective build schedule must have been previously selected for at least one model or you will not be able to select any fields.
   You see the Select Fields for Data Mart Schedule dialog box as shown in the following figure.
   Image Modified

5. Use the check boxes to select fields for the schedule.
   If a field is to be built for one model linked to the schedule, it must be built for all.

6. Right-click in the dialog box to display the Find, Filter, and Clear options.
   For more information on these options, refer to Work with the Fields Selection Dialog Box.

7. Click OK.

Anchor
TKAssignModels TKAssignModels

Assign Models to a Build All Schedule

You can assign a model to a schedule using the Schedule to Run option on the Definition tab of the model windows. You can also assign one or more models to a Build All schedule.

To assign models to Build All Schedule:

1. In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
   You see the Data Mart workspace.

2. Click the Schedules link.
   You see the Data Mart Schedules dialog box.

3. Select a schedule of Type Build All.

4. Click the Details link.
   You see the Scheduled Models dialog box. 

5. In the Available Models, select a model and click the right arrow.
   The model appears under Selected Models. You can deselect the model by clicking the left arrow.

6. Click Save to save your selections.

7. Click Cancel to undo your actions.