• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

EXPORT DATA & IMPORT DATA in Hyperion EssBase

EXPORT DATA :-

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 .

 

IMPORT DATA:-

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

Partitions:-

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

Summary
Review Date
Reviewed Item
EXPORT DATA & IMPORT DATA in Hyperion EssBase
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on EXPORT DATA & IMPORT DATA in Hyperion EssBase"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.