Change the Dataset Example Rows

Any of these security requirements:

Prism Datasets: Manage
domain in the Prism Analytics functional area.

Prism Datasets: Owner Manage
domain in the Prism Analytics functional area.

Dataset Editor
permission on the dataset.

Dataset Owner
permission on the dataset.

Dataset Viewer
permission on the dataset and the tenant is configured to have the

Enable Prism Dataset Transformations

check box enabled.

Any of these requirements:

Dataset Viewer
permission on the source base dataset.

Dataset Editor
permission on the source base dataset.

Dataset Owner
permission on the source base dataset.

Table Viewer
permission on the source table.

Table Editor
permission on the source table.

Table Owner
permission on the source table.

Workday displays a subset of dataset rows to give you insight into your source data when you edit a dataset. You can change the example data to select between:

No Example

. You can disable all example data temporarily to improve responsiveness if your dataset has a lot of fields. After you make some changes to the dataset, such as adding a new stage or calculated field, you can then enable the example data by selecting the number of rows to display.

Default

. Workday displays the first 20,000 rows from the table or base dataset.

Custom Example

. For derived datasets, you can define rules to curate what data you see and how each stage impacts it. When you apply rules to the custom example data displayed, Workday reads the data from the sources again and updates the statistics and field information for each field in the inspector panel. You can only apply 1 custom example at a time across all datasets in a tenant.

You might want to define custom example rows to get more precise statistics on each field in the inspector panel.

If you have permissions to view the

View Dataset Transformations

report, then you can change example data but won't be able to save the example data configuration.

If you're new to Workday, you don't have access to create or edit base datasets.

Access the

Edit Transformations

task for a derived dataset.

Select

Default Example

This field changes to reflect the current example option selected.

Select

Custom Example

Select

Add First Rule

You can add 1 rule per base dataset or table.

Select a source.

Workday displays the tables and base datasets that you have permission to view.

(Optional) Add a

Description

to help others understand how the rule impacts the data.

Specify Conditions

by creating a conditional rule for the data.

You can add 1 or more conditions.

(Optional) Select

Convert to Advanced

Use the Prism expression language to write a boolean expression. For more information and examples, see Reference: Boolean Expressions.

You can convert rule conditions created in Basic mode to rule expressions in Advanced mode. If you switch back to Basic mode from Advanced mode, you need to define rule conditions again. Workday doesn't convert Advanced mode rule expressions to Basic mode rule conditions.

Apply

the rule.

You can only save the rule if you have Dataset Editor
permission for the current derived dataset.

(Optional)

Download Example Data

You can download the example data displayed to view a snapshot of how your stages impact the data before publishing.

Workday applies the rule to the example data and displays rows that meet the defined conditions.

You can copy the rules in this derived dataset and paste them into a different derived dataset that imports the same tables and base datasets by selecting the related actions menu by the custom example rule.

Reference: Boolean Expressions

2022R2 What's New Post: Custom Examples for Prism Dataset Transformations