Database Reference
In-Depth Information
3
FIndIng the dIrt: trICks For raPId
PrototyPIng wIth essBase studIo
Mike Nader
Contents
3.1 Introduction
72
3.2
understanding This 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
Effectively Leveraging relational Connections
78
3.3.4
Working with user-Defined 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 Thoughts
104
3.7.1
Stealing SQL
104
3.7.2
to Stream or not to Stream
105
3.7.3
Considering xoLAP
106
71
