SUPSHARE
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
This command 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.
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:
{SUPMISSINGROWS}
<SUPSHARE
<PAGE (Measures, Market, Scenario)
Sales West Actual
<COLUMN (Year)
<IDESCENDANTS Qtr1
<ROW (Product)
lev0,Product
!
returns the following data. The shared members appear only once in the data.
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