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.

Search JabSto ::

Custom Search