RE: SSABI cube processing error -
04-06-2004
, 08:14 AM
Hi,
I have seen this one before it was some problem wit running the dso script
and the locals of the server (Canadian locals), you could try one of the
following:
-deleting week.standard dimension and add manually (check member key column
of day level )
-try putting server on US local
-make sure locals of AS server and the SQL server are the same
-you can also try something as:
*modify the time.standard dimension by changing the member key column for
levels year, quarter and month as:
convert(varchar(12),"Dim_Time_Std_Year"."Year_Idx" ,101)
convert(varchar(12),"Dim_Time_Std_Qtr"."Qtr_Idx",1 01)
convert(varchar(12),"Dim_Time_Std_Mon"."Mon_Idx",1 01)
edit the slicing value for the partition, processing the partition,
HTH,
Bas
"This posting is provided "AS IS" with no warranties, and confers no
rights." |