Each Essbase application contains one or more database directories (for example, Sample.Basic) which, in turn, contain database-specific artifacts.
Table 19. Essbase Database Artifacts
| Artifact | Description | Last Modified Time | Last Modified User | Editable on the File System? | Dependencies |
|---|---|---|---|---|---|
| Rule Files | Sets of operations that Essbase performs on data values or on dimensions and members when it processes a data source | Yes | No | No | None |
| Calculation Scripts (or Calc Scripts) | A set of commands that defines how a database is consolidated or aggregated. A calculation script may also contain commands that specify allocation and other calculation rules separate from the consolidation process. | Yes | No | Yes—TXT | None |
| Report Scripts | Text files containing Essbase Report Writer commands that generate one or more production reports | Yes | No | Yes—TXT, XML | None |
| Excel Files | External spreadsheet files that you can associate with data cells in Essbase | Yes | No | Yes—TXT, XML | None |
| Substitution Variables | Global placeholders for regularly changing information | No | No | No | None |
| Location Aliases | Descriptors that identify a data source. The location alias specifies a server, application, database, user name, and password. Location aliases are set by DBAs at the database level using Oracle Essbase Administration Services, ESSCMD, or the API. | No | No | No | None |
| Security Filters | Restrictions that control security access to data values or cells | No | No | Yes—CSV | Shared Services security artifacts |
| Text Files | Text files used for loading data into Essbase cubes | Yes | No | Yes—TXT | None |
| Database Outline | Cube Outline file | Yes | No | No | None |
| Data | All stored data, whether it is at the input member or aggregated/consolidated at the parent level; for example, Stored Data, Dynamic Calc and Store. | No | No | Yes—TXT | Database Outline |