Selective Export of Artifacts

You can control export by selectively exporting individual Essbase artifacts for cloud service migrations, using the CLI utility.

You can export individual artifacts, for example, exporting only rules, or outlines, or data, and so on. You can also use this process for periodic backup of individual artifacts.

Selective Migration, Backup, and Export

You can selectively export the following:

Cube - Export just a single cube from an application.
Essbase Files - Export particular files, such as Outline, Rule files, Drill Through reports, and others.
Data - Export only data. This can be useful for periodic backup of data.
Partitions - Export only partitions.
Filters - Export only security filters of a cube.

Supported Essbase File Types

The following Essbase file types are currently supported for selective export.

OTL
TXT
RUL
CSC
DTR
EXCEL

CLI Utility Command Options

The following command options have been added or changed to support selective export.

-c or --cube <cube name> Exports a single cube. This option can be used by itself or combined with one of the following options.

-d or --exportdata Exports data only.

-ft or --filetype <filetype> Export files of the specified type. File type keywords, such as OTL or RUL, are case-sensitive and must be entered in upper case.

-ep or --exportpartitions Export partitions only.

-ef or --exportfilters Export security filters only.

Examples

Export data only, from a single cube, for example, Demo.Basic:
```
./esscs.sh lcmexport -a Demo –c Basic -z data.zip –d
```

Export a single cube only:

./esscs.sh lcmexport -a Demo -z data.zip –c basic

Export only text files, from all cubes under Demo:

./esscs.sh lcmexport -a Demo -z data.zip –ft txt

Export only partitions, from all cubes under Demo:
```
./esscs.sh lcmexport -a Demo -z data.zip –ep
```
Export only the data from all of the applications:
```
./esscs.sh lcmexport -aa -z all_data.zip –d
```
Export only outlines, from all cubes in an instance:
```
./esscs.sh lcmexport -aa -z cubes.zip –ft OTL
```

Export all partitions of an instance:

./esscs.sh lcmexport -aa -z all_partitions.zip –ep

Export all security filters of a single cube:

./esscs.sh lcmexport -a Sample -z all_partitions.zip -c Basic –ef