Skip to main content
Newcomer
Sep 7, 2022 12:04 PM UTC
Solved

Clear Data from Cubes

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.

CosimoAnswer
Contributor
Sep 7, 2022 12:13 PM UTC

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:

Cosimo_0-1662552785377.png

 

1 reply

CosimoAnswer
Contributor
Sep 7, 2022 12:13 PM UTC

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:

Cosimo_0-1662552785377.png