Databases Reference
In-Depth Information
The storing of complex business rules to facilitate proper analysis of the data is a
huge benefit of Oracle Planning and is accomplished within the module by utilizing
a small space on a relational database such as an Oracle or SQL server database.
With the aid of pre-packaged process modules, Essbase Planning can also greatly
shorten the length of time typically required for budget and forecast cycles, thus
lowering the total cost of ownership for this product.
Essbase analytics
It's funny, but the word analytics is being tossed about rather often these days.
Pretty much anything you do with OLAP or multidimensional database tools,
can be termed analytics.
In Essbase however, Essbase analytics, to some, usually refers to Essbase's other
database engine, the ASO database engine. The reason given for this is that the
typical Essbase ASO database is primarily used for presentation, analysis, and
reporting which are all analytic functions. The Essbase BSO database, while
analytic itself, can also be considered transactional as well.
The Essbase analytics nickname dates back to the advent of the ASO database
architecture when all you had was the BSO architecture. The new ASO architecture
was the analytic tool.
Yes, it's funny how Essbase is an analytical package and inside that package is
an analytic piece but that's just how it is.
Try not to get hung up on the terminology here though. When considering your
options, you need to look at all of the same things you have always looked at. How
large will the system be? What are the business customer's requirements? What type
of system am I building here?
When you answer these questions, it will matter less what you call what you are
doing than choosing the right tools.
Hyperion Application Link/Oracle
Application Link
The name pretty much says it all. Hyperion Application Link is a suite of ETL tools
that allows the user or programmer to integrate Oracle products, like Essbase, with
other third party software packages, especially transactional database packages.
Hyperion Application Link (HAL)
can integrate all of your data loading and ETL
functions into one place and offer improved performance.
