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
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com