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

?????? ????????? ?????? ?????????
???? ???????: 912136 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

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

??????? 1

?? ???? ??????? ?????? ????? ????? ??? ???????? ????? ?? ????? ????? "?????" ?? ????? ??????? ???????? ?? "???? ????".

??????? 2

??? ????? ???????? ????? ???? "????? ???? ???????" ??? ???? ??? ??? ?? ??????? ?????? ????? ?? ??????? ?????? ???????.

?????

??????? 1

???? ??? ??????? ??? ????????? ???????? ?????? ??? ????? ????? ??? ??? ?????. ???? ??? ??? ??????? ?? ????? ??? ???? ????? ???????. ???? ??????? ?????? ??????? (MDX) ?? ???? ???? ?????? ??????? ?? ??? ?????????. ??? ???? ?????? ??? ??????? ??? ????? ????????. ?? ????? ?????? ????? ???????.

?????? ????? "????? ???? ???????" ????? ??????? ??? ?????? ??? ????? ?????? ???? ????? ?????. ???????? ??? ????????? ? ???? ????? "????? ???? ?????" ???? ?? ??? ?????.

??????? 2

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

????

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

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

???? ??????

?????? ????? ??? ?????? ??? ????? ??????? ??????? ??????? ?? ??? "???? ?? ?????????".

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

??????? ??????? ?????? ??????? ?????? ??? ?????? ???. ???? ??? ??????? ?????.
  1. ?? SQL Server ????? ???? ????? Studio ? ???? ??????? ????? ????? ?????? ?????? DW Standard Edition.
  2. ?? "??????" ???? "? ?? ?????? ?????? ??? ?? ???? ????? ??????? ??? Works.cube ????? ?????? ??????" ???? ?????? ".
  3. ?? "????" ?????? "? ???? ??? ????? ??????? ????????.
  4. ?? ??? "Script ??????" ? ???? ??? ????? [????? ????? ??? ?????].
  5. ??? ???? ??????? ?? ???? ??????? ???????? "? ???? ??? ??? Script ???? ???" ????????? ?????? ".

??????? ???? ????? ??? ??????? 1

  1. ?? ??? "????????? ??????" ?? ????? ??????? ???????? ???? ???? ????????? ???????? ???????.
    Create Member CurrentCube.[Date].[Fiscal Date Calculations].
    [Year to Date] AS "NA";
  2. ??? ??? ??????? ?? ????? ????? ????? ?? ????????? ????????. ???? ???? ????????? ???????? ??? ???.
    Create Member CurrentCube.[Date].[Fiscal Date Calculations].[Year to Date] AS "NA" ;
  3. ???? CTRL + S ???? ???????.

??????? ???? ????? ??? ??????? 2

  1. ?? ??? "????????? ??????" ?? ????? ??????? ???????? ???? ?????? ??????? ?? ????????? ????????.
    Scope(
           {
             [Measures].[Internet Sales Amount]
           }
    ); 
    
    ( [Date].[Fiscal Date Calculations].[Year to Date], 
    [Date].[Fiscal Year].[Fiscal Year].Members ) = 
    
      Aggregate(
                 { [Date].[Fiscal Date Calculations].DefaultMember } *
                 PeriodsToDate(
                                [Date].[Fiscal].[Fiscal Year],
                                [Date].[Fiscal].CurrentMember
                 )
      ) ;
    
    End Scope ;
  2. ????? ???? ?????? ??? ????? ????? ??????? ????? ?????? ??? ??? ????? ???????? ???????? ?????. ?????? ??????? ??????.
    [<SelectedCubeDimension>].[<SelectedCubeDimensionKeyAttribute>].Members
    ??????<SelectedCubeDimension> ?????? ?????? ????? ?????? ??? ??? ????? ???????? ???????? ?????. <SelectedCubeDimensionKeyAttribute> ?????? ?????? ????? ??????? ??? ????? ??????.

    ?? ??? ??????? ?????? ??????? ?? ????????? ???????? ??? ????? ????? ???????.
    [Date].[Date].Members
    ???? ?????? ?????? ?????? ????? ?? ????????? ???????? ??? ????? ??? ????? ?? ????????? ????????.
    Scope(
           {
             [Measures].[Internet Sales Amount]
           }
    ); 
    
    ( [Date].[Fiscal Date Calculations].[Year to Date], 
    [Date].[Fiscal Year].[Fiscal Year].Members,
    [Date].[Date].Members ) = 
    
      Aggregate(
                 { [Date].[Fiscal Date Calculations].DefaultMember } *
                 PeriodsToDate(
                                [Date].[Fiscal].[Fiscal Year],
                                [Date].[Fiscal].CurrentMember
                 )
      ) ;
    
    End Scope ;
  3. ??? ??????? ??? Microsoft SQL Server 2005.

