Measures and Dimensions

Infoveave uses measures (numerical data) and dimensions (categorical attributes) to help you analyze and visualize data. Measures represent what you want to analyze, dimensions provide context, and hierarchies organize data.

Measures

Measures are quantitative, numerical data attributes that represent the values to be analyzed. They are typically numeric and can be aggregated or calculated.

To define a measure, follow the below steps

1. Identify the specific data table and column for which you intend to create a measure.
2. Locate the designated column within the required table and proceed to click on the ellipsis icon associated with the column.
3. From the options, select the Add Measure option, an Add Measure modal window will appear, allowing you to configure the measure.
   • The Table and Column fields are predefined based on your selection.
   • The Type field is also preselected, aligned with the data type of the chosen column.
4. Among the key components of the Add Measure modal is the Aggregation field. Here, you can choose the desired aggregation function for the measure, which determines how values are summarized
   • Count Total count of values in the column.
   • Sum Summation of numeric values.
   • Average Mean value of numeric data.
   • DistinctCount Count of distinct values.
   • Min Minimum value in the column.
   • Max Maximum value in the column.
5. Proceed to configure the properties of the measure, enhancing its interpretability and relevance
   • Prefix Prefix to be added to measure values (optional).
   • Suffix Suffix to be appended to measure values (optional).
   • Measure Name Provide a distinctive name for the measure.
   • Format Define the desired display format for measure values.
   • Precision Set the decimal precision for numeric values.
   • Description Elaborate on the purpose and significance of the measure.
6. Click on the Add Measure button to finalize the configuration.
7. The created measure will be available under Measures in the Measures and Dimension Panel.

Dimension

Dimensions are categorical data attributes that provide context and categorization for measures.

To define a dimension, follow the below steps

1. Identify the specific data table and column for which you intend to create a dimension.

2. Locate the designated column within the required table and proceed to click on the ellipsis icon associated with that column.

3. Select the Add Dimension option, an Add Dimension modal window will open, allowing you to configure the properties of the dimension. The table, column, and type fields are automatically populated based on your selection, simplifying the configuration process.

4. The following fields are essential in configuring your dimension

   • Dimension Name Provide a descriptive name for the dimension to distinguish it from others.
   • Key Column Choose the column that contains unique values acting as key identifiers for this dimension. These identifiers enable proper linking and referencing of data across different tables.
   • Order Column Optionally, specify an order for the values within the dimension.
   • Description Elaborate on the purpose and significance of the dimension.

5. If you wish to define a hierarchy within the dimension or establish relationships between tables, you can specify the following

   • Hierarchy Name Define a hierarchy name to organize and structure the dimension.
   • The table, column, and type fields are automatically populated based on your selection, simplifying the configuration process.

6. The following fields are essential in configuring your dimension

   • Dimension Name Provide a descriptive name for the dimension to distinguish it from others.
   • Key Column Choose the column that contains unique values acting as key identifiers for this dimension. These identifiers enable proper linking and referencing of data across different tables.
   • Order Column Optionally, specify an order for the values within the dimension.
   • Description Elaborate on the purpose and significance of the dimension.

7. If you wish to define a hierarchy within the dimension or establish relationships between tables, you can specify the following

   • Hierarchy Name Define a hierarchy name to organize and structure the dimension.
   • Attribute An attribute represents a specific element or characteristic within a dimension that contributes to its hierarchy. Define the attribute that you want to include in your hierarchy. This could be a subcategory, subgroup, or any other relevant classification within the dimension.
   • Attribute Key Column For each attribute included in the hierarchy, you need to specify a key column that serves as a link to the related data. This key column provides a reference point for navigating and organizing data within the hierarchy.
   • Attribute Name Specify the attribute’s display name.

8. Click on Add Attribute to add the hierarchy.

9. Click on the Add Dimension button to finalize the dimension’s configuration.

Here’s an overview of these concepts in Infoveave

Measures

• Measures are numerical values that represent quantifiable data. They are typically the data points that you want to analyze, such as sales revenue, profit margins, or the number of products sold.
• Infoveave allows you to create and aggregate measures to perform calculations like sum, average, minimum, maximum, and more.
• Measures are usually displayed as numeric values in visualizations like charts and tables.

Dimensions

• Dimensions are attributes or categories that help organize and provide context to the data. They are non-numeric and typically include data like time, geography, product categories, or customer names.
• In Infoveave, dimensions are used to slice and dice data, allowing you to filter and group data for more meaningful analysis.
• Dimensions can be hierarchical, such as time with levels like year, quarter, month, and day.

Column Definition	Description	Aggressions Supported	Available Fields
Dimensions	Dimensions are columns having qualitative values (like ID, names, dates, and regions). These can be used to categorize, segregate, filter and use the ‘drill-by’ option. For example, City, Country, Category, Product Type and so on.	Count It counts the rows from the selected column. Distinct Count It counts the distinct rows from the selected column.	Table return name of the table. Column return name of the column. Type return datatype of the column such as string, int, boolean, date dimension. Dimension Name return of the dimension. Key Column links the data with the column. Order Column sorts data according to the selected column.
Measures	Measures are columns having quantitative values. You can apply aggregate functions like sum, average, min, max, count, distinct count. For example, Total Orders, Total Sales, No of Employees, and Average Order Value.	Sum It sums the rows from the selected column. Average It computes average for the rows from the selected column. Count It counts the rows from the selected column. Distinct Count It counts the distinct rows from the selected column. Min It computes the lowest row value from the selected column. Max It computes the highest row value from the selected column.	Table return the name of the table. Column return the name of the column. Type return data type of the column such as string, int, boolean, date dimension. Aggregation return the type of operations associated with columns. Measure Name name of the measure column. Prefix Defines the Measure prefix. Suffix Defines the Measure suffix. Format Defines the measure format Precision Fix the decimal precision for the measure Hide for Charts check the box if measure is not required in charts.