Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Blog

CUBEVALUE

  • May 31, 2023
Definition: CUBEVALUE is a function that returns the value of a measure from an OLAP cube. Syntax: =CUBEVALUE(connection, [member_expression1], [member_expression2], ..., [member_expression_n], [measure_expression]) Situation: This formula is suitable...
Read More

CUBESET

  • May 31, 2023
Definition: CUBESET is a function that returns a set or tuple from an OLAP cube. Syntax: =CUBESET(connection, set_expression) Situation: This formula is suitable when you need to retrieve...
Read More

CUBERANKEDMEMBER

  • May 31, 2023
Definition: CUBERANKEDMEMBER is a function that returns the nth ranked member or tuple from an OLAP cube, based on a specified measure. Syntax: =CUBERANKEDMEMBER(connection, set_expression, rank, [measure_expression]) Situation:...
Read More

CUBEMEMBERPROPERTY

  • May 31, 2023
Definition: CUBEMEMBERPROPERTY is a function that returns the value of a specified property for a member or tuple from an OLAP cube. Syntax: =CUBEMEMBERPROPERTY(connection, member_expression, property_name) Situation: This...
Read More

CUBEMEMBER

  • May 31, 2023
Definition: CUBEMEMBER is a function that returns a member or tuple from an OLAP cube. Syntax: =CUBEMEMBER(connection, member_expression) Situation: This formula is suitable when you need to retrieve...
Read More

CUBEKPIMEMBER

  • May 31, 2023
Definition: CUBEKPIMEMBER is a function that returns a key performance indicator (KPI) value from an online analytical processing (OLAP) cube. Syntax: =CUBEKPIMEMBER(connection, kpi_name, [kpi_property], [member_expression]) Situation: This formula...
Read More

CRITBINOM

  • May 31, 2023
Definition: CRITBINOM is a function that returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. Syntax: =CRITBINOM(trials, probability_s,...
Read More

COVAR

  • May 31, 2023
Definition: COVAR is a function that returns the covariance between two sets of data. Syntax: =COVAR(array1, array2) Situation: This formula is suitable when you need to find the...
Read More

COUNTIFS

  • May 31, 2023
Definition: COUNTIFS is a function that counts the number of cells in a range that meet multiple specified conditions. Syntax: =COUNTIFS(range1, criteria1, [range2], [criteria2], ...) Situation: This formula...
Read More

COUNTIF

  • May 31, 2023
Definition: COUNTIF is a function that counts the number of cells in a range that meet a specified condition. Syntax: =COUNTIF(range, criteria) Situation: This formula is suitable when...
Read More