| Renaming an Analysis Services 2005 cube |
| Written by Denny Lee |
| Friday, 20 July 2007 18:09 |
|
There is a question on how to rename an Analysis Services 2005 cube since you cannot do that within SSMS (you can rename a database but you cannot a cube). If you want to rename a cube prior to its deployment, you can alter it through XMLA. To do this:
As you can see from above, the <Name> node can be changed so that while the ID for this cube is still "blah", now your name can be "Foo". But if you want to change the name of your cube after its already been deployed, there are an additional number of steps that will need to be performed. |
Latest Author Articles
- Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services
- Analysis Services Distinct Count Optimization
- Analysis Services: Should you use many-to-many dimensions?
- Using ByAttribute or ByTable Processing Group Property with Analysis Services 2005
- Renaming an Analysis Services 2005 cube
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)




