Database Reference
In-Depth Information
Figure 2.8
INT_ExtractAge Interface.
Figure 2.9
Package PKG_Extract_ASOsamp.
If you got excited by the dimension name constant in the target, e.g., Age, geography,
etc., do not bother; you are stuck with setting up each dimension separately as each
Interface is inextricably linked to a physical Essbase dimension as shown in the source
pane on the left. After something as important (and permanent) as that is put into play, a
mere string constant is not material. Alas, this is how oDI works when it comes to revers-
ing Essbase dimensions short of programmatically generating Interfaces through code.
This is an advanced book, but not that advanced. This object-based approach is used
for reversing dimensions because of its ease; the other components of this solution use
more flexible approaches. And, if you can figure out a way to generalize this extraction
portion, please let me know (contact information is on page x).
Compiling the individual Interfaces to Scenarios and then linking them together in
a Package, as shown in Figure 2.9, allows all of the dimensions to be extracted to the
Dimensions table.
