Databases Reference
In-Depth Information
When gathering data for your Essbase application, you may encounter data from
many different sources. HAL allows you to set up a link to your favorite Oracle
database using an ODBC connection. HAL will also allow you to load data from
conveniently delivered flat files too. In fact, you can usually accomplish just about
all of your data loading needs for your Essbase System 9 installation by using HAL.
Oracle Business Rules
This tool can be a tremendous time saver. The Oracle Business Rules tool allows
the programmer to create, store, execute, and manage complex business rules as
specified by the business customer and as it relates to the business process and the
data. All of this is accomplished by using an easy to understand user interface with
graphical depictions of the various elements that go into a rule.
Imagine a business process that dictates the values for next month's sales
commitments as follows:
• If the actual sales for the prior month are not received by the 15th of the
current month, then the committed sales for the current month are to equal
the sales number that was forecasted from the prior month.
• If the actual sales for the prior month are received by the 15th, then the
number used for the current month's committed sales will be equal to the
prior month actual sales * 1.15.
This is just one example of a business rule being automatically executed against
the data for the users of the system. There are endless possibilities on how to make
good use of this tool.
The advantages of the Oracle Business Rules tool are clear, especially in today's
fast-paced business world where static structures in data load and calculation
scripts need almost continual modifying. With the Hyperion Business Rules tool,
the dynamic nature of the business can more effectively be supported with the
creation of minimal maintenance dynamic rules.
