Skip to Content

Conversion of Characteristic Values to SIDs taking Long time

Hello experts,

I know this has been discussed many times on the forum but not finding the suitable solution for my scenario.

I have a flow like DS -> DSO (SID Generatio During Activation checked) -> Cube.

Till yesterday my DTP was taking 17 mins to load 900K records & today suddenly it's taking more than 2 hrs to complete the same DTP with average same no of records.

Cube is set to full delete (without dimension table content) & reload.

I have checked Report SAP_INFOCUBE DESIGNS & two dimensions among the cube are 300% of the FACT table !! But has been from the past one year & not sure why DTP has started taking long time from today itself..

Harshawardhan.

COnversion_SID.JPG (81.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 09, 2015 at 02:42 PM

    Hi Harsha,

    You done most of the analysis.

    On the same way you think about introducing line item dim(to cube) which will improve loading performance to cube.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded