cancel
Showing results for 
Search instead for 
Did you mean: 

Performance issue extraction of data from the planning area outbound cube

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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