"Enable Visual Totals" in SSAS Security role

If you are filtering specific attribute members in SSAS and want the user to see the total of just the attribute members selected rather than all (even though they can only see the attributes you have allowed) then you must select "Enable Visual Totals".


If, at the all level, the user should see all total (including ones they can't see) then do not select the Enable Visual Totals.


If, at the all level, the user should only see the total for the members selected then select Enable Visual Totals.


E.g. Attribute A with 3 members with Measure X.


Attribute  | X Value
All           | 6     
M1           | 1     
M2           | 2      
M3           | 3        




If you grant the role access to M2 (2) and you do not have Enable Visual Totals select:


Attribute  | X Value
All            | 6          
M2           | 2           




If you grant the role access to M2 (2) and you have Enable Visual Totals select:


Attribute  | X Value
All           | 2         
M2           | 2      
          

Backing up Analysis Services

There's a very straight forward way to backup a cube onto a shared location.


First create the folder within the shared path e.g. \\SHAREDPATH\CUBEFOLDER


Open new XMLA window and  run XMLA code below on server with the cube



<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>CUBENAME<DatabaseID>

</Object>

<File>\\SHAREDPATH\CUBEFOLDER\CUBENAME.abf</File>

<AllowOverwrite>true</AllowOverwrite>

</Backup>