A linked reporting object (LRO) is an object that you associate with a specific data cell in an Essbase database; for example, a graphic file that more fully explains a cell value. LROs provide improved support for planning and reporting applications and can enhance data analysis capabilities by providing supplemental information about data. LROs can be linked files, brief cell notes, or URLs. For information about the different types of LROs, see the Oracle Essbase Database Administrator's Guide.
An LRO is created using Spreadsheet Add-in, by selecting a data cell in the spreadsheet and attaching an LRO to that cell. Any number of objects can be linked to a cell. The objects are stored on Essbase Server where they are available to users with the appropriate permissions. For more information about how users work with LROs, see the Spreadsheet Add-in User's Guide. You can use the console to manage existing LROs.
Before you perform tasks related to LROs, be aware of these facts:
Essbase uses the database index to locate and retrieve LROs. If you clear data from a database, the index is deleted, along with the LRO information. Before performing operations that remove LRO information from a database, export the LROs so that you can re-import them. For more information, see Exporting LROs and Importing LROs.
If you restructure a database, the index and the LRO information are preserved.
If you use Migration Wizard to migrate applications and databases across servers, LROs are not migrated with the applications and databases. You need to export LROs before migrating, and then import LROs after migration.
Shared members do not share LROs. LROs are linked to specific member combinations, and shared members do not have identical member combinations. If you want a given LRO to be linked to shared members, you must link it to each shared member individually.