DTP Load cube FIND or TAKE SIDs step - time consuming

[former_member204732]

Dear Expert,

Loading records in cube in our system - the DTP steps FIND or TAKE SIDs take 99% of the loading time.

Any issue reason ? Any solution to propose ?

Thanks a lot

DD

[Former Member]

https

://wiki.scn.sap.com/wiki/display/

BI/Number+Ranges+for+Dimensions+and+SID+tables

Check this, it might be due to buffer or range generation issues.

[former_member231709]

please, check note 2255375 - Find or Take SIDs step of DTP load is very slow

Also read: https://wiki.scn.sap.com/wiki/display/BI/Low+performance+during+DTP+load+into+an+InfoCube+at+step%3A...