Skip to content

CMETA (beta)

The CMETA formula is used to retrieve meta-information about any CALUMO asset and display it using the Meta context box inside Excel and Published Reports.

Syntax

CMETA(MetaType, ContextNameOrId, Icon, Datasource, Catalog, Cube, Attributes)

Arguments

MetaType : string (required)

Specify the type of meta information that will be displayed. The metatype will help retrieve the correct information along with other parameters provided.

Available types are:

"measure", "dimension", "hierarchy", "subset", "view", "report", "custom"

ContextNameOrId : string (required)

A string that contains the name or Id of the CALUMO asset. The type of CALUMO asset, this name is associated with, is specified in the MetaType argument. e.g. name of the report, measure name or view Id

Icon : string

A string specifies how to render the meta icon.

Avalable options are:

  • "", blank - blank setting will return meta content as text to cell.
  • "fa fa-information" - This will render the specific fontawesome icon for meta.
  • "http://www.image.com/smileyface.jpeg" - render the specific image for meta.

Datasource : string

Specify the datasource to retrieve the meta content. It is required for metatypes, “measure”, “dimension”, “hierarchy” and “subset”.

Catalog: string

Specify the catalog to retrieve the meta content. It is required for metatypes, “measure”, “dimension”, “hierarchy” and “subset”.

Cube: string

Specify the cube to retrieve the meta content. It is required for metatypes, “measure”, “dimension”, “hierarchy” and “subset”.

Attribute: string

A JSON string specifies a property bag to help to retrieve the correct meta content.