This is an optional enhancement that adds the ability to do the following:
- Create Hierarchical menus (by Attributes)
- Search, Sort, Subset, and Select Elements (rows) by Attributes
- Add Subtotals of Elements by Attributes or Attribute combinations (with Calculations)
To simplify database creation select 'Add No Dimensional Attribute Fields'
on the 'MDA Database Output Specifications'
Dimensional Attributes are values associated with a Dimensional Element. For instance, if the dimension were a list of Cities, each city in the list would be an Element of that dimension. An Attribute Field might be the State field, or also a Size field, or some other Element Table 'Attribute' Field that might be considered an Attribute of the Cities Dimension.
After the above selections are made, and the user clicks the 'OK' button, the user has the option to possibly add Attributes to the Dimensional Fields selected. To be an Attribute of a dimensional element, requires that all occurrences (rows) with a particular dimension field value have only one distinct attribute value in the attribute field.
This results in each element value in the Dimensional Field having a definite
and distinct value in the Dimensional Attribute Field.
When an Attribute Field has only one distinct value for each distinct value in a Dimensional Field, that Attribute Field is considered to be a 'Qualifying Dimensional Attribute Field' for that particular Dimensional Field.
The Dimensional Attribute Field Options:
There are currently four options available for Dimensional Attribute Field processing.
They are as follows:
- Add No Dimensional Attribute Fields
- Add All Qualifying Dimensional Attribute Fields
- Add Selected Qualifying Dimensional Attribute Fields
- Add Selected Dimensional Attribute Fields (with or without Qualifying) (use first value encountered)
The first option adds no Attribute Fields to any of the Dimensions and in effect turns the option off.
The second option instructs the program to find all Qualifying Attribute Fields for each dimension, and add them to the dimensions where they qualify.
The third option asks the user for each dimension, whether or not they want to possibly add Dimensional Attributes to that dimension.
If the user answers yes to a particular dimension, then the program determines if any Element Table Attribute Fields qualify as possible Dimensional Attribute Fields for that dimension. If there are any, then the user is presented with a menu of qualified Dimensional Attribute Fields that can be selected. The selected Attributes are then added to that particular Dimension.
The fourth option presents the user, for each dimension, with a menu of all Dimensional Attribute Fields that can be selected. The selected Attributes are then added to that Dimension. Since the Attribute values for a Dimensional Element may not be unique in this case, the first value encountered is used for the Dimensional Attribute Field value.
The terms Element Table Attribute Field, and Dimensional Attribute Field are different perspectives and usages of the data column in the orginal Data Table. Each Field in the Element Table is an Element Table Attribute Field. Of those fields, a subset may qualify as Dimensional Attribute Fields for a Field selected as the Dimensional Field.
Dimensional Attribute - Qualifying Dimensional Attribute Fields - Examples:
If the rows represented sales, with each row being the sale of a particular item, one field could be the city where the item was sold, and another field could be the state where the item was sold. All rows with the value of 'Pittsburgh' in the city field would have the value of 'Pennsylvania' in the state field. Therefore 'Pennsylvania' could be an attribute of 'Pittsburgh'.
Another example given the same Element Table with the sales items, could exist for a Brand item, and the Manufacturer of the Brand item. All occurrences of the sales of a particular Brand item would have the same value in their Manufacturing field. For instance, Brand item 'Mustang Model xxx' would all have the Manufacturer of 'Ford'. If not, the Manufacturer field would not qualify as a possible Attribute of the Brand item field, and therefore would not be available for selection in the list of qualified Attribute fields available for selection.
One Data Table Field could be the Code/Order for the dimension, and another Data Table field could be the Title. If the Title field were selected as the Dimension Field, the Code field would qualify as a Dimensional Attribute Field. The Code field could be selected as the Order field for the dimension in the Element Selector, and the Title field could be selected as the Display field once the resultant MDA Database is loaded into MDAccess.
Another example could be as follows: For a given Data (Element) Table, if one of the fields were the Brand item, and another field were the Sales Person field, then the Sales Person field could not be an attribute for the Brand item field if multiple sales people made sales for the same Brand item. Alternatively, the Brand item field could be an Attribute of the Sales Person field if each Sales Person only sold one particular item.