SteelWheels

Walk through of SteelWheels domain ..

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.

Import SteelWheels

The following steps show you how to use an example metadata model in Pentaho Metadata Editor to create an Interactive Reports.

Orders Business Model

1. Start Metadata Editor:

Windows

// Some code

Linux

cd
cd Pentaho/design-tools/metadata-editor/
./metadata-editor.sh

1. Import (open) an existing metadata domain:

2. From the menu, select: File > Import from XMI File

3. Navigate to:

~/Pentaho/design-tools/metadata-editor/samples

1. Double-click: steel-wheels.xmi.

2. In the Save Model dialog, type SteelWheels.

3. Click OK.

Note a domain can only have 1 database connection.

Physical Layer

Business Models

Relationships

Business Views