Skip to main content
Newcomer
Apr 2, 2024 7:39 PM UTC
Solved

How to remove data from Account to delete it?

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
Employee - Advisor
Apr 2, 2024 8:30 PM UTC

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

 

4 replies

RobbSalzmann
Employee - Advisor
Employee - Advisor
Apr 2, 2024 8:30 PM UTC

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
Newcomer
Apr 2, 2024 8:36 PM UTC

Thank you for the response!

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

Thanks

RobbSalzmann
Employee - Advisor
Employee - Advisor
Apr 2, 2024 8:41 PM UTC

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

RobbSalzmann_0-1712090499461.png