Load Data Into SysCube Table - Help Needed

Kinetic ERP
1

Recently, we had an executive query go belly up on the scheduler. It’s been a while since I’ve messed with one of these. So when I put it back on schedule, I set it to delete everything instead of deleting nothing, as I thought I remembered having to do this in the past. Woke up this morning to years worth of cube data gone…

Good news is I have a 3rd and Pilot environment that are up to date. I was able to pull all the syscube data I lost from there and now have it securly backed up.

The question I have now is, how do I get it back into the system?

I looked at DMT and didn’t see anything listed there to allow me to load it that way.

I also peeked into doing a ubaq, but there are no services listed to allow me to do so.

Does anyone have a workaround or have had a similar issue in the past? XD

3 Likes
2

You can probably write a function to insert the records in the table directly. I havent tried on the syscube table specifically but it works on other tables. Get your old data into a csv file. Create a dashboard with a file picker widget on it to select and upload the file and call the function. The function can consume the file from the server using the sandbox method and insert a record in syscube for each row.

2 Likes