Excel Client:MeasureByIndex

From CoPlanner 10
Jump to navigationJump to search

MeasureByIndex(ObjectName, Index)

This function can be used to read the name of a measure (field) from its position in the data oject (cube). This function is volatile (it is executed every time the worksheet is calculated).

Parameter

ObjectName The name of the object whose measure is sought.
Index The position of the measure whose name is sought.


Example

Function Result
MeasureByIndex(„Umsatzerloese_PLAN“; 1) Quantity

If one of the parameters is invalid (object not found, index invalid), this will be indicated by the return value. For the meanings of the return values that may be displayed, please refer to Constants and Return Values.