MDX INF:: ????? ????????? ?? 10 ?????? ???? ??????? ????????? ???? 5 ?????? ??? ?? ???????

???? ???????: 304386 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

????? ???? ???? ?? ??????? ?? "???? ??? ??????? ???? 10 ? ?? ?? ???????? ?????? 5 ?????? ?????" ? ???? ??? ?????? ????? ??????? ??????? ????? ??????? (MDX) ?????? ??????? ??????? ???????? "???? ??????".
???? ??? ?????? | ????? ???????

??????? ????

?????? ?? ??????? ????? ????? ?????? 2000 FoodMart ???? ??? ?????? ?????? Microsoft 2000 ????? ???????. ????? ????? ????????? ?????? ?? ????? ????? MDX ???? ??? ????? ????? ?? "????? ???????". 

--The top 10 customers can be defined in a named set, using the TopCount
--function to limit the set and to return the names of the customers with
--the 10 highest Units Sales for the year 1997. 

WITH SET Top10Cust AS 
'TopCount( { [Customers].[Name].Members }, 10, ([Time].[1997], [Unit Sales]) )'

--Then use the Generate and CrossJoin functions in the body of the query
--to combine the Top10Cust Named Set with the top 5 products for those
--customers. 

SELECT { [Time].[1997] } ON COLUMNS , 
Generate( {Top10Cust}, CrossJoin( {Customers.CurrentMember}, 
TopCount([Product].[Product Name].Members, 5, ([Time].[1997], [Unit Sales])))) ON ROWS 
FROM [Sales]

?????

????? ?? ????????? ??? ?????CrossJoin ? ????? MDX TopCount ???????? ??????? ???? ???? ??? Microsoft SQL Server 2000 ????????.
???? ??? ?????? | ????? ???????

???????

???? ???????: 304386 - ????? ??? ??????: 03/???/1428 - ??????: 2.2
????? ???
  • Microsoft SQL Server 2000 Analysis Services
????? ??????: 
kbmt kbinfo KB304386 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????304386
(http://support.microsoft.com/kb/304386/en-us/ )
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????