Microsoft Technologies
SQL Server,Business Intelligence, SQL Server DBA, Share Point, Dot Net
Pages
(Move to ...)
SQL Server
SSIS
SSAS
MDX
SSRS
SQL DBA
PPS
Interview Q & A
▼
Wednesday, November 4, 2015
Various MDX Queries
›
How do I find the bottom 10 customers with the lowest sales in 2003 that were not null? SELECT { [Measures].[Internet Sales Amount] } ON CO...
Tuesday, November 3, 2015
MDX TopSum Function
›
In Multidimensional Expression, TopSum function will sort the given data in the descending order and then selects the required number of re...
MDX TopPercent Function
›
In Multidimensional Expression, TopPercent function will sort the given data in the descending order and then selects the required number o...
MDX TopCount Function
›
In Multidimensional Expression, Topcount function will sort the given data in the descending order and then selects the required number of ...
MDX Tail Function
›
In Multidimensional Expression, Tail Function is used to select the required number of records from bottom of the source data. For ...
›
Home
View web version