Linked reporting objects (LROs) are objects, for example, text notes, that you associate with specific data cells in an OLAP cube.
The DB2 OLAP Server spreadsheet add-in provides options for highlighting cells that are displayed in the spreadsheet and that have associated linked reporting objects. See the IBM DB2 OLAP Server Spreadsheet Add-in User's Guide for information about using linked reporting objects with spreadsheets.
With OLAP Miner, you can write deviations from a results file to the OLAP cube as linked reporting objects. In addition, you can remove linked reporting objects that are associated with either a definition or an entire cube. In both instances, OLAP Miner removes only linked reporting objects that it has added to the source cube and leaves all other linked reporting objects intact.
OLAP Miner adds the following information to each linked reporting object for a deviation:
To view deviations as linked reporting objects in a standard spreadsheet application, you must have the DB2 OLAP Server spreadsheet add-in installed. Also, you must configure the spreadsheet application to highlight linked reporting objects by applying styles. To configure the spreadsheet, open the Options window and edit the appropriate settings. See the OLAP Spreadsheet Add-in User's Guide for more information about configuring your spreadsheet.