Concept: Analytic Dimensions
Typically, when you bring external dimension data into Workday using Prism, the data is stored in Prism as a Text field, not an Instance field. Text fields limit the type of grouping, filtering, and prompting you can perform on external dimensional data in Workday's reporting tools of Report Writer, OfficeConnect, and Discovery Boards.
Using analytic dimensions, you can bring in external dimension data and store it in Prism as user-defined instance data, enabling you to easily analyze external dimensions using Workday’s reporting tools. An analytic dimension is an Instance field in a dataset that specifies a business object containing user-defined dimension data.
You create analytic dimension business objects to store external dimension data in Workday as instance data.
Analytic Dimension Business Objects
An analytic dimension business object is a user-defined business object for storing external data in Workday that contains dimension values with an optional hierarchy.
Use analytic dimension business objects in datasets to convert Text fields to Instance fields. You might want to convert a Text field to an Instance field so that you can take advantage of more functionality in Workday’s reporting tools, such as grouping, filtering, and prompting.
You can:
- Create an analytic dimension business object for each external dimension field.
- Configure the analytic dimension business object to allow hierarchies or not.
- Define up to 10,000 dimension values per business object.
- Define up to 6 levels of dimension hierarchies per analytic dimension business object.