How to copy one cube partition data in ms-olap to empty partition on another server?

1
votes

I have two SSAS servers with same cube (same in structure not data)

One of them (Server B) has limited resources and I can only process dimensions and a few partitions on it.
The other one (Server A) is the main server that has all the processed data and uses for querying.

The problem is, during processing dimensios and partitions,the server is not avalable for querying(for 3 hours for example), is it possible to process dimensions and new partitions daily on 'Server B' and copy them to 'Server A'?

If I should use 'Synchronization', I don't want to sync deleted partitions from 'Server B' to 'Server A' , is it possible ?

Thank you all.

2
ssmsssasolap

2 Answers

1
votes

If you have setup your Cube to "Process Full" at the Cube level, it would allow you to query the Cube when the process is running using the default Batch mode.

enter image description here

Also, you can Script out it as XMLA file and use it from your script (PowerShell script or SQL Agent job) to process the Cube.

enter image description here

We have seen this work consistently and the users are able to continue to query the Cube when the processing is in progress.

More details about this on the following links:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/40454eac-746f-4807-be1e-d68845371cf8/will-processing-the-ssas-database-does-process-update-on-dimension?forum=sqlanalysisservices

If you do a processFull on the database it will do a processFull on all the dimensions and processFull on all the cubes, but it will inherently do this all in the one trasnaction so you should not see any cube "down time" (which I presume is why you are asking this question).

https://www.jamesserra.com/archive/2011/06/can-you-query-a-ssas-cube-while-it-is-processing/

You can query a cube while it is processing. The worst that could happen is near the end of processing there is a brief period of time where your query could be killed or it might be queued, and it would be queued only for a short time, even if the cube processing takes hours

BUT, if you process your dimension first separately, then the Cube will become un-processed and hence would not be queryable.

0
votes

Instead of worrying about synchronization, use remote partitions so that partitions processed in server B will be querable from server A without having to synchronize them.

Visit : https://intelligentsql.wordpress.com/2014/01/28/ssas-remote-partitions/