CCHART

The CCHART formula allows you to render a dynamically linked chart in the published version of this report that is sized the size of the cell.

This formula is inserted into a cell when you use the Chart button in the CALUMO ribbon.

Syntax

CCHART(ID, ChartFamily, RowMembers, ColumnMembers, Slicer1, …, Slicer12)

Arguments

ID

(Required)

The ID of the chart to be shown

ChartFamily

The Chart Family that this chart belongs. All charts with an unset family belong to a default family

RowMembers

The Member Unique ID(s) to show on your Category axis (Rows)

  • A single member not wrapped in ‘{ }’ will be drilled to children automatically.
  • An MDX set statement wrapped in ‘{ }’ will be used as the set of members to show

ColumnMembers

The Member Unique ID(s) to show as your chart series (Columns)

Slicer1..12

A Member Unique ID to use as a filter on the chart