11g LCM Export Utility Options

You have the following options to use 11g LCM Export Utility to export from Essbase 11g On-Premise.

Syntax

EssbaseLCM.bat|.sh export -server essbasehost:port -user username -password password -application
      appname -zipfile zipfilename [-nodata] [-include-server-level] [-converttoutf8] [-forceutf8]
      [-generateartifactlist] [-exportepmroles] [-allApp] [-exportdata]
          [-cube] [-filetype] [-partitions] [-filters]

Notes

  • You can specify -converttoutf8 option during export to automatically convert the Essbase 11g On-Premise block storage application to Unicode, before exporting it to a .zip file. Note that this will convert the source block storage application to Unicode; it is recommended to run a backup before specifying this option.

  • You can specify the options/arguments in any order.

  • To prompt for a password, do not include the -password option.

  • To skip the export of application data, specify -nodata, which is an optional argument. By default, all application data is exported.

Command Options and Descriptions

Option Description
-server <essbasehost:port> Server host name and port number.
-user <username> Server user name.
-password <password> Server password. Skip if you want to be prompted for the password.
-application <appname> Name of application to back up.

-zipfile zipfilename

Optional. Name of compressed file to hold backup files.
-nodata Optional. Do not include data in the backup.
-overwrite Optional. Overwrite existing backup file.
-converttoutf8

(Optional) Convert block storage application to Unicode. Prompts you to type Y to confirm.

-forceutf8 (Optional) Same as -converttoutf8, but without any prompt. Can be used in automation scripts.
-exportepmroles (Optional) Exports Essbase roles from Enterprise Performance Management (EPM) source.
-generateartifactlist Optional. Generate a text file containing a complete list of the exported artifacts. You can use this text file to manage the import of artifacts. For example, you can rearrange the order of artifacts in the list to control the order in which they are imported. You can skip importing some artifacts by removing or commenting out items in the list.
-include-server-level (Optional) Include server-level artifacts, such as server-level substitution variables and server-level roles. Requires system administrator role.
-allApp Optional (and case-sensitive). If used instead of -application, exports all applications to a single zip file. lcmimport can accept single-application zip files or multiple-application zip files.
-exportdata Optional. Only export data.
-cube Optional. Export a single cube. This option can be specified along with the options to export only: data, files of certain types, partitions, or filters.
-filetype

Optional. Only export files of the specified type. Supported file types include OTL (outline), TXT (text), RUL (rule), CSC (calc script), DTR (drill through report definition), and Excel (only .xls files are exported. No .xlsx files are exported).

-partitions

Optional. Only export partition definitions.

Lifecycle Management (LCM) import operations (and Migration Utility import) are not supported for migration of federated partitions. Federated partitions must be recreated manually on the target.

-filters Optional. Only export security filters.