When the workbook is connected to a Microsoft SQL Server 2005 Analysis Services or later data source, this function returns …

The CUBESETCOUNT function returns the number of items in a set. Syntax: CUBESETCOUNT(set) The CUBESETCOUNT function syntax has the following …

The CUBESET function defines a calculated set of members or tuples by sending a set expression to the cube on …

The CUBERANKEDMEMBER function returns the nth, or ranked, member in a set. Use this function to return one or more …

The CUBEMEMBERPROPERTY function returns the value of a member property from the cube. Use this Function to validate that a …

The CUBEMEMBER function returns a member or tuple from the cube. Use this function to validate that the member or …

COS Excel function is an inbuilt trigonometric function in excel which is used to calculate the cosine value of given …

Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable …

The Excel YEARFRAC function returns a decimal value that represents fractional years between two dates. You can use YEARFRAC to …

Week Number (WEEKNUM) is a date function in excel which gives us the week number for the given date in …