The MDX Tail Function used to select the required number of records from the bottom of the source data. For example, If you want to find the Bottom 10 performing products. Or, find the Bottom 10 regions with Lowest sales or to calculate Lowest Salary, use this MDX Tail function along with Order Function. MDX … Read more
The MDX Head Function is used to select the required number of records from the source data. For example, If you want to find the Top 10 performing products. Or you want to find the top 10 regions with the highest sales or to calculate the Highest Salary. We can use this MDX Head function … Read more
The MDX BottomSum function will sort the given data in the Ascending order. And then, MDX bottomsum selects the required number of records from the sorted data whose total is at least equal to the specified value. MDX BottomSum Function Syntax The basic syntax of the BottomSum in Multidimensional Expression is BOTTOMSUM (Set_Expression, Value, Numeric_Expression) … Read more
The MDX BottomPercent function will sort the given data in the Ascending order. Then MDX bottompercent selects the required number of records from the sorted data whose total is greater than or equal to the specified Percentage. MDX BottomPercent Function Syntax The basic syntax of the MDX BottomPercent in Multidimensional Expression is as shown below: … Read more
The MDX BottomCount function will sort the given data in the Ascending order and then selects the required number of records from the sorted data. For example, If you want to find the Bottom 10 performing products. Or you want to find the 10 regions with the Lowest sales or to calculate Lowest Salary. We … Read more
The MDX TopSum function will sort the given data in the descending order. Then selects the required number of records from the sorted data whose total is at least equal to the specified value. MDX TopSum Function Syntax The basic syntax of the MDX TopSum in Multidimensional Expression is as shown below: TOPSUM (Set_Expression, Value, … Read more
The MDX TopPercent function will sort the given data in the descending order. Then selects the required number of records from the sorted data whose total is greater than or equal to the specified Percentage. MDX TopPercent Function Syntax The basic syntax of the MDX TopPercent in Multidimensional Expression is as shown below: TOPPERCENT (Set_Expression, … Read more
The Multidimensional Expression or MDX Topcount function will sort the given data in the descending order and then selects the required number of records from the sorted data. For example, If you want to find the Top 10 performing products. Or you want to find the top 10 regions with the highest sales or to … Read more
The MDX Parent function will return the associate parent member of the specified member. For instance, If you are an Amazon developer and If one of your customers is looking for iPod on Amazon.com. As a developer, you have to display all the Apple products at the bottom of the page so that the user can browse … Read more
