Custom Dimension
Last updated
Last updated
A Custom Dimension in Recurve allows users to define new categorical fields within a Cube that do not exist directly in the underlying data model. Custom Dimensions enhance analytical capabilities by enabling additional grouping, filtering, and segmentation of data.
A Custom Dimension is a user-defined field that categorizes data based on computed logic, transformations, or predefined criteria. These dimensions help refine analyses without modifying the raw dataset.
Custom Dimensions are used when:
Derived Categorization: Creating new classifications, such as grouping age into "Youth," "Adult," and "Senior."
Conditional Labels: Assigning custom labels based on business rules, such as "High Value Customer" for those with purchases over a threshold.
Combining Attributes: Merging multiple fields into a single dimension, like concatenating Region
and Sales Territory
.
Data Standardization: Normalizing values across different datasets to ensure consistency.
To create a custom dimension, follow these steps:
Ensure the cube's primary key has been set before proceed to create the custom dimension. Refer
Click on + button, select Add a dimension
Fill in the details in the modal:
Field label will be auto populate based on the Field name
When entering the custom formula, you can click on the fields on the list to auto populate into the formula box.
Click on Validate button to validate the formula
Ensure that the custom formula matches the type of database connected.
Once no error detected, click on Add button to add the custom dimension into the cube.