Do not see SSAS cube on Secondary Replica RRS feed

  • Question

  • Hello

    I have set up Always on availability functionality in SQL 2012. It is working as expected for Database engine.

    But recently, I created SSAS cube and deployed on SQL server. In SSAS cube, Datasource connection was for Listener.

    I can view SSAS cube on SQL1(Primary replica) and Listener, but when I login to SQL2(Secondary Replica) , I don't see SSAS cube in management studio.

    Do I need to do anything additional to view SSAS cube on SQL2(Secondary replica)?


    Monday, May 18, 2015 5:57 PM


  • Hi Swetha,

    We cannot use
    AlwaysOn Availability Groups to make SSAS cubes highly available.

    However, when you are using availability groups as your high availability solution, you can use a database in that group as a data source in an Analysis Services tabular or multidimensional solution.

    All of the following Analysis Services operations work as expected when using an availability database: processing or importing data, querying relational data directly (using ROLAP storage or DirectQuery mode), and writeback. For more details, please review the following article.

    Analysis Services with AlwaysOn Availability Groups:

    Lydia Zhang

    Lydia Zhang
    TechNet Community Support

    Tuesday, May 19, 2015 6:06 AM