Custom Dimension Value (UDHC)

4.10.2Custom Dimension Value (UDHC)

Custom dimension value columns or rows can be created by defining and applying mathematical formulae on existing row and column values as per your needs. This is also known as User Defined Header Columns (UDHC).

Users can create new dimension value columns by performing various conditional statements, such as string, arithmetic, date, statistics, trigonometry, or using various arithmetic operators (such as +, -, /, etc.) or comparison operators (such as =, >, < etc.) on two or more existing dimension columns or rows.

Users can also create custom dimension values by performing valid operations on existing dimensions.

CUSTOM DIMENSION VALUE (UDHC)

Product categories Cold Drinks, Fruit Juices, Health Drinks, and Tea can be grouped as “Nonalcoholic Drinks.”

Note:

UDHC is created on front-end data by users and not on cube data (aggregated result set of a cube). It can be used in crosstab, tabular and graphs. 

Please note that a UDHC cannot be used in KPI and GeoMap.

Calculation Priority over Custom Measure: Users can choose the calculation priority among UDDC and UDHC while creating UDHC.

For example:

There is a Custom Measure (UDDC) column created with formula “X” (where X = rowGroupPercentage [Measure]). When users create a Custom Dimension (UHDC) with Formula “Y” (where Y = row 1 + row 2), they can have an option to prioritize the value to be displayed at the intersection cell as per formula X (based on UDDC) OR as per formula Y (based on UDHC).

In the example below for the UDHC “AA,” the UDDC formula is: rowGroupPercentage (GrossSales), and the UDHC formula is: (State_Arizona + State_Arkansas).

INTERSECTION VALUE AFTER SELECTING THE PRIORITY OVER UDDC

In this instance, 76% margin is calculated based on UDHC formula for the year 2014.

INTERSECTION VALUE WITHOUT SELECTING THE PRIORITY OVER UDDC

In this instance, 37% margin is calculated based on UDDC formula for the year 2014.

Note:

If UDDC or UDHC is created from other columns (source columns) in the cube and the user is not granted privileges to access source columns but is granted privileges to access the resultant column, the user will be able to access the resultant column.

For example, if a UDDC “Total_Price” is created by using the expression: Total_Price = Qty * Rate and the user is not granted access rights for Qty and / or Price column but does have rights for Total_Price, the user will be able to access the Total_Price column.

Copyright © 2024 Elegant Microweb Technologies Pvt Ltd