Create Dataset Publish Schedules
Security:
Prism Datasets: Publish
domain in the Prism Analytics functional area.You can create a publish schedule for a dataset. You can schedule the publish to run:
- On a recurring basis (Example: daily, weekly, or monthly).
- Only if another Prism scheduled process completes at a status you specify.
You can't publish the same dataset at times that overlap with each other.
- Access theView Dataset Detailsreport for the dataset you want to publish.
- From the related actions menu, selectPublishing>Create Schedule.
- InRun Frequency, specify how often to publish the dataset. The choices include creating a dependent publish schedule.
- Select the criteria for the schedule.
- (Recurring schedules) As you configure the schedule, consider:
Option Description PriorityUnavailable for publish schedules.Catch Up BehaviorSelect how many times the scheduled publish runs after maintenance issues cause errors.Example: If you schedule a publish to run multiple times in a week when your environment is down for maintenance, you can limit the process to run once instead of catching up all missed occurrences. - (Dependent schedules) As you configure the schedule, consider:
Option Description DependencySelect a Prism-related schedule on which the publish schedule depends.Trigger on StatusSelect the status of the scheduled future process that triggers publishing the dataset.Workday recommends using one of the completed statuses.Example: You selectPublish Datasetas your process type and a future publish schedule calledAll Currencies. In theTrigger on Statusfield, you selectCompleted.Workday publishes the dataset only after the scheduledAll Currenciespublish successfully completes.Time Delayed Configuration(Optional) Specify the number of days, hours, or minutes to delay publishing the dataset after the trigger. You might want to delay publishing to review the latest source files. - (Optional) Change the name of your publish schedule.Workday assigns a name to the schedule based on the name of the dataset and prependsPublish Schedule:to the name. You can change the name of the schedule in theRequest Namefield when you edit the schedule. Workday displays this name in theProcess MonitorandScheduled Future Processesreports to help you identify a specific process request.
Workday publishes a dataset based on the criteria that you specify. When publishing, Workday:
- Reads the source data in the dataset.
- Transforms the source data using the transformation logic defined in the dataset.
- Creates a Prism data source if it doesn't already exist and loads it with the transformed data.
- Applies the appropriate security restrictions to the data.
View the status of all scheduled publishing processes on:
- TheDataset Activitiestab of theData Catalogreport.
- ThePrism Management Consolereport. For more information, see Concept: Prism Management Console.
- ThePrism Activities Monitorreport.
Refresh the browser to see the most current status. The status includes the date and time (UTC) that Workday last published the dataset successfully. The last successful publish date informs you about the freshness of the data in the Prism data source. Example: If the last successful publish date is 1 week ago, but you set your publish schedule to publish daily, this discrepancy could indicate a failure in the publishing process.