Unit Characteristics: Unit characteristics provide a means of key figures values, stores currencies or units
of measure.
Example: Currency unit (0CURRENCY) Holds the currency of the transaction ($, EUR, and so on)
Value unit (0UNIT) Hold the unit of measure (Gallon, Inch, cm, PC)
Colon (:) – Colon is used to authorize access to aggregate data. For example, a person with : for 0COSTCENTER would be able to see aggregate data for all cost centers (cost center in the free characteristics section of the query) but would get an authorization error when trying to drill down on 0COSTCENTER
.Colon (:) authorization is also needed for all authorization relevant characteristics which are not used in a query.
Hash (#) – While loading data into cubes, there might be some fields for which no values are maintained in the data source. Hash is used to authorize these undefined values as otherwise a full acces (*) would be needed for them.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.