OLAP Dimension Dialog Box

Use this dialog box to display all levels in the dimension, including the underlying tables and fields associated with them. In addition, this dialog box displays additional properties of the level and any OLAP properties associated with it.

Selecting Enable SQL on the Data Connection tab of the <Project > Properties dialog box enables you to edit the Table and Field columns.

Options

Date dimension

Indicate that the dimension is of a date and/or time type.

Level, Table, Field

Display the Tables and Fields underlying the specified level.

If a table or field cell contained None when you imported an OLAP cube, English Query was not able to access the fields that underlie the OLAP levels and SQL text could not be generated.

Capitalization

Specify the case in which the data was entered (for example, all lowercase, initial caps, and so on). If you do not know how the data was entered or the data is inconsistently capitalized, select Unknown.

For all values of Data Capitalization other than Unknown:

Regardless of how the user types in the data value in the question, the SQL statement generated by English Query matches the data capitalization values. For example, if the user asks, "Who sold the most widgets?", and the data capitalization on the product_name field is "UPPERCASE", then the SQL statement will contain "product_name = 'WIDGET'". An exception to this can occur when the values of product_name are loaded into the model. If there are any data values that violate the capitalization convention, these are memorized so that the correct capitalization will be used in the SQL statement.

For data capitalization that is unknown:

The capitalization in the SQL statement generated by English Query matches the user's capitalization exactly, whether or not the data values have been loaded into the model. For example, if the user asks, "How many awards did Gone With the Wind win?", the SQL statement is movie_name = 'Gone With the Wind'. When users are unlikely to know the correct capitalization to use, pick the closest data capitalization value other than Unknown, and load values of the entity into the model so that all capitalization is memorized by English Query.

Date Type

Specify the date type of the data in the level, if any. Available only if the field representing the level is of date, string, integer, or float data type.

None: Specify that the date type is unknown.
Integer Year, Integer Month, Integer Quarter, and Integer Day: Specify that the year, month, quarter, or day is a number (for example, 2000).
2 Digit Year: Specify that the date uses the last two digits of the year (for example, 99).
3 Letter Month or Month Name: Specify that the level contains a month in string format (for example, Mar). Not available for integers.
Quarter Name: Specify that the level contains a quarter in string format (for example, First Quarter). Not available for integers.

Name Structure

Specify the type of name data contained in the level, if any. In the last two selections, [Middle] indicates that the middle name is optional. If the structure does not match any of the options, click None.

Note You can identify a Name structure of the level if the data type of the field associated with it is a string data type. If the field representing the level is a date, string, integer or float data type, a date data type can be associated it.