This cube dimension represents sites (contracts) and
is based on the IFS Applications dimension DIM_SITE. All cubes that refers to
this dimension will have the attributes and hierarchies as described below.
| Attribute |
Hierarchy |
Description |
| Company |
NO |
Defined as COMPANY + ' - ' + NAME + ' (' + CURRENCY_CODE
+ ')', i.e. the company identity and name as well as the base currency
code. |
| Company Code |
NO |
The identity of the COMPANY referenced by the a site
(contract). |
| Company Name |
NO |
The NAME of the company references by the site. |
| Site |
NO |
Key. Defined as CODE + ' - ' + DESCRIPTION, i.e. site
and its description. |
| Site Code |
NO |
The CODE of the dimension, i.e. site |
| Site Description |
NO |
The site DESCRIPTION |
| Site Description Code |
NO |
Defined as DESCRIPTION + ' - ' + CODE, ie. site
description and the site |
| Hierarchy |
YES |
Defined as "Company" -> "Site" |