Do you need to remove data for a certain time frame? Use this guide to clear out published data for a specific month in a budget or forecast scenario.
To get started, navigate to the Data Exporter and export all the data for the period you want to delete. When you have the download, follow the next steps:
- Delete any attribute columns.
- Delete all 0 value lines.
- Remove data from the Value column.
- Replace the Value column header with the Scenario name to create a Cube range column and row format.
- Delete Scenario column (now redundant).
- Remove duplicates (only applicable if there were attribute columns removed in step 1).
- Select the Range and Publish blank values.
When exporting with the Data Exporter, the file will include formula dimensions. Either leave these in the file (Cube will ignore them because formula dimensions can't be published), or remove them to decrease the size of the published range.