Cubes Functions
Cube functions for working with OLAP data
CUBEKPIMEMBER Function
The CUBEKPIMEMBER function retrieves key performance indicator (KPI) properties from OLAP cubes and displays them in Excel worksheets. Essential for business intelligence dashboards tracking organizational metrics like profit margins, sales targets, and performance trends.
Learn MoreCUBEMEMBER Function
The CUBEMEMBER function retrieves a specific member or tuple from an OLAP cube using MDX expressions. It validates cube membership and returns the member for use in other cube functions, essential for dynamic multidimensional data analysis.
Learn MoreCUBEMEMBERPROPERTY Function
The CUBEMEMBERPROPERTY function retrieves specific property values for cube members in OLAP analysis. It extracts metadata like captions, descriptions, or custom properties from multidimensional cube structures.
Learn MoreCUBERANKEDMEMBER Function
The CUBERANKEDMEMBER function retrieves the nth ranked member from a specified set within an OLAP cube connection. Perfect for extracting top performers, leaders, or specific ranked items from multidimensional data analysis.
Learn MoreCUBESET Function
The CUBESET function creates a named set from an OLAP cube by sending a set expression to the server. This powerful function enables dynamic set creation for advanced multidimensional analysis in Excel.
Learn MoreCUBESETCOUNT Function
The CUBESETCOUNT function returns the total number of items within a set created by the CUBESET function. This is essential for Power Pivot and OLAP cube analysis, enabling dynamic counting of set members without manual enumeration.
Learn MoreCUBEVALUE Function
The CUBEVALUE function retrieves aggregated numerical data from OLAP cubes connected to your Excel workbook. It serves as the primary tool for extracting specific metrics and measures from multidimensional data sources using MDX expressions.
Learn MoreENCODEURL Function
The Excel ENCODEURL function converts a text string into a properly formatted URL-encoded string by replacing special characters with percent-encoded hexadecimal equivalents. This ensures URLs are safe for web transmission and API calls.
Learn MoreWEBSERVICE Function
The WEBSERVICE function retrieves data from web services on the Internet or Intranet by making HTTP GET requests directly within Excel formulas. This powerful capability enables dynamic data fetching without leaving your spreadsheet.
Learn More