Database Reference
In-Depth Information
Table 2.1 Technology Pr erequisites
Technology
Prerequisites
Essbase
•  Familiarity with ASosamp.Sample
•  Data load rules
•  Dimension load rules
•  report scripts
maxL
•  Data loads
•  Dimension loads
•  Parameter variables
SQL
•  Simple InSErt and SELECt statements
oDI
•  Interfaces
•  Packages
•  Data models
•  Designer
•  operator
2.1.2 A Note about the Examples
2.1.2.1 Too Hot, Too Cold, Just Right When building the technical examples for this
chapter, I struggled quite a bit with the completeness of the solutions. Should a given
example provide the most bulletproof, fully featured, chrome-laden solution to a prob-
lem or should it instead provide an answer that is purposely simple to clearly illustrate
the concept, even if it is missing some of the completeness needed in the real world?
I went with the latter approach. my hope is that you will read this chapter, look at the
code, and think: “yeah, that's interesting, but he should have done x to show y.” That
will mean that the concept has hit home and your brain is already absorbed in making
it better. If that is the result then great, I have done my job.
2.1.2.2 SQL Is Integral I also will note that you will see a fair bit of my child-like
SQL (Structured Query Language). An Essbase developer writing SQL code is akin
to a carpenter performing neurosurgery: he might be able to get the skull open with
a compass saw, but that yankee screwdriver might not be the best tool for closing it
all back up. As for the patient's long-term prognosis … perhaps it is best not to dwell
overmuch on that subject. All I can say is that the code works and that you are more
than welcome to improve upon it. Again, if you do, it means that this chapter has
succeeded in engaging you.
2.1.2.3 ASOsamp.Sample The solution in this chapter uses the same ASosamp.Sample
Essbase database that has come with every copy of Essbase since version 7.1. ASosamp
(as I shall refer to it henceforth) is the source and the target of all code examples and
solutions.
2.1.2.4 Sample.Basic Sample.Basic, aka “Cameron's very Favorite Essbase Database
in the Whole Wide World,” was regrettably not chosen for this chapter because it is too
simple. however, it is rich with Load rule examples that have been used to illustrate
Load rule concepts.
Search WWH ::




Custom Search