Skip to Content
Former Member
Jun 27, 2017 at 09:52 PM

BPC NW: Process Dimensions File Delete and Reprocessing. Hierarchies Changes with Long Run Time

126 Views Last edit Jun 27, 2017 at 10:53 PM 6 rev

Hi All,

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,