How to remove data from Account to delete it?

[ejuszczak]

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!

[RobbSalzmann · Accepted solution]

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

[RobbSalzmann · Accepted solution]

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

[ejuszczak]

Thank you for the response!

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

Thanks

[RobbSalzmann · Accepted solution]

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

[ejuszczak]

Thank you! I was able to delete it!