We have an Analysis Services project, on SQL Server 2008 R2, and need to add a number of Partitions to the cubes, to improve the performance.
While it is possible to create the partitions against the cube, in SSMS, using an XMLA command, we can't see a way of easily creating multiple (a couple of dozen or so) partitions on a cube, in BIDS.
The reason for wanting to do it in BIDS is that, when the BIDS project is deployed, we want to maintain the cube partitions, rather than having to recreate them. It also ensures that there is one project, that can then be moved through source control, and deployed throughout the multiple environments (Dev -> Test -> Live).
Cheers
