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

(Required)

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

Catalog

(Required)

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

Cube

(Required)

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

Hier1

(Required)

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

HierN

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 random order. If not being used, these arguments will default to the default member.