Non Materialized Reference Dimensions, ProcessUpdate and Indexes
I recently had a requirement to dynamically (some processing allowed) to make certain fact data appear depending on if a product was "active" or not active.
One potential design for this is to make use of a default member of is_active = Y on the product dimension. The downside to this would be having to run a ProcessUpdate on the product dimension and then having to update the indexes on the related fact tables.
Read more...Tags: design, management, process, dimension