Office

Used as the core source for loading the Office dimension, which maintains a list of the offices for the organization.  For the purpose of the Planning application, if organizations and locations are separate segments in the general ledger, the Office dimension is essentially a combination of organization and office location.

Idx Field Type Maximum Length Required
1 Office_Code Alphanumeric 20 Yes
2 Office_Name Alphanumeric 50 Yes
3 Currency_Code Alphanumeric 3 Yes
4 Office_Rollup_1 Alphanumeric 50 No
5 Office_Rollup_2 Alphanumeric 50 No
6 Office_Rollup_3 Alphanumeric 50 No

 

Summary

Office

Used as the core source for loading the Office dimension.

Columns

 

Office_Code

Code that uniquely identifies this Office dimension record. Required.

Office_Name

Description of the office.  This is used to create the Office member. Required.

Currency_Code

Used in supporting multi-currency, this is the primary currency for the office; must match value in Currency file.   Required.

Rollup Columns

 

Office_Rollup_1

Top level hierarchy the office rolls into for reporting purposes. Optional.

Office_Rollup_2

Second level hierarchy the office rolls into for reporting purposes. Optional.

Office_Rollup_3

Third level hierarchy the office rolls into for reporting purposes. Optional.

Documentation

 

Sample CSV Load File

This load file is a small sample of an Office load.

Sample CSV Load File

This load file is a small sample of an Office load.

Filename: Office.csv

01,New York,USD,,,
30,Hartford,USD,,,
41,London,GBP,,,
58,Pittsburgh,USD,,,
90,Washington,USD,,,

Columns

Office_Code

Office_Code varchar(

20

) NOT NULL

Code that uniquely identifies this Office dimension record. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 20
Required Yes

Office_Name

Office_Name varchar(

50

) NOT NULL

Description of the office.  This is used to create the Office member. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 50
Required Yes

Currency_Code

Currency_Code varchar(

3

) NOT NULL

Used in supporting multi-currency, this is the primary currency for the office; must match value in Currency file.   Required.

 

Examples

USD

US Dollar

EUR

Euro

GBP

Pound Sterling

KZT

Kazakhstan Tenge

RUB

Russian Ruble

ZAR

South African Rand

 
 

 

Field Load File Format
Type Alphanumeric
Maximum Length 3
Required Yes

Rollup Columns

Office_Rollup_1

Office_Rollup_1 varchar(

50

) NULL

Top level hierarchy the office rolls into for reporting purposes. Optional.

Records may be grouped into multiple rollups each separated by a separate rollup column.  Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level one.

Office_Rollup_2

Office_Rollup_2 varchar(

50

) NULL

Second level hierarchy the office rolls into for reporting purposes. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level two.

Office_Rollup_3

Office_Rollup_3 varchar(

50

) NULL

Third level hierarchy the office rolls into for reporting purposes. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level three.

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk