Set and StructureSet

Typically, Set and StructureSet are used to suppress zero values in reports.

  1. Create a list on the Product dimension.
  2. Name the list Product.
  3. Create a combo box and drag the Product list onto it.
  4. Name the combo box Combo.
  5. In a cell enter:=ReportObjects.Combo.Set.
    The cell displays Distinct ([Product]All Members)
  6. In another cell, enter: =ReportObjects.Combo.StructureSet.
    The cell also displays Distinct ([Product]All Members).
  7. Select the Product list. In Structure Selection, select the Car Tires Summer check box.
    The cell which contains the Set property displays Distinct({{[PRODUCT].[All Tires].[Car Tires Summer]}}).

    The cell which contains the StructureSet property displays: {{[PRODUCT].[All Tires].[Car Tires Summer]}}

Parent topic: Examples