81
158
© 2010 CustomGuide, Inc.
Engineering and Cube
Functions
These last functions are also possibly the functions that
will be used the least. .
This table lists some of the Engineering Functions
available in Excel 2010.
Table 7-14: Overview of Engineering Functions
BESSELI
BESSELI(x,n)
Returns the modified Bessel function In(x).
BIN2DEC
BIN2DEC(number)
Converts a binary number to decimal.
COMPLEX
COMPLEX(real_num,i_num,suffix)
Converts real and imaginary coefficients into a
complex number.
CONVERT
CONVERT(number,from_unit,to_unit)
Converts a number from one measurement system to
another.
DELTA
DELTA(number1,number2)
Tests whether two numbers are equal.
This table lists some of the Cube Functions available in
Excel 2010.
Table 7-15: Overview of Cube Functions
CUBEKPIMEMBER
CUBEKPIMEMBER(connection, kpi_name,
kpi_property, [caption])
Returns a key performance indicator (KPI) property
and displays the KPI name in the cell. A KPI is a
quantifiable measurement, such as monthly gross
profit or quarterly employee turnover, that is used to
monitor an organization's performance.
CUBEMEMBER
CUBEMEMBER(connection,
member_expression, [caption])
Returns the logical value FALSE
Returns a member
or tuple from the cube. Use to validate that the
member or tuple exists in the cube.
CUBEMEMBERPROPERTY
CUBEMEMBERPROPERTY(connection,
member_expression, property)
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 specified property
for this member.
CUBERANKEDMEMBER
CUBERANKEDMEMBER(connection,
set_expression, rank, [caption])
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.
CUBESET
CUBESET(connection, set_expression,
[caption], [sort_order], [sort_by])
Defines 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.
CUBESETCOUNT
CUBESETCOUNT(count)
Returns the number of items in a set.
CUBEVALUE
CUBEVALUE(connection,
[member_expression1],
[member_expression2], …)
Returns an aggregated value from the cube.
Exercise
•
Exercise File: None required.
•
Exercise:
Become familiar with some of Excel’s
Engineering and Cube functions.
More Functions and Formulas