We have a dimension that is used in one fact table.  We would like to use the
same dimension for another fact table.  The issue is that we need to add more
records to the dimension table to meet the needs of the new fact table.  Some
dimension members will only be used in one of ...

I'm having an issue with our data warehouse.  Every night it is refreshed
with data from our production environment, and then more SSIS jobs are run
that take data from the data warehouse and put it into specific reporting
tables.  It's a lot of data moving around, and since our ...