Skip to main content Skip to complementary content

HCValue

The HCValue function it is used to retrieve values in a row of a specified column.

Syntax:  

HCValue(column,position)

Example 1:  

This example returns the value at the first position of the column with label ‘Sales’.

HCValue(Sales,1)

Example 2:  

This example returns the value at the tenth position of the sorted hypercube.

HCValue(#hc1.measure.2,10)

Example 3:  

This example returns the value at the fifth row in the third dimension.

HCValue(#hc1.dimension.3,5)

Information noteIf there are no such dimensions or expressions, in value or labels, an error is returned indicating that the column was not found. If the index for the column is out of bounds, NULL is returned.

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!