locked
Do not see SSAS cube on Secondary Replica RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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)?

    Thanks

    Monday, May 18, 2015 5:57 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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:     https://msdn.microsoft.com/en-us/library/hh967523.aspx


    Thanks,
    Lydia Zhang

    Lydia Zhang
    TechNet Community Support



    Tuesday, May 19, 2015 6:06 AM