Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

CUBEKPIMEMBER(connection,kpi_name,kpi_property,[caption])

[Category: Cubel]*

New in Excel 2007. Returns a key performance indicator (KPI) property and

displays the KPI name in the cell. Used for OLAP Cubes.

CUBEMEMBER(connection,member_expression,[caption]) [Category:

Cube]*

New in Excel 2007. Returns a member or tuple from the cube. Used for OLAP

Cubes.

CUBEMEMBERPROPERTY(connection,member_expression,property)

[Category: Cube]*

New in Excel 2007. Returns the value of a member property from the cube.

Use to validate that a member name exists within the cube and to return the

speciﬁ ed property for this member. Used for OLAP Cubes.

CUBERANKEDMEMBER(connection,set_expression,rank,[caption])

[Category: Cube]*

New in Excel 2007. Returns the nth or ranked member in a set. Use to return

one or more elements in a set, such as the top sales performer or the top 10

students. Used for OLAP Cubes.

CUBESET(connection,set_expression,[caption],[sort_order].[sort_by])

[Category: Cube]*

New in Excel 2007. Deﬁ nes a calculated set of members or tuples by sending a

set expression to the cube on the server, which creates the set, and then returns

that set to Microsoft Excel. Used for OLAP Cubes.

CUBESETCOUNT(set) [Category: Cube]*

New in Excel 2007. Returns the number of items in a set. Guru Tip: the set

argument may be a CUBESET function. Used for OLAP Cubes.

CUBEVALUE(connection,member_expression1) [Category: Cube]*

New in Excel 2007. Returns an aggregated value from the cube. Used for OLAP

Cubes.

CUMIPMT(rate,nper,pv,start_period,end_period,type) [Category:

Financial]*

Returns the cumulative interest paid on a loan between start_period and end_

period. Guru Tip: great for calculating how much interest you will pay in each

year of your housing mortgage. While I usually use a negative value for the pv

argument in the PMT function, this function requires pv to be positive. Note that

in the image below, I used a positive value for pv, but preceded the CUMIPMT

function with a minus sign. Also, the type argument is no longer optional.