SUPSHARE

The Essbase Report Writer SUPSHARE command suppresses the display of later instances of shared members when you use generation or level names to extract data for your report.

Syntax

<SUPSHARE

Notes

SUPSHARE suppresses the display of later instances of shared members only when you extract data using:

Default or user-defined generation or level names
DIMBOTTOM
OFSAMEGEN
ONSAMELEVELAS

SUPSHARE suppresses the display for the duration of the script, which can contain one or more reports. Use the SUPSHAREOFF command to reinstate the display of shared members.

Default Value

SUPSHAREOFF is the default behavior – all instances of shared members are displayed.

Example

The Sample Basic database has a shared level of diet drinks. The shared members are 100-20 (Diet Cola), 200-20 (Diet Root Beer), and 300-30 (Diet Cream). All are level 0 members on the Product dimension. The following report script causes shared members to appear only once in the output report:

{SUPMISSINGROWS}
<SUPSHARE
<PAGE (Measures, Market, Scenario)
Sales West Actual
<COLUMN (Year)
<IDESCENDANTS Qtr1
<ROW (Product)
lev0,Product
!

As shown in the following report, the shared members appear only once.

                  Sales West Actual 
                 Jan     Feb      Mar    Qtr1 
                ======  ======  ======  ======
100-10          1,174    1,146   1,173   3,493 
100-20            700      726     727   2,153 
100-30            465      426     413   1,304 
200-10            667      705     707   2,079 
200-20          1,203    1,209   1,209   3,621 
200-30            853      845     880   2,578 
300-10          1,102    1,127   1,133   3,362 
300-20            523      546     566   1,635 
300-30            977    1,029   1,040   3,046 
400-10          1,115    1,122   1,107   3,344 
400-20          1,032    1,065   1,100   3,197 
400-30            625      618     619   1,862

Related Topics

SUPSHAREOFF