Post reply

Problems connecting to SSAS Cube from Excel

  • March 12, 2018 at 6:23 am

    #329549

    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 13, 2018 at 1:30 am

    #1982856

    laura.smith - Monday, March 12, 2018 6:23 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?

    You'll need to unblock the firewall settings in the Server, which prevents the connection to SSAS cubes.

    https://docs.microsoft.com/en-us/sql/analysis-services/instances/configure-the-windows-firewall-to-allow-analysis-services-access

  • March 16, 2018 at 7:31 am

    #1983563

    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