We are currently in the process of upgrading our EPM environment from 188.8.131.52 to 184.108.40.206. We are staggering our application go-live dates so HFM goes first late Summer and then Essbase 3 months later.
We are having issues with Smartview compatability balancing our applications between 220.127.116.11 and 18.104.22.168.
Option 1 - Upgrade to Smartview 22.214.171.124.210:
We are able to connect to both old and new HFM but our 126.96.36.199 Essbase connections start acting strange and we can only see aliases rather than member names or aliases. The change alias table is essentially greyed out and locked down. This basically makes our Essbase ad-hoc analysis useless. Oracle told us that 188.8.131.52 Smartview could support both 184.108.40.206 and 220.127.116.11 but when we told them about this issue, they then said we would have to upgrade our 18.104.22.168 to 22.214.171.124.500....something we won't be doing as we are abandoning it over the next few months.
Further, the default install location for the new Smartview is C:\Oracle\Smartview whereas the 126.96.36.199 version was located in C:\Hyperion\Smartview. As you can imagine, we receive that famous error of C:\Hyperion\Smartview\Bin\Hstbar.xla! in all of our formulas when opening files created with formulas in 188.8.131.52. My assumption is the new Smartview can't find the path that the old formulas are tagged with.
Yes, I can do a search and replace in Excel for C:\Hyperion\Smartview but I don't want to tell hundreds of users around the world to do this. It appears (I have done a few tests), that this formula issue won't occur if I install 184.108.40.206.210 into C:\Hyperion\Smartview and override the default install location. My issue with this is I don't know if there is any downside to overriding the default location of Smartview. ie. will issues arise in the future as it was intended to go to the Oracle folder? Further, my end-users may try to rush through the installation instructions and I suspect many people will carelessly install it to the default location. I just want to make the install as user-friendly as possible for all of our users who are not Smartview experts.
Option 2 - Stay on Smartview 220.127.116.11 until Essbase goes live:
If we try to stay on the current Smartview 18.104.22.168, everything seems okay but now I have discovered that the member selection function does not work with HFM 22.214.171.124 and gives an error saying 'Function Parameter Missing or Mis-Spelled'. Not having this function will be an issue for us. I haven't done much testing with this option but the first issue is a bit of a deal breaker.
Any advice? Has anyone been through this? Does anyone have a simple way to fix the Essbase alias issue or the C:\Hyperion\Smartview formula issue.