学步园

BEGIN TRANSACTION
go
UPDATE CUBE [Adventure Works DW] 
set ([Measures].[Sales Amount Quota],
[Dim Employee].[Dim Employee].&[285],
[Dim Time].[TimeKey].&[1]) = 669002.0000
USE_EQUAL_ALLOCATION
go                        
COMMIT TRANSACTION 
go

select [Dim Time].[Fiscal Year -  Fiscal Quarter -  English Month Name].[All] on columns 
                        from [Adventure Works DW] 
                        where  ([Measures].[Sales Amount Quota],
                          [Dim Employee].[Dim Employee].&[285],
                          [Dim Time].[TimeKey].&[1])