When a dimension is based on a derived table, if a user creates a new record in the derived table then the default dimension on that record should default to its on value.  For example; project is setup as a dimension, derived from the project table.  When user creates a new project its default dimension should default to the newly created project id.

This should be parameterised for each dimension (i.e. Update dimension on records in derived table)