Tic computacion

The Pentaho Analysis Guide

This document is copyright © 2011 Pentaho Corporation. No part may be reprinted without written permission from Pentaho Corporation. All trademarks are the property of their respective owners.

Help and Support Resources
If you have questions that are not covered in this guide, or if you would like to report errors in the documentation, please contact yourPentaho technical support representative. Support-related questions should be submitted through the Pentaho Customer Support Portal at http://support.pentaho.com. For information about how to purchase support or enable an additional named support contact, please contact your sales representative, or send an email to sales@pentaho.com. For information about instructor-led training on thetopics covered in this guide, visit http://www.pentaho.com/training.

Limits of Liability and Disclaimer of Warranty
The author(s) of this document have used their best efforts in preparing the content and the programs contained in it. These efforts include the development, research, and testing of the theories and programs to determine their effectiveness. The author and publisher make nowarranty of any kind, express or implied, with regard to these programs or the documentation contained in this book. The author(s) and Pentaho shall not be liable in the event of incidental or consequential damages in connection with, or arising out of, the furnishing, performance, or use of the programs, associated instructions, and/or claims.

Trademarks
Pentaho (TM) and the Pentahologo are registered trademarks of Pentaho Corporation. All other trademarks are the property of their respective owners. Trademarked names may appear throughout this document. Rather than list the names and entities that own the trademarks or insert a trademark symbol with each mention of the trademarked name, Pentaho states that it is using the names for editorial purposes only and to thebenefit of the trademark owner, with no intention of infringing upon that trademark.

Company Information
Pentaho Corporation Citadel International, Suite 340 5950 Hazeltine National Drive Orlando, FL 32822 Phone: +1 407 812-OPEN (6736) Fax: +1 407 517-4575 http://www.pentaho.com E-mail: communityconnection@pentaho.com Sales Inquiries: sales@pentaho.com Documentation Suggestions:documentation@pentaho.com Sign-up for our newsletter: http://community.pentaho.com/newsletter/

Contents
Introduction............................................................................................................... 6
ROLAP Defined........................................................................................................................6 WorkflowOverview...................................................................................................................6

Preparing Your Data................................................................................................. 8 Dimensional Modeling.............................................................................................. 9
Virtual ROLAPCubes...............................................................................................................9

Prototyping With Pentaho Data Integration............................................................ 12
Creating a Prototype Schema With a Non-PDI Data Source................................................. 12 Creating a Prototype Schema With a PDI DataSource......................................................... 12 Testing With Pentaho Analyzer and Report Wizard............................................................... 13 Prototypes in Production........................................................................................................ 13

Creating and Modifying Mondrian Schemas...........................................................14
Schema Workbench...