March 12, 2018 at 6:09 am
We're trying connect to a SSAS 2017 cube from Excel 2016 but are getting the error shown in the image
All Anti Virus and Firewall is switched off.
Permissions are set to admin permissions in both SSAS and in Active Directory
Any ideas as to what the problem might be?
March 12, 2018 at 9:16 am
Are you able to connect to the cube with SSMS, and are you using the same server/port combination when attempting with Excel? I haven't seen this error before, but would suggest you install the latest client libraries if you are able to connect with SSMS and using the same server/port combination in Excel: https://docs.microsoft.com/en-us/sql/analysis-services/instances/data-providers-used-for-analysis-services-connections
March 16, 2018 at 7:32 am
It turned out that a part of the MDX code inside the cube was causing an error CREATE DYNAMIC SET CURRENTCUBE.[GNR and PI]
AS {[Lines].[Class POS].&[GNR],[Lines].[Class POS].&[PI],[Lines].[Class POS].&[GEN],
[Lines].[Class POS].[All].[Class POS Total]}, DISPLAY_FOLDER = 'POS Class Sets';
and Excel won't return any of the data if there's an error anywhere.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply