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