Is there a way Smartview 11.1.2.5.410 works with Essbase and Provider Services 9.3.1.4 for Multiple
We have just recently installed Smartview 11.1.2.5.410 and are getting away from the old Excel Addins since they will not work with Office 2013.
Essbase and Provider Services (APS) are version 9.3.1.4. (We are working on a project to upgrade these, but that is going to take time.)
When our users have a single range of fields to query, the Refresh works fine (with Smartview 11.1.2.5.410, Essbase & APS version 9.3.1.4 ) and retrieves the Essbase data.
When our users have multiple ranges in an Excel worksheet, the Smartview Refresh option returns with "Invalid free form; data region contains member at row 8 and column 2".
Smartview is not recognizing selecting one range and trying to retrieve only data for a selected range or handling multiple ranges.