I have delete the my dimension file in UJFS and re created. then the hierarchies data on PARENTH1,PARENTH2 and PARENTH3 data is gone. So when i manually adjust the PARENTH1 and H2 the Process dimension is taking much time to run for less data. I have 4000 lines where in i have to maintain the PARENTH1,PARENTH2 and PARENTH3.
Is there any other way to do this?
There are Many SQL statements running in background. it trying to re-create indexes every time i process few lines of hierarchies. Will that happen every time when we process hierarchies?
Thanks in Advance,