OBIEE Repository Modelling Articles

Here are a few useful articles I came across concerning OBIEE repository (RPD) modelling. They are posted on Oracle BI Development’s BI Foundation blog and might be of use to anyone starting out in the OBIEE repository for the first time. Designing a Query Factory Dimensional Schema Shapes Conformed Logical Dimensions Full credit to Bob […]

OBIEE Multi-Environment Quick Login

Here’s a little snippet that can save time if you often need to switch between multiple OBIEE instances (Local, Dev, QA, Prod etc.) It can be a pain to type your username and password over and over so I came up with a one-click launch page. I like set my browser home page up with […]

nQSError 15019? Check your keys

Does this error sound familiar? [nQSError: 15019] Table <Logical table name> is functionally dependent upon level <Logical level>, but a more detailed child level has associated columns from that same table or a more detailed table. The¬†problem is most often¬†encountered when you have multiple logical table sources, each with a different grain and a single […]

OBIEE Dynamic Column Headings

A common requirement I come across is to create a report with dynamic column titles. For example a column should be labelled ‘Mar 11’ rather than Revenue and this should change each month with the data. Easy you would think? Well sadly not as easy at it perhaps should be from an enterprise BI product. […]

OBIEE Inline Microcharts using Google Charts API

By using a combination of techniques it is possible to display charts inline, within an OBIEE report. In other words we can achieve this type of ‘sparkline’ trend indicator instead of a plain table. To achieve this we need to make use of Google’s excellent chart API. The following example is a bit of a […]

OBIEE Hide the Refresh link within the No Results view – Revisited

Following on from this earlier post, reader Leigh has been in touch with a good idea to hide the refresh link on the ‘No Results’ page using only CSS to make the containing, html td element hide. It’s cross browser compliant and has been tested on OBIEE 10g and 11gR1. For 10.x you will still […]

OBIEE Dynamic Dashboard Prompts

Sometimes I need to create a dashboard prompt that shows only the most recent x periods. I like to make this dynamic so that the values are not hard-coded and the prompt can survive when new data appears in the warehouse. The best way I have found to acheive this is to create the prompt […]

OBIEE and SQL Server Analysis Services Cubes

Recently I’ve been working on a client project that brings together data from a number of sources, one of them being Microsoft SQL Server Analysis Services OLAP cubes. I thought I’d compile a few notes here to explain the current level of support for SSAS in OBIEE and some of the limitations in using this […]

nQSError: 59012

I came across a strange problem today when trying to use the Ago time series function. I made a simple formula to show the change in a measure between current month and last month. Easy you would think: Folder.Measure – Ago(Folder.Measure, DateFolder.Month, 1) However, this resulted in: [nQSError: 59012] UnderFlow occurred during the execution of […]

[nQSError: 46008] Internal error: File .\DataType\SUKeyCompare.cpp, line xyz. (HY000)

There seems to be a number of causes for this error but in my experience it is most often encountered in a federated data model bringing data from different fact tables – joined by conformed dimensions – in which you have multiple sources for logical tables in the Business Model and Mapping layer. If you […]

keep looking »