dbTalk Databases Forums  

Refresh problem

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


Discuss Refresh problem in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jerstep@yahoo.com
 
Posts: n/a

Default Refresh problem - 09-08-2005 , 08:50 AM






Sorry about this but this is essentially a re-post. I've been happily
adding monthly data into my data warehouse and reprocessing the cube
(monthly) to refresh the data.

This month however, after having carried out the same process. the
refreshed data in the cube does not show the latest month's data.

I've tried reprocessing all dimensions, refreshing the data, fully
reprocessing the cube, reprocessing the partitions (partitions are by
financial year) and nothing seems to include the new month's data.

I've taken an archived version of the OLAP database and restored that
and still no joy.

I have created a new cube with just a Time dimension and the new data
IS there.

Does anyone have any ideas ?

Thanks for any help.
J.


Reply With Quote
  #2  
Old   
jerstep@yahoo.com
 
Posts: n/a

Default Re: Refresh problem - 09-08-2005 , 10:09 AM






Thanks for all the posts ! All sorted now. One of my dimensions failed
to load correctly and as a result restricted (by date) the data loaded
into the cube.

Regards,
J.


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.