Forum Discussion

ejuszczak's avatar
ejuszczak
New Contributor II
10 months ago

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!

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

     

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

     

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II

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

     

    • ejuszczak's avatar
      ejuszczak
      New Contributor II

      Thank you for the response!

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

      Thanks

      • RobbSalzmann's avatar
        RobbSalzmann
        Valued Contributor II

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