Create an Analytic Dimension Business Object with Values

Security: Prism: Manage Analytic Dimensions
domain in the Prism Analytics functional area (View and Modify permissions).

You can create analytic dimension business objects to store external dimension data in Workday as instance data. Example: An insurance company can create an analytic dimension business object that defines and stores claim type data. Workday doesn’t have a business object that stores claim type data, but the insurance company has an external database that does.

Use an analytic dimension business object in a Prism dataset Instance Mapping stage to convert a Text field to an Instance field based on the values defined in the business object.

You can define up to 10,000 dimension values per business object. Note that the

Maintain Analytic Dimension Values

task doesn’t enforce the limit. Instead, Workday will fail a dataset publish or data change task if the upstream pipeline uses an analytic dimension business object with more than 10,000 dimension values.

Navigate to the

Create Analytic Dimension Business Object

task.

Complete these options:

Option	Description
Name	This is the display name for the analytic dimension business object. The Name must be unique in the tenant.
Analytic Business Dimension Object ID	This is the identifier for the analytic dimension business object that uniquely identifies it in the tenant. The Analytic Dimension Business Object ID must be unique in the tenant.
Allow Hierarchies	Decide whether or not the business object allows you to define hierarchies and assign values to those hierarchies.

Workday displays the

View Analytic Dimension Business Object

report so that you can define and manage the values in the business object, and define hierarchies if the business object allows hierarchies.

Click

Maintain Values

Workday displays the

Maintain Analytic Dimension Values

task where you can add, edit, and delete dimension values.

Select the Add Row (+) icon to add a new dimension value.

For each value, enter:

Option	Description
Value Name	This is the display name for the dimension value as displayed in reports and discovery boards. You can create multiple dimension values with the same value name as long as they have different value IDs. You might want to do this if each dimension value is in a different hierarchy. Example: You have an analytic dimension business object for clothing sizes. You create a hierarchy for adult sizes and another hierarchy for children sizes. Each hierarchy contains a dimension value with the value name of Large, but the value IDs of adult-large and child-large.
Value ID	This is the identifier for the dimension value that uniquely identifies the text value in the external source data. The Value ID must be unique in the business object. When you use this business object in a Prism dataset Instance Mapping stage, Workday uses the value ID to find a matching dimension value for each external text value. The text you enter here should exactly match the dimension values used in your external system. When comparing external text values to the dimension value IDs, Workday performs a case-sensitive match.

Option

Description

Value Name

This is the display name for the dimension value as displayed in reports and discovery boards.

You can create multiple dimension values with the same value name as long as they have different value IDs. You might want to do this if each dimension value is in a different hierarchy.

Example: You have an analytic dimension business object for clothing sizes. You create a hierarchy for adult sizes and another hierarchy for children sizes. Each hierarchy contains a dimension value with the value name of Large, but the value IDs of adult-large and child-large.

Value ID

This is the identifier for the dimension value that uniquely identifies the text value in the external source data. The Value ID must be unique in the business object.

When you use this business object in a Prism dataset Instance Mapping stage, Workday uses the value ID to find a matching dimension value for each external text value.

The text you enter here should exactly match the dimension values used in your external system. When comparing external text values to the dimension value IDs, Workday performs a case-sensitive match.

You can access the

Maintain Analytic Dimension Values

task to add, edit, and delete dimension values anytime.

(Required if Allow Hierarchies is enabled) Create an Analytic Dimension Hierarchy and Assign Values if the business object allows hierarchies.

Workday creates the business object with the dimension values stored as instance values.

If you configured the business object to allow hierarchies, you need to create 1 or more hierarchies for the business object and add all dimension values to a hierarchy. See Create an Analytic Dimension Hierarchy and Assign Values.

When you have finished configuring the business object, you can use it in a Prism dataset Instance Mapping stage to convert a Text field to an Instance field. See Add an Instance Mapping Stage.