CGETNOTE

The CGETNOTE formula is used to retrieve text (or note) based on the hierarchy information passed into the formula. It reads from the specified cube, and must have a minimum of one hierarchy and a maximum of 20. It also allows you to add and edit notes.

Syntax

CGETNOTE (Datasource, Catalog, Cube, Hier1, Hier2…Hier20)

Arguments

Datasource : string (required)

Specify the Analysis Services server that you want to connect to.

Catalog : string (required)

Specify the catalog of cubes on the datasource that you want to perform your query on.

Cube : string (required)

Specify the cube that you want to perform your query on.

Hier1 : string (required)

Specify the name of a valid member in the cube’s first hierarchy.

HierN : string

Specify the name of a valid member in the cube’s nth hierarchy. Up to 20 hierarchies are allowed to be specified.

Usage Scenarios

To retrieve a value based on the hierarchy information from the specified cube. It is useful when users need to get the value of a particular cell from the specified cube.

While the input of argument Hier1 is compulsory (e.g. at least 1 hierarchy is needed), the other related arguments such as Hier2 … Hier20 are optional. Additionally, these arguments are not necessarily sorted and can be listed in any order. If not being used, these arguments will default to the default member.