delete the data from cube SSAS 2008

2
votes

I have developed a cube SSAS 2008, in the process of testing we are loading data from datamart to cube using SSIS analysis services processing task.

Problem:

In order to do various tests, we need to clear data in cube for each test. How to delete data from the cube, so that cube comes to the origianl schema state.

thanks

prav

1
tsqlsql-server-2008ssisssas
Hey, I have solved the delete the data in cube, as the processStructure uisng the XMLA script generated from the CUBE process task. – prav
You can also connect to the cube and select "Unprocess" in processing options, if you're not looking for a script/ssis way of doing it. – cairnz
Hey prav can you post your own answer and mark it correct? – Kyle Hale

1 Answers

1
votes

You can do so using SSIS Analysis services processing task. This will Process dimensions and cube, which will refresh data in cube. You can find a step by step discussion on Benny Austin' Blog here. Alternatively you can find out an answer here for Sql Server 2012.