Want to know The Truth About CPM?

14 December 2014

A plea for Hybrid Essbase help

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?

What’s the frequency, Kenneth?

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?

BSO

  • DTS
  • 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
  • TWOPASS
  • DATAEXPORT and Essbase report scripts in Hybrid
  • TOPDOWN member formulas
  • Partitions to BSO

ASO

  • Compression dimension
  • Solve order
  • Optional MDX grammar
  • Paged outline file (IIF there are larger databases)
  • Materialized aggregations
    • Query hints
    • Persistent tablespaces

Futures

  • 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.

7 comments:

er77 said...

First od all - I think Hybrid does not to be as ALL ASO and BSO features.

Better in this moment use similar feature, example

we can replace DATAEXPORT and Essbase report scripts with using MDX report
also
Data load to upper and lower intersections must be replaced with using technical level 0 under the same parent members

for your's wish list I will be add

BSO

NONEEMPTYBLOCK in the MDX Clause




er77 said...

MDX getting data reengineering request.

I founded that Classic Essbase application and Hybrid work similar in the retrieving MDX data set
1) Getting all needed set to the memory
2) Retrieving data from memory to the client site/

Better use approach from the classic web developing - getting part of data set - putting it out. It's can resolve many issues for MDX memory leaks

er77 said...

MDX getting data reengineering request.

I founded that Classic Essbase application and Hybrid work similar in the retrieving MDX data set
1) Getting all needed set to the memory
2) Retrieving data from memory to the client site/

Better use approach from the classic web developing - getting part of data set - putting it out. It's can resolve many issues for MDX memory leaks

Anonymous said...

It doesn't make sense to introduce a replacement for a proved product just to make things different but not better.
However, if someone does exact this, it could be suggest a guess that the product is supposed to "improved / develop" it to death.
THAT is the danger! Missing transparency regarding Essbase (internals) is an issue from the beginning since it has taken over by oracle.

Anonymous said...

1. MDX is great but why on earth can't we format the output when spooling to a text file. Having to use PERL to unscramble the output is a real pain.
2. Agree that Load/Build rules are an anachronsim.
3. Typed measures could be really useful if we could update the text values from a load file or SQL source. They are really only useful for low-volume and static values.

Anonymous said...

Well rules files are ugly.
And I have seen people doing terrible (from my POV stupid) things with rules files, what in turn kaded them even uglier.
However, as far as I know old techs are outdated and ODI 12 not even has a KM for essbase.
So tell me: What is the alternative.

er77 said...

>>Well rules files are ugly.
>> Agree that Load/Build rules are an anachronsim.

Dear Anonymous, if you can't calculate 2 + 2 , you have not rights to say ,mathematics is wrong and stupid