Tour the Data Source Model Editor

Pentaho Business Analytics

Version

10.1.x

Audience

anonymous

Part Number

MK-95PDIA004-17

When you first open the model editor, the center pane of the dialog box displays the active model. This model is organized into categories and fields that represent the tables and columns in your data.

Item	Name	Function
1	Available pane	Displays a list of the available tables and columns of the data source.
2	Analysis / Reporting model pane	Displays the active data source model.
3	Properties pane	Displays the properties associated with a selected category or field.

Analysis toolbar tasks

Icon Name	Function	Definition
Add Measure	Add a measure to the model.	A measure is a property on which calculations can be made, such as a sum, count, or average.
Add Dimension	Add a dimension to the model.	A dimension is used to provide filtering, grouping, or labeling capabilities. A dimension is related to fact data, and is typically something like a product model, color, size, geographic location, salespeople's names, or a unit of time.
Add Hierarchy	Add hierarchies to a dimension.	Hierarchies organize data by strict ranks.
Add Level	Add levels to a hierarchy.	A level is a set of objects within a hierarchy that have the same rank or importance.
Add Member Property	Add custom member properties to a level.	Member properties are the attributes of a level.
Move Up / Down	Move levels up and down in a hierarchy.	Moving levels up and down allow you to change their ranks within the hierarchy.
Remove field	Removes a field from the model.	n/a
Clear Model	Clears the entire model.	n/a

Reporting toolbar tasks

Icon Name	Function	Definition
Add Category	Add a category to the model.	A category is a structure that contains objects that are linked.
Add Field	Add a field to a category.	A field is the place where data is stored within a category.
Move Up / Down	Move levels up and down in a hierarchy.	Moving levels up and down allow you to change their ranks within the hierarchy.
Remove field	Remove a field.	n/a
Add Member Property	Add custom member properties to a level.	Member properties are the attributes of a level.
Clear Model	Clears the entire model.	n/a