Clear Data from Cubes

New Contributor

I am trying to clear entered data from the particular Cube but unable to do so using "Clear Data" Rule. Can anyone suggest me the process to clear data from any cube without disturbing other cubes' dataset.


Contributor II

Hi Monika,

For non-calculated data, you will need to reset all data cells back to NoData. You do this by creating a data buffer of cells that you want to clear and then loop through each cell and reset its value and status. Since it's a finance rule, you will use a custom calculate DM step to filter which entities, periods, scenario to clear (i.e. the data unit) and call the finance rule to clear data. Here's one finance rule example I use on my end: