Partitions in Essbase

Partitions in Essbase
Partitioning is licensed separately from Analytic Services.
The Partitioning option must be licensed for every server that contains a database partition. A partition is a piece of a database that is shared with another database.

There are three types of partitions available.

1. Replicated
2. Transparent and
3. Linked.

A replicated partition is a copy of partition of the data source that is stored in the data target.
A transparent partition allow users to access data from the data source as though it were stored in the data target. The data is , however stored at the data source, Which can be another application, in another Analytic Services database, or on another analytic server.

A linked partition sends users from a cell in one database to a cell in another database. Linked partitions give users a different perspective on the data.

Steps to create a replicated partitions:

• Take any existing database. Ex:sales1(source database)
• Create another application salepart and create a database under that application.
• Open sales1 outline and select 'save as'. Click Analytical server tab and select sale part application, select the database sale part and replace the file. Now salepart and sales1 outlines are same.
• In this example we are going to create a partition to replicate only year 2007 dat into salepart cube.
• Right click on partition under sales1 or salepart. By default the replicated partition type is Replicated. Click connection tab. Select source as sales1,select the server. Select salepart as target and select the server.Click on areas tab. Select "show all count" check box.Click on "Double click here" under source and select the appropriate dimension. In this example select year 2007. Under target also select year 2007.
• Click validate. Replication partition is created.
• Right click on the target or source and click on replicate data from the source