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. The
Maintenenace cube contains additional sites Organization Site, Source Site, Actual Object Site
and Reported Object Site with corresponding prefixes Source, Act Obj and Rep Obj
respectively.
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 |
SiteHy |
YES |
Defined as "Company" -> "Site" |