Report Portal

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

 

2007-2015 VidasSoft Systems Inc.