BPC 10.1 Report Not Refreshing Properly

[Former Member]

Hi Experts,

We are using SAP BPC 10.1 classic. Using SAP BW SP Level 0006 NW 7.5.

When I am saving any value using input form it is saving correctly as it is. But in a report same value is showing as negative. Both the report and input form built in same worksheet.

When I refresh that specific cell using - right click -> EPM -> Refresh Selected Data then that particular cell showing correct positive value.

Example :If I save value $8000 then it is saving same value at backend. But report is displaying $-8000. But when refresh that particular report cell then it is showing correct positive value.

I think my report is not refreshing correctly hence showing negative value. At the same time input form is showing correct value. To refresh report I am using below VBA code.

Sub Refresh()

Application.Run "EPMExecuteAPI", "RefreshActiveSheet"

End Sub

I checked all other options too i.e. Refresh Selected Report or Refresh selected Data under Refresh button. But it didn't work as well.

Is there any way out where system will refresh each cell properly.

Parag

[former_member186338]

It's not possible to help you without full details about your report!

Try to create very simple report and to reproduce the issue.

[Former Member]

Hi Vadim,

Actually I have created sample report and executed. But this report was showing correct values. And if I compare all the row and column axis members then it is as similar as my original report. But seems my original report is having total 6 reports included hence its not getting refresh properly.

[former_member186338]

Do you understand, that it's not possible to help you without understanding of your report design?

Spend some time and narrow down the issue!