XMLA gurus... We've got a partitioning scheme such that partitions from more
than 13 months ago need to be moved onto an archive disk. I'm running an
Alter XMLA command and specifying a new StorageLocation. It appears that when
you change the StorageLocation, it unprocesses the partition. Any way around
that? I'd prefer to avoid having to hit the fact table again.

Here's the command I'm running:

<Alter xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>MyDB</DatabaseID>
<CubeID>MyCube</CubeID>
<MeasureGroupID>MyMeasureGroup</MeasureGroupID>
<PartitionID>MyMeasureGroup_2000_01</PartitionID>
</Object>
<ObjectDefinition>
<Partition xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ID>MyMeasureGroup_2000_01</ID>
<Name>MyMeasureGroup_2000_01</Name>
<Source xsi:type="QueryBinding">
<DataSourceID>MyDataSource</DataSourceID>
<QueryDefinition>select * from MyTable where DateKey between
20000101 and 20000131</QueryDefinition>
</Source>
</Partition>
</ObjectDefinition>
</Alter>

That is indeed correct, changing Storage Location for partition is treated
as structural change. You will have to re-process the partition after
specifying new Storage Location.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.



"FurmanGG" <FurmanGG (AT) discussions (DOT) microsoft.com> wrote

Thanks Edward. I appreciate the help. (I was hoping I wasn't being dumb and
overlooking something)

That might be a nice enhancement for a future version... maybe a Move
command or some switch such that changing the StorageLocation doesn't
necessarily unprocess it. Not the end of the world, but certainly a
nice-to-have. (BTW, I would look into something like a partition Merge except
that I need to leave it partitioned monthly but just move the old partition
onto an archive disk.)

Thanks again!

"Edward Melomed [MSFT]" wrote: