My expectations of an Essbase cube are extremely high. If I'm not getting sub-second response on smallish queries I go back to the drawing board. My initial query on the Hybrid cube was 2.5 seconds. The same query in BSO registers 0 seconds in the log. While 2.5 seconds might not seem like a long time, it is to someone who expects instantaneous response. Also, it will spell disaster for larger queries. So it's back to the drawing board.
First I tried messing with some cache settings. That didn't help at all. Next I tried some unorthodox dense/sparse settings -- also didn't help. So what's next? There are a few possibilities:
- This is one of those *fringe* cases that requires ASO or pure BSO.
- I need to buy better hardware.
- We just need to accept slightly slower retrievals from Hybrid (at least for the time being).
- I'm missing some tuning trick.
The sum total of Hybrid documentation available from Oracle is about two pages in length. That's not much to go on. So what have people seen? Is Hybrid ready for prime time and if so, what are the tuning tricks?