The "kpi-property" parameter lists a number of values which are undefined such as "temporal context", "relative importance", etc. This is made even more cryptic by the fact that this function, unlike almost all the others, has examples that fail to illustrate the returned values. If there is to interoperability in the use of this function, semantics in additional to syntax will need to be specified.
Proposed change: Provide the semantics for this function
3.17.7.65 [CUBEKPIMEMBER]
te
Proposed Disposition of DIS 29500 Comment GB-0388 (Modified: 2007-11-05) Agreed; the following change will be made to Part 4, §3.17.7.65, pages 2,5902,591, line 21. We will also add a reference to the OLAP specification. 3.17.7.65 CUBEKPIMEMBER Arguments: Name Type Description connection text The name of the connection to the cube. kpi-name text The name of the KPI in the cube. kpi-property number The KPI component to be returned, truncated to integer; it shall be one of the following: Value Description 1 The actual value , at the time the function is executed. 2 A target value of the KPI, which can be compared to the actual value in order to determine if the underlying indicator is meeting its goal. 3 The state of the KPI at a specific moment in time 4 A measure of the value over time 5 The relative importance assigned to the KPI on the server. If this KPI is assigned a parent KPI, then this number can be used on the server to proportionally adjust the results of this KPI value when calculating the value of the parent KPI. While this number can be shown in the spreadsheet application, it is assumed that it is used by the Name Type Description server for any calculations affecting the KPI . A relative importance assigned to the KPI 6 A temporal context for the KPI The unique name of the member in the time dimension that defines the timeframe of the KPI. [Example: A KPI could be associated with the first quarter of the year 2007. end example] If 1 is specified, only kpi-name is displayed in the cell. caption text An alternative string whose value is displayed in the cell instead of kpi-name and kpi-property. Similar Comments: CA-0053 , CL-0184 , CO-0175 , FR-0508 , US-0187
