SteelWheels
Walk through of SteelWheels domain ..
Last updated
Was this helpful?
Walk through of SteelWheels domain ..
Last updated
Was this helpful?
The Pentaho Metadata Editor (PME) is a powerful tool that bridges the gap between raw database structures and business-friendly data models. At its core, PME helps organizations create metadata domains that transform complex database architectures into intuitive business models.
When you create a metadata model in PME, you're essentially building a logical map of your database that speaks the language of business. This model is stored in a central repository, giving administrators several valuable capabilities:
First, they can translate technical database terminology into clear, business-friendly language that makes sense to end users. This makes reporting and analysis more accessible to non-technical staff.
Second, when database changes occur at the technical level, the metadata layer acts as a buffer, minimizing disruption to business users and reducing maintenance costs.
The tool also enhances data governance through security controls that precisely manage user access to specific data elements in reports. Additionally, PME streamlines report maintenance by establishing consistent formatting rules for text, dates, and numbers across the organization.
For global organizations, PME supports localization, automatically adjusting how information is presented based on users' regional settings.
The metadata domain created by PME consists of two key components: the physical layer, which contains the technical database structure definitions, and the business model layer, which provides an abstracted, business-oriented view of that data. Together, these layers create a comprehensive framework that makes complex data structures more accessible and manageable.
The following steps show you how to use an example metadata model in Pentaho Metadata Editor to create an Interactive Reports.
Start Metadata Editor:
Windows
// Some codeLinux
cd
cd Pentaho/design-tools/metadata-editor/
./metadata-editor.shImport (open) an existing metadata domain:
From the menu, select: File > Import from XMI File
Navigate to:
~/Pentaho/design-tools/metadata-editor/samples
Double-click: steel-wheels.xmi.
In the Save Model dialog, type SteelWheels.
Click OK.
Note a domain can only have 1 database connection.
The Physical Layer includes 13 tables.
In the left pane, expand Connections > SampleData.
Expand Products and notice the list of columns.
Double-click on Product Line.
Scroll through the Base settings - Parent Concepts.
Notice most of the Base metadata settings can be overridden. The property - Parent Concept - will be inherited in the Business Models and Business Views Layers.
Expand > Orderdetails table.
Double-click on Total.
If you have a requirement to create dimensions / measures for Interactive Reports that desn't exist in the Physical tables, then you can easily create the column based on existing columns.
Scroll through the Base settings.
Notice the column is based on the calculation:
[QUANTITYORDERED]*[PRICEEACH]
The columns are referenced with [COLUMN]
This can be aggregated to: Sum, Average, Minimum & Maximum.
There are three Business Models within this metadata domain. Each model uses one or more tables from the physical layer.
Collapse Connections and expand Business Models.
Expand the Orders Business Model.
The Orders Business Model includes five Business Tables:
Customer W Ter
Orders
Orderdetails
Products
Payments
The Business Model Layer is where you overide and set the Parent Concept to be inherited in the Business View Layer.
Expand the Orderdetails Business Table.
Double-click on Price Sold.
Notice a 'Mask for Number or Date' has been added and the value set as a Parent Concept. The Mask - $#,##0.00 format - will be inherited in the Business View Layer.
Once you have all your Business Tables created, you will need to create relationships between the tables, so that the query generators and SQL generators that work with Pentaho metadata can create the data queries correctly.
This is very much like drawing a relational diagram to show primary and foreign key relationships. Although relational links are not the only relationships that can be modelled. You can create a relationship between any two tables, link any two columns between them and dictate what the relationship is (one to many, many to many, etc.).
The important pieces of information to know before you try to create a relationship is:
what two Business Tables would you like to associate with this relationship?
what columns in the business tables identify the relationship?
and what kind of relationship is it - one to one, one to many, many to one, etc?
Business Views acts as 'buckets - categories' that enable you to define the sematic layer that is exposed to the end user. Each Category can contain any column(s) that have been defined in the Business tables.
Expand: Business View > Orders
Highlight Orders category.
Right-mouse click and select the option: manage Categories.
The Panel enables you to associated the Business Column(s) with the Category.
