I have a SSAS Multidimensional Cube. There is a measure group with multiple partitions (based on year). I need to move old partitions to a different physical (slower) disk. When I create the partition I'm able to choose the physical location of it. But when partition has already been created I cannot find the place where I can change the path to physical disk. Do you know is it possible to change this ?
Sql-server – How to change the SSAS Multidimensional Cube partition location on disk
partitioningsql server 2014ssas
Related Question
- SQL Server 2012 – SSAS DB Consuming Disk Space and High Memory Usage After Processing
- Sql-server – Error when only deploying a dimension on SSDT
- Sql-server – How to implement composite partition (Range list / Hash range) partition in SQL server
- SQL Server 2008 Partitioning – How to Reduce Table Partition Timing
- Can anyone please tell me if these are correct statements about measure group partitioning in ssas
Best Answer
I've found the solution. To change the location of the particular partition in SSAS Multidimensional Cube (MeasureGroup) you have to Open SSDT->Open the Cube->Go to Partitions tab->Click on particular partition of the Measure Group->in the Properties window scroll down to the Configurable\StorageLocation-> click "..." button->in the Partition Type Selection window select "Specified folder"->click "..." and choose the new path. After this action partition needs to be reprocessed.