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 ...