Databases Reference
In-Depth Information
Automating your Essbase
Cube
If you've made it this far and you're still coherent, congratulations! Upto now there
has been a tremendous amount of information for you to absorb, all of it necessary.
With all that we have presented to you to this point you should be able to take your
Essbase journey from a complete installation to a fully functioning Essbase database.
Complimenting your fully functioning Essbase database is your knowledge of the
many ways to load and calculate the data in your Essbase database. You also have
a good understanding of how to utilize the powerful Essbase Add-in for Microsoft
Excel, allowing you to interact with your database and the data contained in it.
In this chapter you will learn that many of the routine tasks required to keep
your Essbase system functioning at its best can be automated. Further, many
of the routine administrative tasks can be automated and the functionality then
provided to your business customers so they can perform for themselves many
of the administrative duties that pertain to their business operations. Some of
these types of tasks include adding new users, granting permissions, executing
data loads, and running database calculations.
This chapter is divided into three main sections and each section speaks to a
different method that can be used to automate Essbase functions and commands.
