none
Not able to get the tables in excel when u access ssas cube which is located remotely

    Question

  • Not able to access the tables in excel when  u access ssas cube which is located remotely

    My ssas database is located in remote machine. I want to access cube from excel  from my m/c .I am able to connect to the cube but am not able retrive table from the cube Db. Please correct what could be the reason


    Smash126

    Tuesday, November 19, 2013 11:04 AM

Answers

  • this data source contains no visible tables THIS IS THE ERROR MESSAGE I GET WHEN YOU TRY TO ACCESS CUBE IN EXCEL FROM REMOTE MACHINE.


    Smash126

    Hi Smash,

    When you create a data connection to SSAS Server, can you see the cube list? Please see the screenshot below:

    If so, after you create a data connection to SSAS Server in Excel, please create a PivotTable or PivotChart in the Excel worksheet. Please refer to the following steps below:

    1. Click the "Existing Connections" button.
    2. Select the "Connection" you have created, and then click "Open".

    For more information, please see:
    Creating an Excel 2010 PivotTable using cube: http://www.youtube.com/watch?v=tU-l3FSKYo0

    If not, please check if you have sufficient permission to access cube in OLAP Server. For more information, please see:
    Granting Cube Access: http://technet.microsoft.com/en-us/library/ms174799.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    Thursday, November 21, 2013 5:43 AM
    Moderator

All replies


  • Smash126

    Tuesday, November 19, 2013 11:09 AM
  • this data source contains no visible tables THIS IS THE ERROR MESSAGE I GET WHEN YOU TRY TO ACCESS CUBE IN EXCEL FROM REMOTE MACHINE.


    Smash126

    Wednesday, November 20, 2013 7:27 AM
  • this data source contains no visible tables THIS IS THE ERROR MESSAGE I GET WHEN YOU TRY TO ACCESS CUBE IN EXCEL FROM REMOTE MACHINE.


    Smash126

    Hi Smash,

    When you create a data connection to SSAS Server, can you see the cube list? Please see the screenshot below:

    If so, after you create a data connection to SSAS Server in Excel, please create a PivotTable or PivotChart in the Excel worksheet. Please refer to the following steps below:

    1. Click the "Existing Connections" button.
    2. Select the "Connection" you have created, and then click "Open".

    For more information, please see:
    Creating an Excel 2010 PivotTable using cube: http://www.youtube.com/watch?v=tU-l3FSKYo0

    If not, please check if you have sufficient permission to access cube in OLAP Server. For more information, please see:
    Granting Cube Access: http://technet.microsoft.com/en-us/library/ms174799.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    Thursday, November 21, 2013 5:43 AM
    Moderator