Linked partitions enable the Essbase application designer to link Essbase databases containing dimensions that differ without losing access to all dimensions in the databases. See the Oracle Essbase Database Administrator's Guide.
The Essbase application designer can set styles for cells tagged as linked objects so that users can more easily find linked partition cells, which are access points to the linked partition.
When you access a linked partition cell, the Linked Objects Browser displays a list of possible partitions and other linked reporting objects (for example, cell notes and application files) to access.
When you select a partition, Essbase creates a worksheet containing corresponding members and dimensions for that cell in the linked partition. You can perform operations such as Zoom In and Zoom Out to get information on the worksheet.
To access linked partitions:
Locate a linked object cell, as indicated by the style applied to the cell.
To open Linked Objects Browser, select Essbase, and then Linked Objects.
Instead of using the Linked Objects command, you can select Enable Linked Object Browsing in the Essbase Options dialog box (Global page) so you can double-click a linked object to open Linked Objects Browser.
Caution! | If you enable double-clicking for linked object browsing, double-clicking behavior changes for retrieving data and performing drill actions. |
If the cell is a linked partition cell, Essbase creates a worksheet containing corresponding dimensions and members for the cell in the linked partition.
You need the proper access permissions to access the linked partition. If your user account and password match the account information for the linked partition, Essbase uses this information to establish connection with the linked partition. Otherwise, Essbase displays the Essbase System Login dialog box for you to enter the user account and password information manually.
Enabling Double-Clicking to Browse LROs
Using Mouse Actions to Pivot, Retrieve, and Drill Up and Down