Skip to Content
Former Member
Mar 17, 2014 at 11:21 PM

Refresh Issue - EPM Worksheet with Multiple Reports


Hi All,

I am working on a report in EPM 10. It is a workbook with multiple sheets and each sheet contains 2 EPM reports. I need to use "EPMDimensionOverride" function in all of these reports. Here is the issue I have been facing:

One of the worksheet, it contains two reports, 000 and 001. When I hit refresh button (refresh worksheet), data is refreshed in both EPM reports within it but first report (000) does not recognize "EPMDimensionOverride" function written for this report (000). It just returns some data based on member(s) selected in context. At the same time, second EPM report (001) in this same worksheet works just fine. It recognizes "EPMDimensionOverride" function written for this report (001) and returns data accordingly.

Now if I select any cell in 000 report area, click "Edit Report" button then click Ok from layout tab without changing anything in layout or anywhere else. Report 000 will be refreshed and this time it will recognize "EPMDimensionOverride" function and will return correct data.

I am not able to figure out why first report is not refreshing with "EPMDimensionOverride" function when I do refresh worksheet. Please advise what might be causing this issue and and how to fix it.

My EPM version is - EPM 10 SP13 patch 4