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 Eectively Leveraging Relational Connections 78
3.3.4 Working with User-Dened 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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
