Skip to content

CCHART

The CCHART formula allows you to render a dynamically linked chart in the published version of the report. The size of the chart will be the same as the size of the cell. This formula is inserted into a cell when using the Chart button in the CALUMO ribbon of the Office client, which allows for easy selection/creation of the view to be charted.

Syntax

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

Arguments

ID : number (required)

The ID of the chart to be shown. The ID can be found in the URL of the view after “view/”.

ChartFamily : string

The Chart Family of this chart. 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.

Examples

  • =CCHART(46)
  • =CCHART(46, "ExampleFamily")
  • =CCHART(413, "ExampleFamily", [Account].[Accounts].&[-13], [Scenario].[Scenario].&[BUD])
  • =CCHART(413,"ExampleFamily", {[Account].[Accounts].&[-14],[Account].[Accounts].&[-15].children})
  • =CCHART(413, "ExampleFamily", {[Account].[Accounts].&[-14],[Account].[Accounts].&[-15].children}, [Scenario].[Scenario].&[BUD])
  • =CCHART(413, "ExampleFamily", {[Account].[Accounts].&[-14],[Account].[Accounts].&[-15].children}, [Scenario].[Scenario].&[BUD], [Measures].[Closing Balance])