Skip to Content
avatar image
Former Member

Performance issue extraction of data from the planning area outbound cube

In our DP implementation we have made an outbound cube and we have apporx 100,000 CVC with 20 key figures. We are facing problems in extracting the data from the planning area into our outbound cube (using BI7). I think that the number of CVC is too low to give a performance issue but the data extraction never ends.Even when we try to extract only one key figure we are still facing a lot of performance issues.

Could any one please tell me what might be the problem in here. Do you guys think aggregation of data at particular characteristics might be the solution.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 23, 2007 at 11:36 AM

    Hi,

    How many records are you extracting?

    What error do you get from the loads monitor?

    I ask this, because i want to know if this problem is in fact a performance problem or could be a connection problem.

    Regards.

    Marín.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      If you are in SCM 5.0, use "Ignore zero entires". For other overs, put a routine which can remove the "zero" records.

      -Shibu

      Thanks for rewarding points if this is helpful

  • avatar image
    Former Member
    Jul 23, 2007 at 06:41 AM

    BI 7.0 gives lots of performance issue, you can check OSS notes on it.

    Please check following OSS Notes : 892482

    0000428102 Performance: Loading planning area version

    0000964858 Incorrect vals w/ STAR_TRANSFORMATION_ENABLED in Oracle 10.2

    Add comment
    10|10000 characters needed characters exceeded