Have to refresh the report twice to get the data in the report

[Former Member]

Hi , We have to click on the refresh button twice to see the data in the report.

       first time when we refresh report it is showing only the first column in the report and remaining all columns are blank

       after we click refresh button second time it is showing the entire data in the report.

       In the report layout , when we open the dimension it is showing only 1 member , after  the second refresh it is showing all data.

First refresh

Second refresh

     Please suggest here.

[former_member182709]

And this note as well.

1991976 - Refresh report in EPM Add-in fails or results in wrong transaction data

[former_member182709]

Also check out KBA 2118006 - Refreshing report twice generates the different result - BPC NW

The solution in this KBA is to apply note 2022276.

Charlie

[former_member182709]

Try the latest EPM Add-in, SP22 Patch1.

Charlie

[Former Member]

Hi Venkata,

Which EPM front end version do you have installed?

Always try the latest EPM add in.

Andy

[Ankur_Jain]

Hi Venkata,

Please share the report structure. Insufficient information to suggest anything.

Regards,

Ankur Jain

[manohar_pappireddy]

Hi,

Do you have multiple reports in the same sheet?

Refreshing with the "Refresh work sheet" option?

Thanks,

Manohar