Empty cache or old data

[carlo_tom]

Hello, All -

Working on converting our BPC 7.5 templates to version 10 and I'm having a strange issue when trying to send data to the system.

Using the EPMLink formula, I am opening our converted templates in version 10.  When I enter some data and hit Save Data, I get a message box saying 'Empty cache or old data.  Click refresh to retrieve data.'  If I close the template, re-open using EPMLink, run the refresh workbook routine, key in some data and hit save data, I don't get that message.

NOTE: our input templates are still using the EvDRE formula.

Not sure why I have to manually run a refresh when the EPMLink formula is (I'm assuming) already doing that on open.

Some things things that I've tried already to fix this issue:

+ Delete cache sheet and re-expand workbook in EPM

+ Run the EvDRE migration tool

+ We have some custom VBA code running when the template is open and (as a way to rule those out), I commented those macros out and I still get the message.

It was my understanding that the EPMLink formula was the replacement for EvHOT and that it functions the same way.  So, I don't understand why I have to do another refresh. 

If I manually open the template outside of EPMLink, put in the parameters (dimension members), run the Expand workbook, key in some data and then hit save data, the message box appears.  If I perform the same steps but run the Refresh workbook after running the Expand, the data is sent.

So, it appears that I need to run the Refresh routine every time before sending data, which does not make sense.

Has anyone encountered this type of behavior in v10?

Other Information:

+ Office 2010

+ EPM Server version: 10.0 SP16

+ EPM Add-in version: 10.0 SP21 .NET 3.5; Build: 9094

Thanks,

Carlo

[dinesh_veluru]

Hi Carlo,

Please try with the below workaround.

Run the Tcode SE38  and execute the below program to clear the cache

UJXO_CLEAN_CACHE

UJXO_CLEAN_DIM_CACHE

UJXO_CLEAN_TDH_DIM_CACHE

Run the program UJA_REFRESH_DIM_CACHE.  provide the environment and make the selections as per below screenshot.

Restart the excel and launch it again.

Thanks,

Dinesh.V

[carlo_tom]

Hi, Dinesh -

Forgive me but I have never heard of "Tcode SE38" so I don't know how to access it nor do I know how to use it.

Could you please provide some more information for me as to how I can access this?

Please note: I forgot to mention in my original note that we are running BPC on Microsoft...not NetWeaver.  Not sure if that makes a difference.

Please let me know.

Thanks,

Carlo

[dinesh_veluru]

Hi carlo,

Sorry I am not aware of Microsoft version.below is for Netweaver

you have to login through sap logon backend

execute Tcode- SE38 it will open abap edior to run the programs.

Dinesh.V

[carlo_tom]

Hi, Dinesh -

Sorry for the oversight.  We are on the Microsoft platform for BPC and have no access to the NetWeaver version of the program so I cannot access the module that you are referring to above...unless there is a MS equivalent to the steps you provided above.

Please let me know if there is a MS version of the steps mentioned above.

Thanks,

Carlo