Post reply

Locking partition data in analysis services

  • October 21, 2005 at 10:17 am

    #166009

    Is there any possibility to avoid updating the data for certain partitions and lock the data in partitions in Analysis Service?

  • October 22, 2005 at 3:40 am

    #599347

    Table A in SQL Server 2005 is split in partitions where the oldest partition will be deleted when the new partition fills up. Data aggregation using Analysis Service is powerful, but when syncronizing against the database, source data from the deleted SQL Server partition/file group is removed and aggregations in Analysis Service will be updated.

    Is there any possibility to avoid updating the data for certain partitions and lock the data in partitions in Analysis Service?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply