EPMRetrieveData will not refresh

[former_member285539]

We have an input schedule that uses one EPMRetrieveData formula to retrieve a specific data value.  This formula works correctly in EPM SP20, patch 4.  After upgrading to EPM SP24, the formula will not refresh.  This problem occurs in both our BPC10.0 NW production system and BPC10.1 NW test system.  The formula is fully qualified (all dimensions are defined).  The schedule has worked fine for two years but now with this SP it will not refresh.  Other schedules using EPMRetrieveData are refreshing fine under SP24.

Does anyone have any ideas on why this is occurring and how to get it to refresh?

Thanks,

Barb

[former_member186338]

It's not possible to help without detailed screenshots!

"Other schedules using EPMRetrieveData are refreshing fine under SP24." - try to recreate the input schedule with the issue. Try to narrow down the issue...

Vadim

[former_member285539]

Hi Vadim,

Thanks for your quick response.  Here is a screen shot of the schedule:

The cell containing the formula (L14) is set as a read only range.  I tried removing the read only range but the formula still will not refresh.

The formula is:

I can copy and paste this formula into a blank worksheet and it refreshes correctly.  If I copy it to a different place in the input schedule it still will not refresh.

I appreciate your suggestion to recreate the input schedule, but that's what I am trying to avoid.  Are you aware of any quirks in how EPMRetrieveData works in SP24?

Thanks,

Barb

[former_member186338]

Hi Barb,

You have customized template with VBA code etc... (I see macro buttons). Do you think it's possible to help you without detailed analysis of this template???

The only proposal is to check if Data refresh is disabled in the options... "Freeze Data Refresh"

And in general it's a bad idea to use EPMRetrieveData, why not to use normal EPM report?

Vadim

[former_member285539]

Hi Vadim,

The VBA is not part of the issue - the formula will not refresh using the Refresh button on the EPM pane.  And all the VBA is doing is executing RefreshActiveSheet.

Freeze data refresh is not enabled.

I am using EPMretrieveData to grab one specific datapoint with different dimension members than the EPM report on the sheet; this was the most efficient way to get this data.

Thanks,

Barb

[former_member186338]

"The VBA is not part of the issue - the formula will not refresh using the Refresh button on the EPM pane." - may be you have some code in Workbook_Open(), Worksheet_Activate(), AFTER_WORKBOOK_OPEN, etc...?

Do you have EPM report on this sheet?

What is the sheet type?

...

Screenshots of sheet options...

"I am using EPMretrieveData to grab one specific datapoint with different dimension members than the EPM report on the sheet; this was the most efficient way to get this data." - I see more than a single cell

Vadim

[former_member285539]

Hi Vadim,

There is no Workbook_Open, etc VBA code.  File is set in BPC to refresh data in the whole file upon opening.

This is an EPM report with one cell set as a read-only range:

The sheet is an EPM worksheet, here are the Sheet Options:

Thanks,

Barb

[former_member186338]

Ups, not clear...

You have EPM report and in the data area of this report you have a cell with EPMRetrieveData formula? How do you put this formula - by Formatting sheet content override or...?

Vadim

[former_member186338]

P.S. Also it's better to explicitly specify connection in EPMRetrieveData formula...

P.P.S. And what do you want to input? Warranty Provision and Warranty Payments?

Vadim

[former_member285539]

Hi Vadim,

This schedule originally was set up to have the user manually enter the beginning data.  However, once we had this historical information in the model, we added the EPMRetrieveData formula to retrieve it.  That worked fine for 2 years, but evidently that doesn't work in SP24.

To correct the issue, I deleted the EPMRetrieveData formula from cell L14.  I created the same formula in a separate cell (D2).  I had to re-enter the formula, when copied it still would not work.  Then I put a simple =D2 formula in cell L14 to bring in the value from the EPMRetrieveData formula.  That seems to have resolved the issue.

Thanks for your help on this!

Barb

[former_member186338]

"I had to re-enter the formula, when copied it still would not work." - absolutely strange!

Can you post the working formula in D2 to compare with original in your post?

Vadim