Skip to Content
avatar image
Former Member

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

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,

Manoj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 27, 2017 at 09:59 PM

    "I have delete the my dimension file in UJFS and re created." - not clear, what are you doing! Strange idea to delete something in UJFS.

    You can export dimension to text file, perform required adjustments in it and then import back using standard DM processes.

    4000 lines is not a lot!

    Add comment
    10|10000 characters needed characters exceeded