You can backup data by exporting it. Exporting data copies it to a text file that you specify. it does not compress the data the export file contains data only and does not includes control, outline or security information

Right click on any database and click export .

  • select level data (there are several options available to export the data ) all data option select lot of time to export
  • the exported files are saved in APP folder with txt extension .
  • the exported file can save up to 2 GB , ESSBASE automatically creates another file . when analytic services creates multiple export files, it uses the requested file name for main file. An underscore and sequential cardinal number are appended to the names of additional files starting with _1 . for example , if the requested file name is explain .txt and the exported data would exceed 4 GB , analytic service creates three files naming them expjan.txt . exported data files can be reloaded in any sequence .



To import data , right click on the database and click load data and select the above source files. No need to give any rules files


Partitioning is licensed separately from analytic services . the Partitioning options must be licensed for every server that contains a database Partition . a Partition is piece of a database that is shared with another database .

There are three types of Partitions available . replicated, transparent and linked .

A replicated partition is a copy of a portion of the data source that is stored in un data target

The transparent Partition allow users to access data from the data source were stored in the data target . the data is how ever stored at the data source , which arrange the another application , in another analytic services database , or an another analytic server

A linked Partition sends users from a cell in one database to a another database . linked Partitions give users a different perspective on the data