This section provides you with information and instructions to help you use the Pentaho Metadata Editor, a tool that allows you to build metadata models and domains. There is also an exercise included that walks you through creating a metadata model using a small sample database.
There is sample data available if you want to test Metadata Editor before importing your own data. This sample data is inside of the Pentaho download. This process will be covered later in this section.
Audience: To use the Pentaho Metadata Editor, you must have database administrator (DBA) skills, such as knowing how to import tables, create relationships between tables, assign aggregations, add categories, and assign security as well as an extensive knowledge of your databases. You must also know what type of data interests your business users, in order to determine whether a column should be a measure or a dimension, for example. These skills will allow you to map a business user model (logical model) to a complex relational database, which can then lets your users create Pentaho reports without a DBA's assistance.
See Examining the Default Metadata Model for information about how metadata models are implemented in the Pentaho Server.