You must specify a user name and password for Essbase to use when communicating between the source database and target database in a partition. Essbase uses the user name and password to transfer data between the two databases and to synchronize outlines. Local security filters apply to prevent users from seeing privileged data.
To specify connection information for partitions:
Select Connection.
In the Data Source option group:
In the Data Target option group:
Select Areas to continue defining the partition if you are creating a partition.
Either validate and save the partition, or select another tab and continue editing if you are editing a partition.
create partition (MaxL) in the Oracle Essbase Technical Reference
display partition (MaxL) in the Oracle Essbase Technical Reference