Application and Database File Types

Table 135 lists the file types that Essbase uses to store applications, databases, and their related artifacts.

Table 135. Essbase File Types for Applications and Databases

File Extension

Description

alg

Spreadsheet audit historical information

apb

Backup of application file

app

Application file, defining the name and location of the application and other application settings

arc

Archive file

atx

Spreadsheet audit transaction

chg

Outline synchronization change file

csc

Essbase calculation script

db

Database file, defining the name, location, and other database settings

dbb

Backup of database file

ddb

Partitioning definition file

ddm

Temporary partitioning file

ddn

Temporary partitioning file

esm

Essbase kernel file that manages pointers to data blocks and contains control information used for database recovery

esr

Temporary database root file

esn

Temporary Essbase kernel file

ind

Essbase index file

inn

Temporary Essbase index file

log

Server or application log

lro

LRO file linked to a data cell

lst

Cascade table of contents or list of files to back up

mxl

MaxL script file (saved in Administration Services)

ocl

Database change log

ocn

Incremental restructuring file

oco

Incremental restructuring file

olb

Backup of outline change log

olg

Outline change log

otl

Essbase outline file

otm

Temporary Essbase outline file

otn

Temporary Essbase outline file

oto

Temporary Essbase outline file

pag

Essbase database data (page) file

pan

Temporary Essbase database data (page) file

rep

Essbase report script

rul

Essbase rules file

scr

Essbase ESSCMD script

sel

Saved member select file

tct

Essbase database transaction control file that manages all commits of data and follows and maintains all transactions

tcu

Temporary database transaction control file

trg

Trigger definition file. XML (Extensible Markup Language) format

txt

Text file, such as a data file to load or a text document to link as a LRO

xcp

Exception error log

xls

Microsoft Excel file