Database Reference
In-Depth Information
Figure 5.10
Creating a Query Hint. (From Oracle Essbase Administration Services. With permission.)
Note:
Dynamic dimensions cannot be included in Query hints and subsequent view
selections. This is another supporting reason to choose hierarchies Enabled instead of
Dynamic.
you can create as many hint combinations as are applicable.
Three different methods have been discussed that can be used for optimizing aggre-
gations. There is a hierarchy of precedence to how each one is considered when views are
created, so never use all three:
1. Query tracking (usage-defined views) is considered first and overrides the
other two.
2. user-defined views created from setting hierarchy properties is considered next
and overrides Query hints.
3. Query hints is considered last and is not going to accomplish much if either of
the previous two methods are employed.
5.5.2 Working with Slices
5.5.2.1 Data versus Aggregations
The most exciting advancement to ASo cubes in the
past four years without question has got to be the creation of Data Slices, which provides
every Essbase developer the ability to do true incremental data loads and true regional
data clears. Those two abilities totally change how ASo cubes are currently used, and
offer new and exciting possibilities for how they might be used in the future. The reality
of real-time or near real-time updates to ASo cubes is now within reach. to understand
why this would create such stupefying excitement (it literally makes me giddy to discuss
it), you would need to think back first to where ASo cubes have come from. In the first
release of ASo cubes, what was the behavior of the cube if you did AnythIng at all to
it? Why, thanks for asking. The database would unceremoniously (and mostly without
warning) just dump the data. This was frustrating beyond belief.
Picture yourself completing a benign task that you did all the time in BSo cubes;
something simple, such as adding a new member to the metrics dimension. The member
would be added, the formula completed, and off to Excel
®
you went to check the results.
you whipped a query right up and it would come back as #mISSIng. “hmmm,” you
would say, “I must have done something wrong in my mDx statement (since, of course,
I am brand new to this).” Accordingly, you would go look at the formula and study its
