Clearing data

You can clear data from the cells in an exploration, cell-based report, or in a Quick Report.

What does clearing data do?

When you clear data, the cleared cells remain as blank cells on the worksheet.

Formats, such as number formats, conditional formats, and borders are retained. Clearing the content does not break the link to the datasource.

Why would I want to clear data?

You might want to clear the data before you share a report so that

  • Report consumers are required to refresh data to obtain recent changes from the data source.
  • Report consumers are authenticated before they are able to view report content.

Can I automate the clearing of data?

You can also automate this task by using the ClearAllData method. For more information, see https://ibm.github.io/paxapi/#clearalldata .

Can I restore the data that I have cleared?

To restore the data that you have cleared, you need to refresh the data. For more information, see Refresh data.

Note: Some values may be visible in a published workbook, even if the values were cleared. This may occur if the values were cleared and published from an older version of Microsoft Excel, and opened in a newer version of Microsoft Excel. Cleared data is visible in this scenario because opening a workbook in a newer version of Microsoft Excel triggers a recalculation, which includes a refresh of the IBM® TM1 data. The data is authenticated with the credentials of the user that opens the workbook.