Re: Export-Delete-Load-Calculate
I did the exact same once or twice myself, fortunately was able to recover also. Also exported a blank cube over a good backup once or twice too. Usually came about when hacking build scripts for other purposes.
Essbase how I loved and hated you.
Although it was far better that the first consolidated version of OBIEE that included it. That had so many poorly documented interdependencies between components that the UAT system accidentally got connected to Prod and wiped during one memorable tenure at a major bank. That was a 4 day outage in financial reporting. My team weren't responsible but as the Ops team we had to fix it. I had to write up the RCA. TL:DR only full network segregation between UAT and Prod would have stopped it, and since it took 6 months to get approved ports open between UAT and Prod networks we never went down that route. The concept that there may have been good reasons (DR and Prod Copies) to pass data and config between networks never seemed to occur to our Info Sec team.
Still I had the pleasure of my resident tech genius giving Oracle product development (we actually got to the product developers!) a good shoeing on the technical ins and outs of their own product.