1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. LROONSHAREDMBR

LROONSHAREDMBR

The LROONSHAREDMBR configuration setting specifies whether Essbase shared members have Linked Reporting Objects that are unique from those of their prototype members.

LROONSHAREDMBR configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

Syntax

LROONSHAREDMBR TRUE | FALSE

  • TRUE—LROs related to regular members are unique, and not shared by shared members. This is the default.

  • FALSE—Shared members have the same LROs as their prototype members.

Description

A Linked Reporting Object (LRO) is an external file, cell note, or URL that you link to a cell in a cube. Users can then retrieve the object from their queries in Smart View or other grid clients.

With an LROONSHAREDMBR setting of TRUE, Essbase makes shared member LROs unique from the LROs of prototype members.

For example, assume the LROONSHAREDMBR option is FALSE. If you link an LRO to the data cell related to Diet Colas (100-20) under the parent member Colas (100), the corresponding data cell for Diet Colas (100-20) under the parent member Diet shares the same LRO.

Example

LROONSHAREDMBR FALSE