Create and Refine Advanced Data Models
- Optimize Multidimensional Data Models
- Learn the instructions and recommendations for designing aggregate tables to dramatically improve the query performance of analysis solutions.
- Work with Multidimensional Data Models
- As a BA administrator, learn how you can prepare your data for use with the Pentaho Analyzer and Pentaho Report Designer.
- Introduction
- OLAP Defined
- Pentaho Analysis Enterprise Edition Features
- Workflow Overview
- Dimensional Modeling
- Testing With Pentaho Analyzer and Report Wizard
- Prototype With Data Integration
- Create and Modify Mondrian Schemas
- Analysis Schema Security
- Configure Analysis Options
- Mondrian Cache Control
- Visualize Your Data
- Log Output
- Troubleshooting
- Mondrian Schema Element Quick Reference
- Work with the Streamlined Data Refinery
- Create a single data refinery by streamlining all of your data sources through a central processing hub.
- Work with Relational Data Models
- Learn the benefits and ins-and-outs of using the Pentaho Metadata Editor, a tool that allows you to build metadata models and domains.
- About this Section
- Knowledge Prerequisites
- A Conceptual Overview of the Pentaho Metadata Editor
- Examine the Sample Metadata Model
- Create a New Domain
- Enrich Your Data — Understanding Metadata Concepts and Properties
- Metadata Security
- Add Security to Metadata Business Objects
- Add Row Level Security to a Pentaho Metadata Model
- Configure and Manage International Locales
- Import and Export Domains
- Domain Backup and Recovery
- Metadata Properties Reference
- Pentaho Metadata Formulas
- Troubleshoot Report Designer
Overview
Follow step-by-step instructions for refining the Pentaho relational metadata model and the multi-dimensional Mondrian data model. These sections are helpful if you are a data designer, data scientist, or developer.