Dimension Value Table

List of Fields in the Table

For each dimension you set up, you can have an infinite number of dimension values. Dimension values are sub-units within a dimension. Dimension values of a similar nature are often gathered within a single dimension. For example, a user might set up the dimension Department with dimension values Administration and Production, both of which are departments.

By attaching dimension values to an entry, a customer, a fixed asset and so on, you label that entity with a particular characteristic. For example, you can record which sales office has sold goods to a particular customer. Through dimensions and dimension values, the user can get an accurate picture of the company's activities and analyze relationships between dimensions and dimension values.

You can also create a hierarchical relationship between dimension values, so that the program will consider some dimension values as subsets of another dimension value.



© 2009 Microsoft Corporation. All rights reserved.