dbTalk Databases Forums  

Validating data after cube build.

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


Discuss Validating data after cube build. in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dave McChristie
 
Posts: n/a

Default Validating data after cube build. - 11-03-2003 , 04:37 PM






I am looking for an idea on how to handle the following situation. We have
a catalog that takes about 1.5 hours to process. This catalog is processed
over night after data is loaded. We want to be able to have a user
"validate" the data before allowing all users to see it. 99% of the time
the data is good so there is no need to validate. 1% the data load was bad
and the cube is not usable. We need to reload data and reprocess the cube.

I could process a test catalog and have the user validate that. When given
the OK I could then process the live catalog. The problem with this is that
there would be a 1.5 hour time lag between when the OK we given and when the
live catalog was built. Idealy I am looking for a way to "switch" catalogs
quickly. A rename type ability would be great. I could leave the live
catalog out there and build a test catalog. When it was OK'ed I could
rename the live catalog to yesterday and then rename the test catalog to
live. This is one possible solution (If we could rename catalogs)

I would be grateful for any suggestions anyone might have.

Thanks,

Dave McChristie
Systems Analyst
Kerry Inc.



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.