SSAS Partition Manager is a SSIS solution to dynamically create several partitions of a measures group per year.
The solution uses AdventureworksDW Database and Cube.
To test the solution, install the AdventureworksDW example
The AdventureWorksDW sample data consists of :
- The AdventureWorksDW database.
- The AdventureWorksDW OLAP cube
To deploy the AdventureWorksDW databse :
- Download
AdventureWorksDW.
- Copy AdventureWorksDW2012_Data.mdf to your default database directory (normally \Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA) or other location as designated by your database administrator.
- Connect to the database engine in SQL Server Management studio.
- Right-click Databases, and then click Attach.
- On the Attach Databases dialog box, click Add.
- Navigate to the location where you copied AdventureWorksDW2012_Data.mdf, select the file, and then click OK.
- Under “AdventureWorksDW2012” database details, select the row where File Type is Log.
- Click Remove.
- Click OK.
To configure the AdventureWorksDW OLAP Cube :
- Download
AdventureWorksDW Multidimensional OLAP Cube.
- Unzip the file to a location on the computer running Analysis Services.
- In the Enterprise folder, double-click AdventureWorksDW2012Multidimensional-EE.sln.
- If the Choose Default Environment Settings dialog box appears, choose the Business Intelligence Settings option, and then click Start Visual Studio.
- In Visual Studio, at the top of the Solution Explorer window, right click AdventureWorksDW2012Multidimensional-EE and click Deploy.
More information in this article :
https://social.technet.microsoft.com/wiki/contents/articles/50781.dynamic-management-of-ssas-partitions-with-ssis.aspx