Hi, all
Looks like I have to run HIERARCHYUPDATEDIRECT function explicitly by the end of copying hierarchies to fix the issue. All good now. I have to admit I never use DIMENSIONUPDATEDIRECT function in the past. Probably I should follow the best practice to reduce the footprint in RAM. :D
------------------------------
mvp morgan
------------------------------