About Text File Data Sources

Text file data sources consist of flat text files that a database or system administrator places in a predefined location. By keeping the text file sources in one location starting from the indicated folder, administrators are able to limit user access to other files on the server, thereby providing a measure of security.

The default location for text files is:

EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/Server/datafiles

Note:

The server.datafile.dir property in the server.properties file is used to define the text file location. If you do not want to use the default text file location, see server.datafile.dir for information on specifying the server.datafile.dir property.

Text files are contained within individual directories in the location specified by server.datafile.dir. Each text file directory is considered a text file data source, and can contain any number of individual text files.

Essbase Studio accesses the text file location at data source creation time. In the Text File Location dialog box, /<root> is the equivalent of the directory location defined by server.datafile.dir. The folders in this directory are the text file data sources from which the user can choose.