Incremental cube update with changing data in M2M dimension

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.

you talk about a change in your factless table, this is NOT a change in the
dimension.
in this case you have to reprocess the factless table to make sure that the
customers parameters are correctly associated to the customers.

because you don't change the dimension himself, there is no need for a full
process of the sales.

Now... if your parameters dimension is directly attached to your sales fact
table (or referenced to the fact table), in this scenario you have to
reprocess your sales history. but with a many many, there is no need for a
process.


wrote in message

> 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.