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

?????? ????????? ?????? ?????????
???? ???????: 927165 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

????? ???

???? ??? ??????? ????? ?????? ??????? ?????? FORMAT_STRING ?? Microsoft SQL Server 2005 Analysis Services. ???? ??? ??????? ?????? ???? ??????? ??????? ?????? FORMAT_STRING ?? ??????.

??????? ????

??? ??????? ??? ????? ??????? ?????? ??????? (MDX) ?? SQL Server 2005 Analysis Services ?? ????? ??????? ?????? FORMAT_STRING ??????? ???? ?? ??????? ??? ????? ????? ?? ?? ???????. ????? ??? ?????? ?? ?????? ?? ????? ????? SQL Server 2000. ?? ????? ??? ??????? ??? ????? ?????? ?? ????? ????????.

??? ??????? ???? IIf ??? ????? ??????? ?????? FORMAT_STRING ??? ????? ????? ?? ????? ?????? ???? ??????.

??? ??????? ????? ???? ? Count ????? ???? ????? ??????? ??? ????? ????? ??? ????? ?????? ???? ?? ???? Count. ??? ??? ????? ??????? ??? ?? ????? ?????? ?? ???? ??????, ??? ????? ????? ??????? ??? ????? ??????? ?????? ??????????. ?? ???? ?? ????? ?????? ????? ??????? ??? ????? ????? ??????? ??? ??????. ???? ??? ??? ???? ?????? ???? ????? ????? ????? ?? ?? ???? ???? ?????? ???? ???????. ????? ????? ????? ?? ????? ???????. ????? ??? ??????? ????? ????? ??????? ?? "?????".

??? ???? ??????? ?? ?? ???????? ????????? ??????. ??? WITH
WITH MEMBER [Employee].[Employee].[Rank1Emp] AS 'RANK([Employee].[Employee].&[47], [Employee].[Employee].members)' SELECT [Employee].[Employee].[Rank1Emp] ON 0 FROM [Adventure Works]
????? ??? ????????? ?????? ???? Rank1Emp ?? ????? ????? ???? ??? ??? ??? ??????? ????? ?????? "????? ???????? ??????".

?????? ??? ????????? ??????.
WITH MEMBER [Measures].[Rank1Emp] AS 'RANK([Employee].[Employee].&[47], [Employee].[Employee].members)' SELECT [Measures].[Rank1Emp] ON 0 FROM [Adventure Works]
????? ??? ????????? ?????? ???? Rank1Emp ?? ????? ????? ?? ?????? (???????) ??? ????? ?? ??? ??????? ???? ?? ??????? ????? ???????.

??? ????? ?????? ?? ?? ??? ????? ????? ??????? ??????? ???? ???? ????? ?? ????? ????? ???????. ??? ???? ??????:
WITH MEMBER [Employee].[Employee].[Rank1Emp] AS 'RANK([Employee].[Employee].&[47], [Employee].[Employee].members)', format_string="#" SELECT [Employee].[Employee].[Rank1Emp] ON 0 FROM [Adventure Works]
??? ?????? ????? ?????? ??????? ?????? FORMAT_STRING ?? SQL Server 2005 Analysis Services.
?? ??? ??????????? ??? ??????
????????????
?????? ?? ???????? ??????? ???? ?????? ??????? FORMAT_STRING ?????? ???????.
CALCULATE (???? ?????? ?????? ?????? ????????) ?????? ??????? FORMAT_STRING ?????? ???????.
CALCULATE ?? ???? semiadditive ?????? ??????? FORMAT_STRING ?????? ???????.
??? A ????? ?? ??????? ???????? ???? ???? ?????.
?????? (a, b, ? z) ????? ?? ??????? ???????? ???? ???? ?? ?????? ??????? ?????? ????? ????.
-a????? ?? "a".
????? ????? ?? ??????? ???????? ?? ?????? ?? ??????? ?????.
a.PARENT, a.FIRSTCHILD, a.LASTCHILD ????? ?? ??????? ???????? ???? ???? ??? ???????.
CalculationPassValue(a,p,flag) ????? ?? "" ?? ???? ??????? "p" (?????).
??????? Sum ?? Min ???? Avg ?? Count(set) ?? ???? ????? ???? ??????? ??????? ??????? FORMAT_STRING ?????? ???????. ??? ??? ??? ???? ???? ?????? ??????? FORMAT_STRING ????? ?? ???? ??????.
??????? ???? Sum Min ? Avg(set, a) ??? ??? "a" ????? ? ??????? ??????? FORMAT_STRING ?? "a". ??? ??? "a" ??? ???? ? ??????? FORMAT_STRING ????? ?? "a".

???????

???? ???????: 927165 - ????? ??? ??????: 17/????/1428 - ??????: 2.3
????? ???
  • Microsoft SQL Server 2005 Analysis Services
????? ??????: 
kbmt kbhowto kbinfo kbsql2005as KB927165 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????927165

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

 

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