Excel Client:MeasureByIndex: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==MeasureByIndex(ObjectName, Index) | ==[[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). | 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}} | |||
{| class="wikitable" width=" | | 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]]. | ||
Revision as of 10:47, 24 May 2012
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.
