Custom Measure

Overview

A Custom Measure in ReOrc enables users to create new numerical calculations within a Cube, enhancing data analysis and reporting capabilities. These measures help define key business metrics that may not exist explicitly in the raw dataset.

What is Custom Measure?

A Custom Measure is a user-defined metric derived from existing fields using aggregation, mathematical operations, or conditional logic. These measures help refine insights and provide additional flexibility in data analysis.

Use Cases

• New Business Metrics: Defining KPIs such as "Profit Margin" using ((Revenue - Cost) / Revenue).

• Conditional Aggregations: Creating measures like "High-Value Orders" for transactions above a certain amount.

• Ratio & Percentage Calculations: Computing values like "Conversion Rate" as ((Total Sales / Total Visitors) * 100).

• Custom Weighting: Applying business rules to weigh certain values differently in calculations.

Create a Custom Measure

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 Create Cube

1. Click on + button, select Add a measure

1. Fill in the details in the modal:

   1. Field label will be auto populate based on the Field name

   2. When entering the custom formula, you can click on the fields on the list to auto populate into the formula box.

   3. For Aggregations and sample use case, refer to Aggregation Function

   
2. Click on Validate button to validate the formula

Ensure that the custom formula matches the type of database connected.

1. Once no error detected, click on Add button to add the custom dimension into the cube.