FIX: ???? MDX CUBE UPDATE ?????? ???? ?????? ?????? writeback ??? ???? ?????

?????? ????????? ?????? ?????????
???? ???????: 834491 - ??? ???????? ???? ????? ????? ??? ???????.
??? #: 14194 (Plato7x)
Microsoft ?????? ????????? ??????? Microsoft SQL Server 2000 ???? ???? ??????? ???????. ??? ????????? ??????? ??????? ????? ?? ????? ???? ???? ????????? ??????? ???? ??? ????? ???? ?????? ???? ?? ??????? ?? ????? ??????? ?????? SQL Server 2000 ??????.
????? ???? | ?? ????

?? ??? ??????

???????

?? SQL Server 2000 ??? ??????? ???? writeback ??? ????? ????? ?????? ?? ???? CUBE UPDATE ??????? ?????? ??????? (MDX) ???? ???? ?? ??? ??? ????? ???? ????? ???????? ?????? ???????. ??? ????? ?????? ???????? ?? ?????? writeback ?????? ??????? ???? ??? ????? ?? ?????? writeback ???? ???? ???? CUBE UPDATE. ??? ??? ??? ???? ?????, ???? ????? ?????? ?? ???? ????? ??????. ?? ???? ??? ?????? ??????? ???? ????? ??? ????? ????? ???? ????? ??????. ???????? ???? ???? ?????? ?????? ??? ???? ???? ?????? ??? ?????? ?? ??? (0).

??? ???? ??????? ???? ????? CUBE UPDATE MDX ??????? 1998 ?????? ? ???????? ?????? ???????? ?????? ???? ?????????? "??? ???? $ 750,000. ??? ????? ???? ????? ??? ????? ??????? ?? ?????????? ???????? ??? ????????? "?????? ???????? ?????? ????? ???????" ???????? ?? ?????????? ?? ????? ???????.

UPDATE CUBE
[Budget] SET  
( [Category].[All Category].[Forecast],  
[Account].[All Account].[Net Income].[Total Expense].[General & Administration],
[Store].[All Stores].[USA].[CA], 
[Time].[1998],
[Measures].[Amount]  ) = 750000

USE_WEIGHTED_ALLOCATION BY 
iif(
IsEmpty(( ParallelPeriod([Time].[Year], 1, [Time].Currentmember), 
[Category].[All Category].[Current Year's Actuals], [Store].Currentmember, 
[Account].[All Account].[Net Income].[Net Sales].[Gross Sales], [Measures].[Amount])),
-- Sales Value is empty for the previous year so leave the new value as NULL.
NULL, 
-- Otherwise take the Current Years Actual Gross Sales for the current store, 
--divide it by the total for all of California to get the percentage contribution 
--of this store to Gross Sales and allocate that percentage of the new 
--General & Administration value to this store.
( ParallelPeriod([Time].[Year], 1, [Time].Currentmember) ,  
[Category].[All Category].[Current Year's Actuals], [Store].Currentmember, 
[Account].[All Account].[Net Income].[Net Sales].[Gross Sales], [Measures].[Amount] )    /  
([Time].[1997], [Category].[All Category].[Current Year's Actuals], 
[Store].[All Stores].[USA].[CA], [Account].[All Account].[Net Income].[Net Sales].[Gross Sales], [Measures].[Amount] )  )

??? Alameda ??? ?? ???? ????? "?????? ????????" ?? ??? "????? ??????" ????? ??????? "?? ???? ? ???? ????? Alameda ??? ??? ??? ??????? ?????? ???????. ??? ???? ?? ???? ????? ??? ??????? UPDATE CUBE ?? ????? ??????? SELECT ??????? ????? ??????? ???? 0.002 ?? Alameda:????? ON .Members
SELECT
[Measures].Members   ON COLUMNS,
{ [Store].[All Stores].[USA].[CA],   Descendants([Store].[All Stores].[USA].[CA], [Store].[Store City])  } 
ON ROWS
FROM [Budget]
WHERE 
( [Category].[All Category].[Forecast], 
[Time].[1998] , 
[Account].[All Account].[Net Income].[Total Expense].[General & Administration] )
??????? ???????? ???? ?????? ??????:
?? ??? ??????????? ??? ??????
?????
ca750000
Alameda
???? Beverly215575.4595
??? Angeles257017.7488
????? ???256479.9204
??? ????????20926.8713
???? ?????? ?????? ????? ??????:
?? ??? ??????????? ??? ??????
?????
ca750000
Alameda0.002
???? Beverly215575.4575
??? Angeles257017.7488
????? ???256479.9204
??? ????????20926.8713
???? ????? ???? ?????? ??? ???? ??????? ?? ?????? writeback ??? ????? ??? ???????.

????

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

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft SQL Server 2000. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211????? ?????? ??? ???? ???? ???? ?? SQL Server 2000

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ??? ???? ????? (?? ??????) ???????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ???????? ??????? coordinated (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
   Date         Time   Version    Size       File name
   -------------------------------------------------------
   16-Jul-2004  01:51  8.0.960.0    221,760  Msmdcb80.dll
   16-Jul-2004  02:17  8.0.0.960  4,063,808  Msmddo80.dll
   16-Jul-2004  01:45  8.0.960.0  1,036,864  Msmdgd80.dll
   16-Jul-2004  01:39  8.0.960.0    172,608  Msmdpump.dll
   16-Jul-2004  02:27  8.0.0.960  9,642,564  Msmdsgn80.dll
   16-Jul-2004  01:40  8.0.960.0  1,839,684  Msmdsrv.exe
   16-Jul-2004  02:03  8.0.960.0  2,085,456  Msolap80.dll
   16-Jul-2004  01:17  8.0.960.0    446,524  Msmdsgn.rll
   16-Jul-2004  00:58  8.0.960.0    213,068  Msolap80.rll

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

SQL Server 2000 Analysis Services 64-??

?? ????? ?????? ?? ????????? ??? ????? ????? ???? ???? ????? ??? ???? ???? ?????? SQL Server 2000 Analysis Services 64-?? ?? ?????? ?? ??? ??? ????? ???? ?? ?????? ?? ??? ??????? ?? SQL Server 2000 Analysis Services 64-?? Service Pack 4 ? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
831653???? ???? ??????? ?????? ?? 64 2000 ????? ?????

?????

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

?? ????? ??? ??????? ???? ??? ?? Microsoft SQL Server 2000 ?????? ????? ?????? Service Pack 4.

??????? ????

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

???????

???? ???????: 834491 - ????? ??? ??????: 30/????/1427 - ??????: 2.3
????? ???
  • Microsoft SQL Server 2000 Analysis Services
????? ??????: 
kbmt kbhotfixserver kbqfe kbqfe kbsqlserv2000presp4fix kbfix kbbug KB834491 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????834491

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

 

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