Syntax

<SUPSHAREOFF

Notes

You can suppress and reinstate shared member display only when you extract data for your report using:

• Default or user-defined generation or level names

• DIMBOTTOM

• OFSAMEGEN

• ONSAMELEVELAS

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 excerpt uses SUPSHAREOFF to reinstate the shared member display so that the shared members appear twice in the report.

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

The report script excerpt above returns the following data. The example assumes that you have used SUPSHARE in a previous report in the report script.

                        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 
100-20           700         726         727      2,153 
200-20         1,203       1,209       1,209      3,621 
300-30           977       1,029       1,040      3,046