Home Forums Data Warehousing Analysis Services Dimension Table used in Multiple Cubes, Msut I change all related SSIS Pkgs and Cubes? RE: Dimension Table used in Multiple Cubes, Msut I change all related SSIS Pkgs and Cubes?

  • November 10, 2016 at 2:48 pm

    #1911791

    quinn.jay (11/10/2016)

    Can I undo an old version, when I don't have version control software? Is there a way to 'reset', or 'clear' a cube of it's partition memory if it were?

    I'm finding that the partition tables and sprocs used to create, process and delete partitions, and what previous months they have processes, is remembered in the cube.

    It is that memory of partitions processed I'd like to clear from the cube in production, I'd like to keep everything else, and then run it, and it would process in Jan16 - Nov16 data from the source.

    If I can't, then does this mean that I have to reconstruct (copy/import) a whole new cube identical to what I have (and the SSIS packages related too), but different name, insert the necessary values into the partition tables, and then run it run like as a brand new cube?

    Answer, go to the SSAS, find the cube, go to partitions, and go to the table that has the partitions created, and delete all or the ones in question. Then delete some or all the records related to the cube in question from ssaspartition, ssaspartitionmanager. Now run the package again, and it should create fresh all the partitions.