Concept: Prism Data Sources
A Prism data source is a type of data source that gets its data from a Prism Analytics table or
dataset. Typically, Prism data sources blend together Workday and non-Workday data.
Prism data sources are different than Workday-delivered data sources in several ways. Prism
data sources:
- Are created by a colleague at your organization.
- Have their own primary business object that isn't linked to any other business object in Workday.
- Can become inactive. When a Prism data source is inactive, it exists in the tenant, but is empty and unavailable for querying in reports and discovery board visualizations.
- Can be deleted from your tenant. You can only remove a Prism data source when no reports or vizzes currently use the associated Prism data source.
- Only support some report types.
- Only support some field types.
- Only support some calculated fields. Some of the supported calculated fields provide limited functionality.
Prism data sources also have their own security. Security group access controls who can see a
Prism data source.
With the appropriate permissions, you can:
- Create a viz in a discovery board using the Prism data source.
- Create a custom report using the Prism data source.
- View a Prism data source by accessing theView Prism Data Sourcereport.
- Make the Prism data source inactive.
- Remove the Prism data source from the tenant.
Supported Custom Reports on Prism Data Sources
You can create these types of custom reports using a Prism data source:
- Advanced.Some features aren't supported, such as Subfilters. Workday only displays features that it supports. Also, only add a field from a related business object when necessary. Fields from related business objects might impact report performance.
- Composite.The Prism data source must include at least 1 Instance field.
- Matrix.Most features are supported. Lookup Prior Value isn't supported.
- Simple.All features are supported.
- Transposed.All features are supported.
Supported Calculated Fields on Prism Data Sources
You can create these calculated fields using Prism data sources:
- Arithmetic Calculation
- Build Date
- Concatenate Text
- Convert Text To Number
- Date Constant
- Date Difference
- Evaluate Expression
- Format Date
- Format Number
- Format Text
- Increment or Decrement Date
- Lookup Date Rollup
- Numeric Constant
- Substring Text
- Text Constant
- Text Length
- True/False Condition
Workday only makes available calculated fields that are supported for Prism data sources.
There are some limitations when creating some calculated fields:
- Calculated fields only work on supported field types. Example: date-related functions work only on fields of type Date.
- You can't use Instance or Multi-Instance fields in some calculated fields, such as Format Text and Substring Text. This is because Instance and Multi-Instance fields in Prism data sources only include the unique identifier information (also known as a WID), not the display name.