The Dimension Builder in BFC Application provides a location for defining and managing meta data which is used to clearly identify the amounts collected in the application. The Dimension Builder view appears in the Setup domain.
The Dimension Builder view presents the following:
Data Sources: Classification of the values for which dimensions and characteristics are created. This data classification is segregated into two major groups:
a. Amounts: It contains all of the dimensions used to identify reporting amounts.
b. Rates: It contains the dimensions used to identify conversion and tax values.
Reference tables: A reference table is where a group of values used to classify the data is stored. These groups are used as dimensions and characteristics.
There are two types of reference tables:
a. Product reference tables. These are predefined in the software and cannot be deleted. The icons are represented in orange color
b. User-defined reference tables. These are created as needed by user’s business functions. The Icons are represented in Blue color
There are four setup modes available in the Dimension Builder:
a. Definition Mode is used to create and define dimensions, characteristics, and reference tables.
b. Load Data Mode is used to add, view, and change the Dimension and Characteristic values (metadata).
c. Filters Mode enable you to create and manage filters which can be used to select groups of dimension or characteristic values for reporting purposes or for use in calculations.
d. Hierarchy Mode presents the reference values and characteristics of a dimension in a hierarchy.