Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Creating attributes

Parent article

An attribute is used to create a single level hierarchy, using either a field or existing hierarchy level.

Create an attribute on a field

These steps guide you through creating an attribute using the Annotate Stream step.

Procedure

  1. If you have not done so already, complete steps 1-7 in Use the Annotate Stream step.

  2. Select Create Attribute from the Actions menu.

    The Name - Value table auto-populates with a list of annotation properties for the attribute.Create an attribute
  3. Enter or edit the value for each annotation component.

    PropertyDescription
    Attribute NameEnter a name for your attribute. This is a required field.
    Time Level TypeFor time level attributes, specify a time level type from the drop-down menu. Options may include:
    • TimeYears
    • TimeHalfYears
    • TimeQuarters
    • TimeMonths
    • TimeWeeks
    • TimeDays
    • TimeHours
    • TimeMinutes
    • TimeSeconds
    This is a required field for Time Level attributes.
    Time Source Format

    For time level attributes, specify a time format for the attribute to appear in. Options are dependent on the selected time level type. For example, if you select TimeYears in the Time Level Type field, then you can only select yyyy or yy in the Time Source Format field. This is a required field for Time Level attributes.

    See Date Formatting Table for more information on selecting the appropriate format.

    Geo TypeFor geo attributes, specify the geo type from the drop-down menu. Options may include:
    • Location
    • Country
    • City
    • State
    • County
    • Postal_Code
    • Continent
    • Territory
    This is a required field for Geo Type attributes.
    Latitude

    If you select a Geo Type of Location, select an existing value from the drop-down menu.

    If you do not select values for Latitude and Longitude, then the system will attempt to assign approximate values for these two fields.

    Longitude

    If you select a Geo Type of Location, select an existing value from the drop-down menu.

    If you do not select values for Latitude and Longitude, then the system will attempt to assign approximate values for these two fields.

    Ordinal FieldSelect a field to use for sorting members in ascending order. For example, months will display in chronological order, such as January, February, etc.
    Format

    Choose how this attribute should be formatted, such as currency, general number, percentage, or date. Use the drop-down arrow to select a format from a system-defined list, or type in the field to enter a custom format. For example, to display the attribute as a simple date, you might select MM/dd/yy. Note that the Format field only displays when the value for the attribute is a number or a date.

    See Format field options for more information on selecting the appropriate format.

    DescriptionEnter a description for the attributes. This description is visible when a user mouses over an attribute in Analyzer.
    Parent AttributeIf you want to create multi-level hierarchies, select a parent attribute for the attribute you are creating. This relationship will display in the Summary column for the annotation on the Annotate Stream dialog box. For example, if you are working with Month, then you can select Year as the parent attribute. Double-clicking Year in the model displays Months.
    DimensionSelect an existing dimension or create a new dimension for the attribute. This is a required field.
    HierarchySelect an existing hierarchy or create a new hierarchy for the attribute. This field may be left blank.
    Is Unique

    Set to True when member names do not repeat under different parents. Setting this field to True will optimize SQL generation in Mondrian.

    Set to False when member names may repeat under different parents.

    Hidden

    Set to True to prevent this attribute from displaying as an available level in Analyzer. When set to True, this attribute is included in the model, but is not visible to users when the model is published and opened in Analyzer.

    Set to False to allow this attribute to display as an available level in Analyzer. When set to False, this annotation is visible to users when the model is published and opened in Analyzer.

    The Hidden property is useful for attributes needed to build a proper data model, but not needed for analytic purposes. For example, if you are in a multi-tenant environment, you may want to hide the Tenant ID attribute while still including it in the data model.

    • For all annotations, enter the Attribute Name and select the Dimension type. Optionally, you can enter an ordinal field, write a description, choose a hierarchy, and designate if the attribute Is Unique.
    • For Time Level attributes, select a Time Level Type, a Time Source Format, and optionally set a parent attribute if you want to create a relationship between two time attributes.
    • For Geo attributes, select a Geo Type and optionally set a parent attribute if you want to create a relationship between two geo attributes.
  4. Use the Previous and Next buttons to navigate through the fields. When finished, click OK to add the attribute to the annotations list or Cancel to close the dialog box without saving your annotations.