?????

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

??????? ????

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

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

??????? ??????? ?????? ?????? ??? ?????. ???? ??? ??????? ?????.
  1. ?? SQL Server ????? ???? ????? Studio ? ???? ??????? ????? ????? ?????? ?????? DW Standard Edition. ???? ??? ??????? ????? ?? ?????? ??????:
    SQLInstallDrive: \Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Standard
    ??????SQLInstallDrive ?????? ?????? ????? ??????? ??? ?? ????? SQL Server 2005.
  2. ?? "?????? ??????" ????? ?????? ???? ??? ?????? ?????? ??? Works.cube ????? ?????? ?? ???? ??? ????? ??????? ???? ????? "????? ???? ???????".
  3. ???? ??? ??????.
  4. ??? ???? "?????? ?????" ??? ???? ????? ????? ?? ??????? ????????? ???????? ?? ???? ??? ??????.
  5. ?? "?????? ???? ?????" ????? ???????? ??? Date\Fiscal ?? ??????? ?????? ??????? ?????? ?????? ?????? ?????? ?????? ????? ?? ?? ?????? ???? ????? ????? ??? ????? ?? ????? ???????? ???????? ????? ????????. ???? ??? ??????.
  6. ?? ?????? "????? ???? ????????" ? ??? ?????? ????? ???????? ?????? ?? ??????? ??????? ???????? ?? ???? ??? ??????.
  7. ??? ????? ???? ????? ???? ??? ?????.
  8. ??? ??????? ??? SQL Server 2005.

????? ????? ????? ??????? 1

  1. ??? ????? ? ???? ??? ????? ??????? ???????? ?? "???? ??????".
  2. ?? ??? ?????? Script ??? ?????? ???? ???? [????? ????? ??? ?????] ?? ?????? Command.
  3. ?? ????? ??????? ?? ?????? ????? ?????.
???? ?? ???? ??????? ?????? ????? ?????.

????? ????? ????? ??????? 2

  1. ??? ?????, ???? Studio ????? ???? SQL ?? ?? ?????? ??? ???? SQL Server 2005 Analysis Services.
  2. ?? "??????" ???? "? ?? ?????? ????? ?????? ?? ???? ??? ????? ?????? ?????? DW Standard Edition.
  3. ??? ???? ???????? ???? ??? ??????? ???? ???? ???? ???? ??????? ????.
  4. ???? ????????? ?????? ?? ???? ????????? ?? ???? ??? F5 ?????? ?????????.
    SELECT
    [Measures].[Internet Sales Amount]
    *
    [Date].[Fiscal Date Calculations].ALLMEMBERS
    ON 0,
    [Date].[Fiscal].MEMBERS
    ON 1
    FROM [Adventure Works]
    
???? ?? ?????? ????? [????? ????? ??? ?????] ???? ??? ??????? ????? ?? ??????? ?????? ????? ???. ??????? ??? ????? ????? ????? ??? ???? NA.

?????

?????? ??? ???? ?? ????????? ??? ????? ????? ????? ????? ???????? ????? ?????? ?????? DW ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms143804.aspx

???????

???? ???????: 912136 - ????? ??? ??????: 07/???? ?????/1427 - ??????: 3.3
????? ???
  • Microsoft SQL Server 2005 Analysis Services
????? ??????: 
kbmt kbsql2005sp1fix kbsql2005olapsp1fix kbsql2005bi kbsql2005as kbprb kbexpertiseadvanced kbtshoot KB912136 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????912136

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

 

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