Unique
Type
Constant String ('true', 'false' or 'auto')
Since
2.0
Description
An attribute of a dimension can be a unique attribute. Only unique attributes can be used in cubes to map dimension via this attribute (e.g. a cube could map the dimension "Product" with the unique attribute "ProductID" to a column "PRODUCT_ID" of the fact-table). If an attribute is unique, only one key per dimension may have a specific value stored in this attribute - e.g. it would be forbidden to have two different keys with the same "ProductID".
There are two different ways to define that an attribute is unique:
- Set the property "Unique" to true: The attribute is expected to be unique. If the same attribute-value is loaded for two different keys, the loader will raise an error and stop loading the model.
- Set the property "Unique" to auto: The loader will automatically find out, if the attribute is unique. This is a bit dangerous, because a unique attribute could become non-unique later and some cube-mapping couldn't work anymore.
If you set the property to false, the attribute won't be unique. Note that unique attributes use a bit more system-resources, so you should avoid to have unique attributes unless you want to use them for mapping cubes.
Examples
Unique = "true"
Unique = "false"
Unique = "auto"
