Dimension Attributes

Dimension attributes are characteristics or properties that define the various aspects or qualities of a specific dimension in a database. These attributes help users to slice, filter, and analyze data to gain insights into sales trends, product performance, or regional variations.

You can create and handle dimension attributes in Modeler > Dimension Properties > Attributes. This example uses the Products dimension in the Demo database.

  1. In the Products Dimension Properties tab, go to the Attributes section.

    Modeler screenshot

  2. Click the +Add attribute button to add a new attribute. A new row is added to the table. For each attribute you can define the following:
    AttributeThe name of the attribute (alphanumeric)
    TypeThe type of the attribute (string or numeric)
    DescriptionA description of your attribute (alphanumeric)
    DomainAllows you to assign a constraint to the attribute. The following options are available:

    Boolean

    IntegerRange - prompts you to select a minimum and maximum value.

    Float Range - prompts you to select a minimum and maximum value.

    Date Range - prompts you to select a starting and ending date (MM/DD/YYYY) from a date picker.

    Time Range - prompts you to select a starting time and an ending time from a time picker.

    Date & Time Range - prompts you to select starting and ending references for both time and date.

    Year & Month Range - prompts you to select a starting and ending date (YYYY/MM) from a date picker.

    List of values - prompts you to define a list of values as well as enable the use of empty and arbitrary values.

    Subset - prompts you to assign all/base/consolidated elements of a subset, a list of dimensions or cubes or a custom subset.

    Stored Subsets - prompts you to select from a list of stored subsets, if they are available.

    Default ValueThe entry used when you add new elements in the Elements tab.
    VirtualFlags the attribute as Virtual Dimension.

 

Example 1

In this example, we are adding the attribute “GPU” to the Products dimension.

  1. Add the following entries:
    Attributes setup dialog
  2. Click Update. The attribute is now added to the dimension.
  3. Go to the Elements tab and expand the list of elements. A new column with the new attribute allows you to select the products that contain a GPU.
    Elements in Modeler screenshot

Example 2

In this example, we are adding the attribute “Price” to the Products dimension.

  1. Add the following entries:
    Attributes setup screenshot
  2. Set a float range with values between 2-60000 as a type:
    Attribute Domain dialog
    Note: In this version, Float range allows decimal numbers, but in this dialog you can only enter integers.

The specified range will only be supervised if you make entries in Modeler > Products > Elements:
Sample Modeler screenshot

If you make entries in a Jedox View with Excel Add-in or with Jedox Web, they will not be monitored.

To delete an attribute, select it from the list and click then the bin icon:
Attributes sample

To edit the entries of an existing attribute, double click the corresponding row.

Furthermore, it is also possible to modify multiple attribute values in the elements grid at once. To do so, select the cells for which you want to modify the value and press the F2 key. The input will be displayed for the last selected element, but the set value will be defined for all selected elements. You can cancel this operation by pressing the ESC key.

Updated April 4, 2024