Skip to main content
April 2, 2024
Solved

How to remove data from Account to delete it?

  • April 2, 2024
  • 1 reply
  • 0 views

Hi all, 

We created a test account to load some test data into but we now would like to remove the account.

How would I go about clearing the data from the account in order to delete the account?

The data was inputted into the account using an XFSET function.

 

Thanks!

Best answer by RobbSalzmann

use XFSetCell again, set the values to 0 and set StoreZeroAsNoData true.  Then calculate and consolidate the cube to clear the upper levels.  


RobbSalzmann_0-1712089816734.png

 

1 reply

April 2, 2024

use XFSetCell again, set the values to 0 and set StoreZeroAsNoData true.  Then calculate and consolidate the cube to clear the upper levels.  


RobbSalzmann_0-1712089816734.png

 

ejuszczakAuthor
April 2, 2024

Thank you for the response!

I do not know where to find this screen? Where would I find it?

Thanks

April 2, 2024

In Excel, login to OneStream.  Then click the ƒx formula button:


RobbSalzmann_0-1712090499461.png