none
SSAS Master Cube and Slave Cube are having the data differences..

    Question

  • Hi All,

    Greetings ..!!

    At our PROD Environment , we have Master server and Slave Server ..
    Which is having the Same ROLAP Cube ..

    When we queried on master and slave .... We got the data difference .. which should not ..

    Please help on this..

    Thanks..!!


    Mahesh Alam


    • Edited by Mahesh Alam Thursday, June 26, 2014 10:19 AM small correctionn
    Thursday, June 26, 2014 10:19 AM

All replies

  • Hi Mehesh,

    According to your description, in your product environment there are two servers which have the same SQL Server Analysis Services cube, the problem is that uses get different data when query data from the two servers, right?

    The issue can be caused by that the process time on the two server are different. You can do a process full on both of the server and check the issue is persist or not. If the issue persist, you can configure synchronize two SSAS Servers. In SSAS, we can synchronize two SSAS servers in order to have a failover server in case something goes wrong with one of the servers. Please refer to the link below to see the details.
    http://www.mssqltips.com/sqlservertip/2938/how-to-synchronize-two-ssas-servers/

    Hope this helps.

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, June 27, 2014 2:57 AM
  • Hi Charlie,

    Thanks for your reply.

    Sorry for the miss , we are syncing the master with slave on daily basis..
    We are not processing ..

    Thanks,
    Mahesh


    Mahesh Alam

    Friday, June 27, 2014 6:05 AM