Skip to Content

Conversion of Characteristic Values to SIDs taking more time

Hi All,

Data load from DSO to Cube is taking 2 hours for loading 2 Lakhs records.While checking the monitoring screen, Conversion of Characteristic Values to SIDs is taking more time. Right now, SID Generation is checked in DSO. While checking the SAP_INFOCUBE_DESIGNS, one the dimension is showing more records than Fact table. Right now we are facing this issue in Production, Can you please suggest how to minimise the data loading time from DSO to Info Cube.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 08, 2015 at 09:26 PM

    Hi Jalina,

    1. Check what object do not repeat data in dimension (0doc_num, 0prodorder, objects unique wich contains attributes).

    2. Create a new dimension and mark Line Item Dimension

    3. Move your characteristic here

    4. Transport and run a test in your QA system

    5. Transport and reload your cube in PRO.

    Check in google how to use sap_infocube_design, you can find many info.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jalina Vincent

      Hi Jalina,

      Your queries works with Multiprovider?, if yes, i think you need create archiving with new cubes for actual year and actual year - 1.

      That cubes must be in Multiprovider, and this is a simple way to access your data, only need load your cubes (actual and actual-1) with your historial cube.

                                      -->    Cube Actual Year    

      Datasource-->ODS -->    Historial Cube (Others year)      ---> MP --> Querys

                                      -->    Cube Actual Year - 1

      Please, share what is your flow?.

      Regards,

  • avatar image
    Former Member
    Jan 08, 2015 at 09:19 PM

    Hi Jalina,

    as you already said one dimension has more records than fact, remodel the cube and make the dimension as line item, this will reduce your load time

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2015 at 11:33 AM

    Hi,

    Accept with franc. if your cube dimension occupy 20% of the fact table size then you can use line item dimension. About dimension % details you can find them thru above report - SAP_INFOCUBE_DESIGNS.

    if your DSO is just used for staging purpose then you better switch off sid generation.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 21, 2015 at 06:16 AM

    Hi Jalina,

    The best solution for this problem is to remodel the info cube only. As you said 2 years of data is already available in info cube but i think it is not much huge. but if you don't remodel the info cube then there would be great problem because data is getting increase day by day. so you can refer copying of info cube, remodel the old info cube and reload.

    Thanks,

    Swapna

    Add comment
    10|10000 characters needed characters exceeded