We recently had a Windows Server 2008 R2 ReportPortal server crash on us and are in the process of rebuilding it with Windows Server 2016. the Database and Analysis services are on separate servers so those are all intact. I was hoping to just restore a backup of the previous server and pull the ReportPortal and XMLA app folders and use them directly. Everything seemed to work ok, had to follow the instructions for XMLA from https://docs.microsoft.com/en-us/sql/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0. If I go to Admin > Connections and test the connection to the AS Server it works. However if I go to Design > OLAP Report > Connect to Cube I get a red box that shows all the measure groups in the cube. I am unable to select the XML for AS connection which works on the ADMIN > Connections page. Additionally if I click on Home and any of the reports listed I get a small red box with a shielded exclamation point on it. Any help is greatly appreciated.
Report Portal
Cannot build OLAP report
Posted - 02/15/2018 : 15:02:59
