Let's take Foodmart Warehouse cube.
If we want to handle e.g. the Warehouse dimension as Slowly Changing
type 1 (rewriting history), without having to reprocess all partitions
(years), I decided to build a new Warehouse dimension as virtual
dimension, by adding country, state etc as member properties to a
Warehouse physical dim, and building a virtual dim using this member
properties.
Then I played changing for instance the State of Cities, bringing Los
Angeles into OR, or into a NEW STATE.
After incremental update of the physical dim on which the virtual dim
is based, the new hierarchy of Country-states-cities can be immediatly
seen in the Warehouse cube, but data are wrong, for instance I see in
1997, after having put Los Angeles into a NEW STATE:

NEW STATE total (store invoice) = 11.634,92 (correct)
Los Angeles (store invoice) = 4.318,37 (it shoul be 11.634,92)

It seems that the error appears randomly, because sometimes, after an
incemental update, I get the right numbers.

Is that perhaps due to bug 14240 ?

http://support.microsoft.com/default...b;en-us;834490

I think it's a very serious bug, because it makes the use of virtual
dim very dangerous.

Francesco