Unbounded and Bounded Attribute Data Types

Dimension Attribute Data types can be either bounded or unbounded. The Date, String, and Number types are unbounded, that is, there is no predetermined set of attribute values. A Date attribute value can be any valid date, a String attribute value can be any string up to 30 characters in length, and a Number attribute value can be any number. Examples of these kinds of attribute data types can include:

  • Cost Center Open Date (a Date attribute on the Organizational Unit dimension).
  • Product Memo (a String Attribute on the Product dimension).
  • Cost Center Headcount (a Number attribute on the Organizational Unit dimension).

Unlike attributes having the Date, String, or Number data type, attributes whose data type is Dimension have defined sets of values. For example, the Product dimension has a seeded attribute called Accrual Basis and the data type is Dimension. The Accrual Basis dimension is seeded with eight values. Accrual Basis is a restricted dimension (you can View Accrual Basis dimension members, but you cannot delete them or add new accrual bases), but whenever you assign an Accrual Basis attribute value to one of your Product dimension member values, you must select from the list of eight available Accrual Bases.