Databases Reference
In-Depth Information
Unless otherwise specified by you, the user, all Essbase file objects,
including calculation scripts, report scripts, data load rules files, database
index and page files, and database control files are stored on the Essbase
analytic server using the server's own operating system's resident file
system and are located in the default
%Arborpath%/App/Database
path.
When you install Oracle Essbase on your server and your client, the installation also
creates new environment variables on your machines. The
ARBORPATH
environment
variable is basically the path name all the way down to the Essbase folder itself. In the
following screenshot, you can clearly see how the Essbase folder structure is laid out:
Calculation scripts
Essbase calculation scripts (Essbase file objects with the
.csc
extension) contain
specific calculation instructions, written by you, that Essbase will use to perform
specific calculations on the data. Essbase calculation scripts are actually ordinary
ASCII text files which can be edited in a simple text editor, like Notepad, or which
can be edited using the calculation script editor in the EAS. Essbase database
calculation scripts are discussed in full detail in Chapter 4.
