Attribute relationships provide supplementary, descriptive information about levels. For example, a Customer level may have members (Customers) with attribute relationships such as address, contact person, long description, phone number, and region.
Attribute relationships can be used in several ways, such as displayed on rows and columns of views, used for filtering purposes, and used to build user list expressions. They are also used as display columns and for searching purposes in the Select and Advanced Select Members windows.
Attribute values are controlled either on the corporate side of things in Stratum.Server or using Stratum.Viewer’s Master Data Import functionality. Both types can be used in the same way in Viewer and look the same to the end user who is working with them in views, filters, and so on.
Corporate Controlled Attribute Relationships – Their values originate from your Corporate business systems and are stored in your Stratum.Server database. They can be selected for use and maintained in Stratum.Connector. Change their names, create hierarchies from them, and select or deselect them to control availability in Viewer.
User Controlled Attribute Relationships – Their values originate from an Excel spreadsheet and become part of Stratum using Stratum.Viewer’s Master Data Import functionality. Use Stratum.Viewer’s User Controlled Attribute Maintenance functionality to define attributes, maintain attribute properties, create or remove hierarchies based on the attributes, or delete the attributes. In Connector, you can view their properties including seeing any hierarchy created from the attribute. See the Master Data Import and User Controlled Attribute Maintenance section of help for complete information about those features.
Note: User Controlled Attribute Maintenance functionality is only available for implementations running Stratum.Server on a Windows SQL server. It is not available for implementations running Stratum.Server on an IBM i Server.