Sunday, March 11, 2012

Apply compression - XMLA

Hi there,

I intend to create a backup job for my cube, however I didn't find anywhere the XMLA configuration command for the "Apply Compression" option in the cube backup properties. Even if I check this box and script the setting it doesn't show up. I haven't find anything even in the XMLA command reference .

<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>test</DatabaseID>
</Object>
<File>test.abf</File>
<AllowOverwrite>true</AllowOverwrite>
</Backup>

Any help would be appreciated!

Thanks,

Greg

There is an ApplyCompression element, which is in the latest BOL. You do not see this element when you turn compression on as the default value is on, you only see it when you turn compression off.

Code Snippet

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

<Object>

<DatabaseID>Adventure Works DW</DatabaseID>

</Object>

<File>Adventure Works DW.abf</File>

<ApplyCompression>false</ApplyCompression>

</Backup>

No comments:

Post a Comment