Hi,
Lately I had to increase the size of a table varchar column.
This column is used in a cube dimension attribute.
After the change, cube processing ended-up in error.
I had to first refresh the dataview and then go manually change the KeyColumns Datasize property to increase it as well.
Is there a better way? I find this very dangerous.
As a minimum, a dependency check should include cubes using that metadata.
I notticed the same type of problems on the SSIS sides, metadata becomes out of synch. This is not a show stopper but these are missing link in the dependency food chain.
Sub-systems are not integrated, they are in a vacuum. A little less than with 2000 but still in a vacuum.
Philippe
Very valuable observation.
This is something we are going to take a look at for the next version :)
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment