FIX: ??????? MDX ?? ???? ??????? ??? ????? ??? ????? ????????? MDX ??? ??? ????? ?????? ???? ??????? ??? ?????? ????? ?? SQL Server 2005 Analysis Services

?????? ????????? ?????? ?????????
???? ???????: 950969 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50002586 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????. ?? Microsoft SQL Server 2005 Analysis Services ? ????? ????? ??????? ??????? ?????? ??????? (MDX) ???? ????? ??? ??? ????? ?? ???? WHERE. ??? ????? ?????? ???? ??????? ??? ?????? ?????. ?? ??? ?????????? ?? ????????? MDX ?????? ??????? ??? ????? ??? ????? ??????? MDX.

????

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 7. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
949095???? ??????? ???????? 7 SQL Server 2005 ?????? ????? ?????? SP2
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ???? Microsoft ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP2
??? ????? ????????? ??????? Microsoft SQL Server 2005 ??? ???? SQL Server ?????. ??? ????? ??????? ???? SQL Server 2005 ?????? ????? ?????? SP2 ??? ????? SQL Server 2005 ?????? ????? ?????? SP2. ???? ???????? ??? ????? ????????? ??????? ???????? ?? ???? ???? ?? SQL Server ?? ???? ???? ?? SQL Server ???????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

??????? ????

????????? ?????? ?? SQL Server 2005 Analysis Services

????? ?????? ?? 7 ??????? ???????? ?? SQL Server 2005 Analysis Services

???? ??? ????????? ??????. ????? 7 ??????? ???????? ?? SQL Server 2005 ?????? ????? ?????? SP2 (SP2). ?? SQL Server ???? ????? ??????? ? ???? ?? ????? ????? ?????. ????? ??????? ?? ??? ????? ?????? ?????? ?? ????? ?????? ForceCommitTimeout. ?? ??? ?????????? ??? ????? ???? ??????????? ??? ??????? ??? ??????.

??????? ?????? ??? ??? ??????? ?? ??? ????? ????????? MDX ??? ??? ????? ?? ????? ????? ?????.

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

  1. ??? ????? SQL Server ????? Studio ?? ?? ?????? ????? Analysis Services ???? ????? ??? ????? ?????? ????? AdventureWorks ?????.
  2. ??? ???? ??????? MDX ????? ??? ?????? ?????? ??? ????? ?????? ?????? DW ??? ??? ??????? ???? ? ?? ???? ??? MDX.
  3. ?? ???? ????????? MDX ??? ???? MDX ??????? ?? ???? ??? ?????.
    WITH 
    MEMBER [Date].[Calendar].[Span] AS 'AGGREGATE(DateSet)' 
    SET DateSet AS '{[Date].[Calendar].[Date].&[185]:[Date].[Calendar].[Date].&[549]}' 
    SELECT 
    {measures.[Order Count]} ON COLUMNS, 
    NON EMPTY {[Product].[Product Categories].[Category].&[1]} ON ROWS 
    FROM [Adventure Works] 
    WHERE ([Date].[Calendar].[Span],[Organization].[Organizations].&[4])
    
    MDX ????????? ?????? ??? ????? ??? ????. ????? ????????? MDX 18,282. ??? ???? ???? ??????? ??????? 3,451.
?????? ??? ???? ?? ????????? ??? ????? ?? ?? ??????? ? ?????? ??? ??????? ??? ??? ??????? ????? ?????? ???? ??????? ???????? ???? ????? ??? ??????? ?????? ?????? ?? ????? "????? ??????? ?? Microsoft" ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
949095???? ??????? ???????? 7 SQL Server 2005 ?????? ????? ?????? SP2

?????

?????? ??? ???? ?? ????????? ??? ??????? ????????? ???? ????? ??? ???? ?????? Service Pack 2 ?????? ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP2
????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005
????? ?? ????????? ??? ??????? ??????? ?????????? ?? SQL Server 2005 ?????? ????? ?????? SP2 ?? ?????? ???? Microsoft ?????? ??? ?????:
http://go.microsoft.com/fwlink/?LinkId=71711
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 950969 - ????? ??? ??????: 11/???? ??????/1429 - ??????: 1.2
????? ???
  • Microsoft SQL Server 2005 Analysis Services
????? ??????: 
kbmt kbsql2005as kbhotfixrollup kbfix kbpubtypekc kbqfe kbexpertiseadvanced KB950969 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????950969

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

 

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