Table Window

The Table window provides a tabular view of the relational data used to create a Dimension, displaying the table's structure, columns, and data. In the image below, the upper portion of the screen shows the columns and data, while the lower half displays the multidimensional Dimensions derived from the relational table.

Note


This is what a Dimension Editing Window for relational-based Dimensions looks like. It is also referred to as the "Dimension Editing Window" throughout the help documentation.

Three main parts of the Table window:

• Design Tab
• Data Tab
• Property Grid

Table Window Command Icons

The Table Tab, which becomes available on the OLATION ribbon when accessing the Table window, includes the following commands:

DESIGN Tab

The Design Tab displays details about the columns in the source relational table. Its layout resembles the Design mode of SQL tables. On the left side, a pane lists all column names or fields, along with their corresponding Data Types and whether the Allow Nulls option is enabled. The right side provides information about the properties of the selected column. Additionally, when creating a Dimension from relational tables, this tab can be used to define Dimension attributes.

DATA Tab

The Data Tab displays records in the relational table, which can be added or modified through the Data window.

PROPERTY GRID

The Property Grid displays details about the Dimensions that have been created out of a particular relational table, as well as any additional attributes configured for them. When a Dimension is created from a relational table, this grid appears at the bottom of the Table window. If multiple Dimensions originate from the same table, the grid displays multiple tabs, each labeled with the corresponding Dimension name.

Settings found in this Window:

COMMON:

1. Dimension Name – Displays the name of the Dimension. Rename the Dimensions by typing a new name in the corresponding field.
2. Display Name – The editable display name for the Dimension that will show in a Slice.
3. Dimension Type– Displays the Dimension type of the selected Dimension.  – Allows a user to create a Total Aggregate at the top of the hierarchy that sums up all detail elements.
4. All Hierarchy– Enable this option to create an “All” Member that is a hierarchy/aggregation of all Detail Members.   – Enable this option to create an “All” Member that is a hierarchy/aggregation of all Detail Members.
5. Data Source Type–  Displays the type of data source the relational data is coming from.  – Displays the type of data source the relational data is coming from.
6. Hierarchy Type– Indicates Hierarchy Type, whether Columnar or Parent-Child.  – Allows a user to create a Total Aggregate at the top of the hierarchy that sums up all detail elements.
7. Database Source Type– Relational database and table that is the dimensional logic is coming from.  – Relational database and table that is the dimensional logic is coming from.
8. Total Aggregate – Enable this option (True) to create a Total aggregate Member for defined Hierarchies.
9. Default Member– This is the Member that will appear by default in a report/Slice (PowerExcel, PowerOLAP, etc.) when the Dimension is determined by the Filter function in a newly created Slice. The Default Member name must be typed in.
10. Default Subset– These are the Members that will appear by default in a report/Slice (PowerExcel, PowerOLAP, etc.) in a Row or Column if the Dimension is oriented in a newly created Slice. The Default Subset name must be typed in.
11. Filter – Allows a user to return or include only a specific set of members for the Dimension they are creating. This is similar to the concept of conditional retrieval.
12. Sort Order– Allows a user to define the order of Members in a Dimension via the consequent Sort Order Window.
13. Create Missing Member– Allows a user to create a default Member into which all missing values are inserted.
14. Missing Member Name– Name of Member for missing values—becomes active when (f) is made True.
15. Hierarchies– Allows a user to create a Total Aggregate at the top of the hierarchy that sums up all detail elements.  – Allows a user to create a Total Aggregate at the top of the hierarchy that sums up all detail elements.

MAPPING:

1. Unique Identifier– Allows a user to specify which columns to set as the unique identifier.
2. Member– Allows a user to specify which columns to set as Dimension member. If multiple columns are selected, those columns are concatenated together into the Dimension name.
3. Aliases– Allows a user to specify which columns represent an Alias.
4. Properties– Allows a user to specify which columns represent Properties.
5. Subsets– Allows a user to create a Subset based on data in selected column.
6. Weights– Allows a user to specify Weighting columns in a relational source.
7. Hierarchy– Allows a user to define the Hierarchy structure of a Dimension.

Right-click Menu Options found in Table Window

Shown below are the 'Righ-click Menu options' that can be found in the Table window.