Create and Refine Advanced Data Models
- Optimize Multidimensional Data Models
- As a database administrator, learn the instructions and recommendations for designing aggregate tables for Mondrian ROLAP models. The use of aggregate tables can 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
- Use Pentaho Mobile
- Get immediate access to powerful business analysis at any time with Pentaho Mobile, an innovative application built specifically for the Apple iPad. Touch navigation technology enables you to access content with the tap of a finger.
- 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.