Data for attribute relationships is typically treated as text (alphanumeric characters) in Stratum views, unless they are specifically designated to be treated as numbers. That can be done at the application level by administrators, as described in the Dimension maintenance section of help, or by any user in their individual views. See the steps below for changing settings within an individual view.
1. In the view where the attribute relationship exists, right-click and choose Properties from the menu that displays.
2. In the Data Type drop-down selection list of the Properties window, select Number.
3. Click OK in the Apply Changes window and save the view.
Here’s a few other things to consider about this property. The type of information communicated by an attribute relationship and how you want it displayed in views and treated by sorts and filters helps you decide when to treat attribute relationships as numbers instead of text.
If the attribute relationship conveys numerical data and its values consist of all numeric characters, consider setting their Data Type property to Number. Commodity codes or pricing data are examples of numerical data.
If you want an attribute relationship’s values to be treated as numeric for sorts and filters and displayed right aligned in a view’s columns (like measure item values) and for exports to Excel that are set to be Excel Report output types, then set their Data Type property to Number.