Just you just love the speed of reporting on Essbase Cubes. Building the cubes is super fast. Having a simple report with one Measure is a pleasure to to build and run.
Now try doing anything that OBIEE is good at.
How about having a flat hierarchy? No Ok, what about Bins? No?
surely we can put a filter in place? Ah, Of course you can – providing the filter value exists, otherwise your report throws up an error.
Error, no data is an error!!
Ok lets have some nice looking data.
what do you mean every ‘member’ has to unique? And what a member when it’s at home?
I want the value shown to be ‘London‘ not ‘London (location)‘
I hate errors. I hate rubbish looking data. I hate ragged hierarchies. Give me back my Materialised views.
Christian, Venkat, Tony, Oracle – let’s have some decent blogs on this for beginners like me.
BTW We are being good boys and using ASO as recommneded by Edward at the BI Forum 😉