71
3
FIndIng the dIrt: trICks For raPId
PrototyPIng wIth essBase studIo
Mike Nader
CONTENTS
3.1 Introduction 72
3.2 Understanding is Chapter 73
3.2.1 Understanding the Studio Process 73
3.3 Mapping the Data Sources 73
3.3.1 You Do Not Need 39 Dimensions: Working with Text Sources 74
3.3.2 To Change Column Data Type 78
3.3.3 Eectively Leveraging Relational Connections 78
3.3.4 Working with User-Dened Tables 79
3.4 Modeling the Data Source 80
3.4.1 Mini-Schema versus View/Tables 81
3.4.2 Recursive Joins for Parent/Child Hierarchies 84
3.4.3 Automatic Introspection for Full Modeling and Hierarchies 84
3.5 Building Hierarchies and Custom Nodes 87
3.5.1 Capabilities of Functions 87
3.5.2 Creating Custom/Filtered Sets 90
3.5.3 Node Properties versus Deployment Properties 91
3.5.4 Simple Hierarchy Types 92
3.5.5 When to Use the “Measures” Dimension 92
3.6 Modeling and Deploying the Cube 94
3.6.1 Creating a Cube Schema without Metrics 94
3.6.2 Leveraging Open Properties to Validate Dimensionality 97
3.6.3 Incremental Building to Validate Dimensionality 99
3.6.4 Understanding Alternate Data Source Mappings 100
3.6.5 Generating Load Rules and Integrating with MaxL Automation 101
3.7 Additional oughts 104
3.7.1 Stealing SQL 104
3.7.2 To Stream or Not to Stream 105
3.7.3 Considering XOLAP 106

Get Developing Essbase Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.