Database Reference
In-Depth Information
Figure 3.28
Faked Measures table.
Figure 3.29
Specifying dimensions with a faked Measures table.
3.6.1.1 Loading Data External to Studio
After the metadata is in place, your next deci-
sion is how to load the data. From a data load perspective, a cube built using Studio via
the Cube Deployment Wizard or directly from a numeric data source is like any other
Essbase database. It is only natural to question why you would load data external to
Studio after leveraging Studio to build the dimensionality. The answer is: Control.
When loading data with Studio you have the option of writing custom data-load
SQL. This is good, assuming you are leveraging a relational source, but not always ideal.
