A plea for help
As some of you know, Tim German and I are writing a chapter in the OMG-I-must-be-nuts-to-do-this-again Special Project. Given the agony I and the gaggle of august geeks I have roped into this project (one would think they would know better, but they didn’t) are going through getting this all done on time for publication, I’d have to say they are in that cloud cuckooland category as well. But it’s all fun, sort of. We think. On to the subject of this post know that I’ve (not Tim, he is made of sterner stuff) had my chance to whine.
You may ask (maybe you don’t, pity that as it’s the whole point of this post), Cameron and Tim, just exactly what chapter are you writing? And why is this a plea for help? We’re ever so glad you asked that question, as this post’s raison d'être is to tell you why and what and then to ask for your help. In short, we’re writing a chapter on Hybrid Essbase and we need your help figuring out the likely future direction of Essbase. Momentous enough for you?
Just in case you don’t know
Hybrid Essbase is the future of Essbase. Yes, really. It isn’t BSO and it isn’t ASO – it’s both all in one delicious package. Oracle have stated as much in public settings – we’re not breaking any NDAs or confidences.. We are beyond happy to hear this because it means that Essbase has a future, Essbase development is ongoing, and thus we can continue our Essbase blogs and incidentally continue our so-called careers. What’s not to like?
Here’s the deal – We know what’s in Hybrid today. We don’t know what will be in Hybrid tomorrow. But we can guess at what is needed, we think. What do you think Hybrid must have to become the de facto replacement for BSO and ASO? Here’s our list – what’s on yours?
- Time Balance
- Cross dimensional operators
- Data load to upper and lower intersections
- Theoretical database size limit = ASO
- Hybrid calc scripts
- All BSO calc script functions
- BSO functions that mimic MDX, e.g., ???
- Attributes in Hybrid
- DATAEXPORT and Essbase report scripts in Hybrid
- TOPDOWN member formulas
- Partitions to BSO
- Compression dimension
- Solve order
- Optional MDX grammar
- Paged outline file (IIF there are larger databases)
- Materialized aggregations
- Query hints
- Persistent tablespaces
- Database statistics that report both BSO and ASO statistics
- Documentation that explains:
- Internals of the database
- Have you ever heard Tom Kyte talk about the Oracle db? I’ve been to one or two of his presentations (NZOUG and GLOC) and I think I understood the first 60 seconds of his speech (mostly the bit where he said, “Hello, my name is Tom Kyte”) but I was able to suss out that he talked about the internals of the database and how to best tune for performance. The Oracle db is the heart of Oracle – if there ever was a competitive advantage re internals confidentiality, this product would be the one to exercise that. But Oracle don’t do that.
- So why can’t Essbase geeks have that same transparency? We do have it for BSO, mostly, but ASO’s internals are barely discussed in the DBAG and the best explanation extant is Dan Pressman’s chapter in Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals. Why can’t Oracle provide this for Hybrid? Please. Rant over.
- How to tune Hybrid databases for best performance
- Database statistics that merge ASO and BSO statistics
- Death to load rules. Please? Pretty please? Pretty please with sugar on top? Pretty please with sugar on top and whipped cream? Pretty please with sugar on top, whipped cream, and chocolate sauce? Pretty please with sugar on top, whipped cream, chocolate sauce, and a cherry on top? Please?
Again, the plea for help
Send your comments care of this blog’s comment section below, or to my email (if you have it), or to this Twitter thread. We’ll thank the Best and Brightest for their help in the Acknowledgements section if we use your suggestions. Think of it – immortality in print and all the more reason to buy copies of the book (hopefully in the hundreds if not thousands) so I can continue my royalty income of 32¢ per copy (yes, really,that’s my share).
Thanks and be seeing you.