Skip to main content
Pentaho Documentation

Creating Attributes

An attribute is used to create a single level hierarchy, using either a field or existing hierarchy level. As part of the Annotate Stream step, you can create an attribute or series of attributes to further refine your data model.

To Create an Attribute on a Field

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

  1. If you haven't done so already, complete steps 1-7 in Using 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.CreateAttributeSDR.png

     

  3. Enter or edit the value for each annotation component.
    Property Description
    Attribute Name Enter a name for your attribute. This is a required field.
    Time Level Type For 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.
    Geo Type For geo attributes, specify the geo type from the drop-down menu. Options may include:
    • Lat_Long
    • Country
    • City
    • State
    • County
    • Postal_Code
    • Continent
    • Territory
    This is a required field for Geo Type attributes.
    Ordinal Field Select a field to use for sorting members in ascending order. For example, months will display in chronological order, e.g. January, February, etc.
    Description Enter a description for the attribute. This description is visible when a user mouses over an attribute in Analyzer.
    Parent Attribute If 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.
    Dimension Select an existing dimension or create a new dimension for the attribute. This is a required field.
    Hierarchy Select 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.

    • 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.