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

?????? ????????? ?????? ?????????
???? ???????: 915795 - ??? ???????? ???? ????? ????? ??? ???????.
BUG #: 445 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

??? ????? ??????? ????????? (MDX) ????????? ????????? ?? ?????? ???? ?? Microsoft SQL Server 2005 Analysis Services ? ????? ??????? ???????:
  • ???? ????? ???? ?? ??????? ?????? ????????? MDX. ??? ???? ??????? ?? ?????? ??????? ????? ?????? ????? 12 ????? ?????? 4 ????? ??????? ??????.
  • ??? ??? ?????? ???? ????? ??????? ???? SQL ?????? ??? ???? ????? ????????? ? ????? ????? ?? Analysis Services ???? ??? ???? ?????? ???????? ?? ????? ????? ?? ?????????.
???? ??? ??????? ??? ????? ???????? ?????????:
  • ????? ????? "?????? ??????" ??? ???? ?? ???? ?? ??????? ?? ??????? ???????? ??? ????????? ????.
  • ????? ??????? MDX ?????? ??? ???.
    select filter([Measures].members, [Measures].currentmember.member_caption = [Measures].currentmember.member_caption) on columns from [Adventure Works]
?????? ??? ??? ???? ?????? ????? "?????? ??????" ??? ????? ??? ?????? ????? "?????? ??????" ?? ???? ??? ???????.

?????

???? ??? ??????? ???? ???? ????? ?? ????????? ?????? ?? "????? ?????". ?? ???? ??? ????? ????? ?????? ???????. ??? ????? ????? ??? ????? ??????? ProcessingMode ??? ?????? LazyAggregations. ???????? ??? ???? ?? ???? AttributeRelationship ???? ????? ??????? RelationshipType ?????? Flexible. ??? ??? ???? ?????? ????? "????? ???????" ??? ??? ????? ??? ????? ????? ????? "?????? ??????" ???? Analysis Services ????????? ????. ???????? ??? ???? ?? Analysis Services ?????? ????? ?? ?????????.

????

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

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2005. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

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

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

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

?????? ??? ??????? ??????? ??? ?? ???? ???? Analysis Services ????? ??? ???? ?????????.

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

??? ???? ??? ????? ????? ???? ????????? ??? ????? ??? ??????? ??????. ??? ???? ???? Analysis Services ???????? ????? ?? ?? ????? ????? ??? ???????.

??? ?? ????? ???? ????????? ??? ????? ??? ??????? ?????? HTTP ??? ????? ????? ??????? ?????? ?? Microsoft (IIS) ??? ????? ??? ??????? ??????. ??? ???? ??? ????? ????? IIS ??? ????? ??? ??????? ??????.

??? ?? ????? "????? ?????" ????? ????? ??? ????? ???? ?????? SQL Server ??? ????? ??? ??????? ??????. ??? ????? ??? ?????? ????? ????? ??? ??????? ?????? ?????? ???? Msmdredir.dll ???? ?????? SQL Server.

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

?? ??? ???? ????? ?????.

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

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??????? ?????? ??? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? x 86 ?????????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ???????????????
Msmdlocal.dll9.0.1530.015,588,56801 ???? ????08: 34
Msmdpump.dll9.0.1530.03,913,94401 ???? ????08: 32
Msmdspdm.dll9.0.1530.0154,32801 ???? ????08: 32
Msmdsrv.exe9.0.1530.014,567,12801 ???? ????08: 34
Msmgdsrv.dll9.0.1530.05,935,83201 ???? ????08: 33
Msolap90.dll9.0.1530.04,204,76001 ???? ????08: 33
SQL Server 2005 ?? ?? x 64 ?????????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ???????????????
Msmdlocal.dll9.0.1530.030,018,77601 ???? ????07: 52
Msmdpump.dll9.0.1530.04,959,44801 ???? ????07: 51
Msmdsrv.exe9.0.1530.029,343,44801 ???? ????07: 52
Msmgdsrv.dll9.0.1530.08,910,04001 ???? ????07: 51
Msolap90.dll9.0.1530.05,668,56801 ???? ????07: 51
SQL Server 2005 ??????? ?? ?? IA-64
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ???????????????
Msmdlocal.dll9.0.1530.048,429,78401 ???? ????07: 56
Msmdpump.dll9.0.1530.06,528,72801 ???? ??????: ??
Msmdsrv.exe9.0.1530.047,463,12801 ???? ????07: 56
Msmgdsrv.dll9.0.1530.012,842,20001 ???? ????07: 55
Msolap90.dll9.0.1530.07,687,38401 ???? ??????: ??

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???". ?? ????? ??? ??????? ???? ??? ?? SQL Server 2005 ?????? ????? ?????? Service Pack 1.

??????? ????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 915795 - ????? ??? ??????: 23/????/1428 - ??????: 1.4
????? ???
  • Microsoft SQL Server 2005 Analysis Services
????? ??????: 
kbmt kbautohotfix kbsql2005presp1fix kbhotfixserver kbqfe kbpubtypekc KB915795 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????915795

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

 

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