04-02-2024 03:39 PM
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!
Solved! Go to Solution.
04-02-2024 04:30 PM - edited 04-02-2024 04:30 PM
use XFSetCell again, set the values to 0 and set StoreZeroAsNoData true. Then calculate and consolidate the cube to clear the upper levels.
04-02-2024 04:41 PM
04-02-2024 04:30 PM - edited 04-02-2024 04:30 PM
use XFSetCell again, set the values to 0 and set StoreZeroAsNoData true. Then calculate and consolidate the cube to clear the upper levels.
04-02-2024 04:36 PM
Thank you for the response!
I do not know where to find this screen? Where would I find it?
Thanks
04-02-2024 04:41 PM
In Excel, login to OneStream. Then click the ƒx formula button:
04-03-2024 09:26 AM
Thank you! I was able to delete it!