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.
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
See Also