Smart Attributes

Smart attributes represent different intervals of time, allowing you to easily create a complete time hierarchy without a need to create separate attributes for each dimension, maintaining hierarchy and relationships between them.

Activating time zone awareness to create smart attributes is not required. While these two features compliment each other, you can use them separately. A smart attribute's base attribute must have TimeStamp data type. A base attribute can have additional forms. If you are upgrading existing attributes to include smart attributes, all relationships are removed for the base attribute.

Interval periods are fixed and cannot be changed. The editor allows you to change sorting behavior for each smart attribute, as well as each smart attribute name. By default, the name is [base attribute name] ([interval duration]). Fifteen minute smart attributes are always created if higher intervals are created. Strategy automatically creates relationships between base attributes and all smart attributes.

The Attribute Editor for a specific base attribute is the only place where smart attributes can be created, edited or deleted.

To use this feature, Strategy must create managed tables in your database.

Create Smart Attributes

In the Navigation pane, click Objects.
Click Create New Object.
Select Attribute.
Enter an attribute Name.
Choose a Type.
In the table header, click Add New Form.
Select a table and column with the appropriate data type.
Click Done.
Click the Smart Attributes tab.
Select the desired intervals.
Click Save, Save and New, or Save and Close.
Update your schema to view the changes.