Excel Client:MeasureByIndex: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
Created page with '==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 i…' |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>MeasureByIndex(ObjectName, Index)</span> | |||
This [[Excel_Client:Functions_(Formulas)|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). | |||
{| | {| class="wikitable" width={{{breite|80%}}} | ||
|- {{Tabellentitel}} | |||
| width="150px"|Parameter | |||
| Description | |||
|- | |- | ||
| | |ObjectName | ||
|The name of the object whose measure is sought. | |The name of the object whose measure is sought. | ||
|- | |- | ||
| | |Index | ||
|The position of the measure whose name is sought. | |The position of the measure whose name is sought. | ||
|} | |} | ||
==Example == | |||
<span {{CoPFormel}}>MeasureByIndex("Umsatzerloese_PLAN"; 1) </span><br> | |||
returns 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 [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]. | 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 [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]. | ||
Latest revision as of 16:46, 15 April 2014
Function
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 | Description |
| ObjectName | The name of the object whose measure is sought. |
| Index | The position of the measure whose name is sought. |
Example
MeasureByIndex("Umsatzerloese_PLAN"; 1)
returns 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.
