Carl Campbell · Nov 23, 2019

Clearing my cube of data

Hi I am experienced with Ensemble but working in my first DeepSee project, so forgive me if this seems elementary. 

My question is, how do I clear  the data out? Every time I build I am adding more and more data. But I would like to revert my cube to being 0 so I can reload it and start over? Set my row count back to 0?

I am unable to remove/purge through the management portal

-I've tried to kill my cube Do ##class(%DeepSee.Utils).%KillCube("MyCube.Cube")  and then Rebuild it. 


Thanks In advance

0 164
Discussion (5)1
Log in or sign up to continue

Cube rebuild clears all old data. This is enough:

Do ##class(%DeepSee.Utils).%BuildCube("MyCube.Cube")

The build tells me that I have the same number of rows everytime I compile rebuild , It is never back to 0. SHould I be clearing my persistent object also?

I'm not really sure why do you want to have a cube with 0 facts? Can you elaborate why you need this?

But yes, clearing the datasource and rebuilding would get you cube with 0 rows.

Every time you build cube you get your cube deleted and the data copied from persistent objects to the cube. Do you really want to delete persistent data?

-Thanks, yes my first rounds of persistent data was not what I wanted introduced into my analysis data. I manged to figure it out by making sure to using the DeleteExtent method on my persistent class. Then feeding new data into my class, compiling  the object and then rebuilding the cube. 

-Do ##class(PO.PersistentObject).%DeleteExtent(),!


-set status = ##class(%DeepSee.Utils).%BuildCube("MyCube.Cube")