You use the Connection tab of the Create or Edit Partition window to specify connection information for the source and target databases of partitions.
In the Data Source and the Data Target groups, you specify information for the source and target databases, respectively:
Essbase Server—Name of the Essbase Server instance on which the database resides
Application—Name of the application that contains the database
Database—Name of the database
Within transparent partitions, source databases can be aggregate storage or block storage databases, and target databases can be only block storage databases.
User and Password—Username and password that you want the partition to use to connect to theEssbase Server instance on which the database resides
For replicated and transparent partitions, Essbase uses the username and password to transfer data between the source and target databases. Local security filters apply to prevent end users from seeing privileged data.
Comment—For linked partitions, comments are displayed in the Spreadsheet Add-in in the Linked Objects box. Therefore, you can use comments to enable users to distinguish between linked partitions.
Circumstances that may modify the display within the Create or Edit Partition window:
If you launched the window from a block storage database in Enterprise View, only block storage databases are displayed in the Data Source and Data Target groups.
If you launched the window from an aggregate storage database in Enterprise View, block storage and aggregate storage databases are displayed in the Data Source and Data Target groups.
create partition (MaxL) in the Oracle Essbase Technical Reference
display partition (MaxL) in the Oracle Essbase Technical Reference