Expand Set Code Samples

Here is an example of an expand-set used in a definitions block.

  expand-set id = "expand_cost" { 
    take-parameter "summary" 
    expand "Cost" { 
      text column = "$(summary) Y" 
      text column = "$(summary) Y Y-1" 
      text "% Chg" column = "$(summary) Y Y-0 % Diff" 
    } 
  } 

Here is an example of the expand-set referenced in a report page.

  report-page { 
    title "Report Page Expand Set" 
    cplan "/cplans/basic_timeseries.cplan" 
    
    dimension "Corporate Brand" 
    dimension "Corporate Supplier" 
    
    text column = "Cases" { 
      expand-set id = "expand_cost" { 
        pass-parameter "summary" "Cost" 
      } 
    } 
  } 

Here is the result of the code in DiveTab with the expand-set open.

Here is an example of an expand definition as part of a column-set.

  column-set id = "Quarters" { 
    text column = "Cases" { 
      expand "Past Years" { 
        text "Cases Y" column = "Cases Y" 
        text "Cases Y-1" column = "Cases Y Y-1" 
        text "Cases Y-2" column = "Cases Y Y-2" 
      } 
    } 
  } 

Here is an example of the above column-set used in an ad hoc page.

  ad-hoc-page id = "ad-hoc" { 
    title "Basic Analysis" 
    cplan "/cplans/basic_timeseries.cplan" 
    
    dimension "Corporate Supplier" 
    dimension "Corporate Product Group" 
    dimcount-dimension "Resp SalesPerson" 
    dimcount-dimension "Customer" 
    
    column-set id = "Quarters" { 
      pass-parameter "summary" "Cases" 
    } 
  } 

Here is the result of the code in DiveTab with the column expanded. The dimcount-dimensions are collapsed.

See also:

• What is an Expand Set?
• Expand Set Code Block
• Adding Expand Sets
• Adding an Expand Set with a Parameter