Home Forums Data Warehousing Strategies and Ideas Configuring SQL Server 2008 R2 Change Data Capture with SSAS RE: Configuring SQL Server 2008 R2 Change Data Capture with SSAS

  • September 21, 2012 at 3:22 am

    #1540541

    Thanks for the info Daniel. I think I'll not reseach SSAS any further.

    I'm going to:

    1. Configure CDC

    2. Use SSIS to import the changes into history tables in the reporting database

    3. Calculate the start and end date for each change

    4. Build reporting tables off this history information

    5. Query the reporting tables in SSRS

    Simples!