May 27, 2009

Query Failed: [nQSError: 42043] An external aggregate is found in an outer query

I thought this might be useful for someone struggling with Essbase. Client was on OBI 10.1.3.4.0 QF 170 and Oracle’s Hyperion Essbase 9.3.1 and running a […]
May 18, 2009

Creating a table view with two levels of headers

This tutorial applies to:Business Intelligence Server Enterprise Edition – Version: 10.1.3.4.0 [1900] – Release: 10g The question was rather frequent – “How to create a table […]
May 18, 2009

OBI SERVER GENERATES INCORRECT SQL WHEN ‘BETWEEN’ AND ‘OR’ CLAUSES EXCEED EIGHT IN WHERE CLAUSE

When running a report using eight BETWEEN clauses or less for a report that should bring back zero rows, for example SELECT Products.Brand saw_0 FROM Paint […]
May 11, 2009

OBIEE Certification

Still there’s nothing from Oracle in regards to official OBIEE certification. Latest official info is here: http://blogs.oracle.com/certification/2008/09/obiee_certification.html My personal opinion is that although a certification program […]