Management Generating large numbers of partitions using Excel
| Generating large numbers of partitions using Excel |
| Written by Chris Webb |
| Thursday, 28 August 2008 00:00 |
|
Quite often when I'm doing proof-of-concept type work I find myself in the situation where I need to build a cube with near-production data volumes, and in order to make sure that performance is good I have to partition that cube. However setting up tens or even possibly hundreds of partitions in BIDS manually is no-one's idea of fun, so how can you automate this process easily? If you're using a SQL Server datasource then you should try using the functionality built into the Analysis Services Stored Procedure Project: But what if you're using an Oracle datasource or hit a bug with the ASSP code? Most consultants have a preferred method (such as their own custom code, or SSIS packages) but I thought I'd blog about the most commonly used approach which is to use Excel. Here are the steps: Read more...
|
Tags: 2005, article, excel, partition
Latest Author Articles
- What hierarchies are actually being used in my cube?
- NonEmpty() and that all-important second parameter
- Reporting Services-generate MDX, Subselects and Formula Caching
- Calculated members are better than assignments to real members (at least sometimes)
- Using AS Data Mining to Add Forecast Values to a 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)
