dbTalk Databases Forums  

SSABI cube processing error

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SSABI cube processing error in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gunnar Kuhi
 
Posts: n/a

Default SSABI cube processing error - 04-05-2004 , 10:04 AM






Hello,
I have a problem with time dimension in my customized application upon SQL
Server Accelerator BI. When I process cube there comes an error like this:
Analysis Server Error: Processing error [Object does not exist] 'All
01.01.2003 01.07.2003 01.08.2003' ;
There is BI standard time dimension and when I take off from cube
week.standard virtual dimension it works.

Gunnar



Reply With Quote
  #2  
Old   
Bas Kersten [MSFT]
 
Posts: n/a

Default 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."


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.