Hello,


I have a question about use of many-to-many dimensions. There is a
huge fact table joined to a dimension, and that dimension has a
factless many-to-many table with attributes attached. Question: when
attribues of a dimension record which has been used in the fact table
in the past change, do you have to re-compile the whole cube?

As an example, let's say you have a sales fact table and customers
dimension. There is a factless many-to-many table called
customer_parameters. At one point, one parameter changes for many
customers who've had sales in the past (for example, they change from
single to married). Do you have to re-compille the whole cube every
time such updates take place in a dimension? Is there a way to avoid
and/or delay that?


Thanks!
S.