Friday, September 4, 2015

SSAS : Transaction deployment

There are different options available to deploy and process the cube. Based on project requirement we can carefully select the appropriate deployment options. Here I would like to explain the use of transaction deployment property of cube deployment attribute. Normally while processing the cube user will not be able to access the cube but if you enable this property cube user can access the data from the cube while processing. Changes will be committed only if the deployment succeeds.