Management Using SSIS to Transfer Data from a SSAS Cube
| Using SSIS to Transfer Data from a SSAS Cube |
| Written by Chuck Rivel |
| Friday, 26 September 2008 03:41 |
|
Scenario A process needs to be built that will take the aggregate data from your SSAS cube and transfer that data as a source for a third party application. This process will need to be scheduled and have the capability to execute when requested. Using SSIS to transfer the data is a great tool to meet the requirements above since you can build the process and schedule it as required as well as run the package when requested. Since the tool has been established, the question now becomes how to get SSIS to connect to the cube and then work with the results. The following document lays out a step by step approach to get the initial connection to the SSAS cube, sample MDX to query the cube and the cleanup steps within SSIS to perform against the data to have it usable going forward. Read more...
|
Tags: 2005, article, ssis
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)
