Skip to content

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 : number (required)

The ID of the chart to be shown.

ChartFamily : string

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

RowMembers : string

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 : string

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.