Report Refresh Issue

[former_member394086]

Hi Experts,

I have one of the SAP BPC report where I am using months and quarters for year 2017 and 2018. 2017 will be previous year and 2018 will be Plan year. Now issue is when I refresh report all the report columns getting refresh perfectly except 2018.03 i.e. March. When I select any cell from March and refresh that particular cell then value appears. So somehow this month's column is not getting refresh and all the cells from this months column is showing blank. I did check formatting sheet as well but nothing specific to this month into that. Can someone please help me to understand what probably impacting?

For Report Refresh I am using below macro code.

Sub Refresh()

Set client = CreateObject("FPMXLClient.EPMAddInAutomation")
client.RefreshActiveSheet

Application.EnableEvents = True

End Sub

Parag

[former_member186338]

Full details required:

BPC and BW version and SP

EPM or AO version and SP

What happens if you press standard refresh button?

Have you tested new simple report?

etc...

[former_member186338]

The issue is here:SAP BW SP Level 0006 NW 7.5

Very old and buggy SP

Upgrade to at least SP12

[former_member394086]

Hi Vadim,

We are using SAP BPC 10.1 classic. Using SAP BW SP Level 0006 NW 7.5. Using EPM Add in 10.0 , SP 32 .Net 4.5 x64 , Build 10088.

I did try using standard refresh button as well but still it is not reflecting values. In simple report values are showing correctly.

Parag

[former_member186338]

P.S. Show screenshot of simple report with correct data!

Add parent of time member (YYYY.TOTAL) to the report

Show results