We are upgrading our Essbase and Smart View set up to the latest versions (184.108.40.206 and 220.127.116.11 respectively). Currently our reports use the old grid format, so I am converting them to the new format, including having the POV on the sheet itself.
One of the dimensions on the POV row is set by referring to a cell on the front page of the report, so that all of the sheets can have their POV changed from one place - i.e. =Cover!$A$1. This works on many of the sheets, but on some when the sheet is refreshed the formula is replaced by the current value of Cover!$A$1, so the dynamic link is lost.
I can't see any difference between the sheets where this is and isn't a problem, the options look the same - Preserve Formulas and Comments in ad hoc operations is selected, Preserve formula on POV change is disabled and greyed out but that doesn't seem to matter on the sheets where it's working fine.
What is the Smart View version?
I had the same issue, however we are using macros for retrieval, so I've the luxury to update the POV when I run it.
I don't see that in 18.104.22.168 Smart View release
Thanks for replying.
It's version 22.214.171.124.000 (build 111). We were previously using 126.96.36.199, and didn't see the problem there either.
We have simultaneously updated to Essbase Studio 188.8.131.52 from Essbase 184.108.40.206 - but I'm assuming it's Smart View that is responsible for the change in behaviour.
I had to uninstall 220.127.116.11 because of some issues with Outlook forms (not sure though). I did see that in 18.104.22.168
You can try raising an SR with Oracle and if it is a bug they can easily reproduce it.
What I'm doing in my macro is range("H4:N4").Value = Sheets("Cover Page").range("H6").Value