BPC Report - Member retrieval on the basis of availability of transaction data

[Former Member]

Dear all,

We use BPC 10.1 - Classic version with EPM SP22.

We have a report structure like below,

Considering the volatility of the relationship between the members in the row axis, we are not able to override them on the basis of any property.

As per the requirement they should not be selection as well.

So, we selected "All members" from the EPM Select member dialog box (In Edit report) for the Dimension A-E in row and "Remove Empty" is enabled. To show only combinations with data in the report.

But we get the below errors at times,

A) "System Out of Memory" error.

B)

The errors are not consistent. The report works fine at times, but over a period of time, we again get these errors.

We are not sure, if it is due to the reports design to retrieve members on the basis of data availability. Please help.

Regards

Deepika G S

[former_member186338 · Accepted solution]

Yes, on the server the system has to process huge amount of data. May be you need more memory on the server.

What is your core BPC SP?

Vadim

P.S. Also try to set: Force Symmetric Refresh for Large Asymmetric Axis

[Former Member · Accepted solution]

Hi Vadim,

Its CPMBPC810 SP6  and HANABPC810 SP6.

Regards

Deepika G S

[former_member186338 · Accepted solution]

Looks like you have to talk to basis team...

[Former Member · Accepted solution]

Oh.. Okie.. Thanks Vadim!

Regards

Deepika G S