OBIEE 12c – Where It All Went

Welcome as the changes to OBIEE 12c are, the day after install generated for me basic questions to where things went and how things work. Tasks like restarting the system, checking status and moving repositories/catalogs are quite different in 12c. At least they are different enough to have me searching the file system for file […]

Read More

What the Fact?!

Almost always, joining fact tables is a big no-no in data modeling, and for good reason. From time to time however, we need to join fact tables because of architecture decisions that are outside of our control. Palpatine was right — sometimes you need to join the Dark Side. In this post I’ll tell you my method […]

Read More

OBIEE 11.1.1.7.1 Cross Drilling:

Next on the list… cross drilling. In dimensional modeling terms, we refer to this as “drilling across”… as in “drilling across fact tables.” We do this when we need metrics from two or more fact tables in the same analysis. This is easy when the analysis is using all conformed dimensional attributes. In most cases, […]

Read More

Weblogic Admin Server Fails to Start

If you work with OBIEE 11g in an administrative role, one of the most debilitating issues you can experience is an Admin Server that fails to start. A large majority of OBIEE configuration and management tasks take place within the WebLogic Server Administrative Console and Enterprise Manager; when the Admin Server is down, neither tool […]

Read More

BI Publisher Bursting Issue

Overview: Working with a bursting BIP report to be sent out to X number of recipients. The bursting job never completes and stays in ‘Job processor completed’ status indefinitely. Looking at the job details, N number of recipients’ reports are created and delivered. M number, however, are stuck in ‘Rendering Report Document’ statuses. The BIP […]

Read More

ODI Save vs. Save All

If you’ve ever looked at the ODI Menu Bar or File menu, you’ve seen that there are two separate save options: Save and Save All. Big deal, right? Everyone knows the difference between Save and Save All. (If you don’t, Save will save only one object at a time, the active object you have open/are […]

Read More

Having ODI 12c Studio Performance & Memory Issues?

ODI 12c Studio slow to respond? Receiving low or out of memory warnings? ODI 12c Studio crashing? With an out-of-the-box ODI 12c installation, the memory allocated to ODI Studio is generally too low to handle complex tasks — multiple modifications on a complex mapping, regenerating multiple scenarios, prolonged development sessions, etc. When completing such complex tasks over […]

Read More

OBIEE Warning: Unused Physical Tables

If you’ve ever developed an OBIEE Repository (RPD) in which you’ve configured a multi-table Logical Table Source (LTS), you’ve likely been plagued by the following warning: There are physical tables mapped in Logical Table Source “Logical Table Source Name” that are not used in any column mappings or expressions. If you’re a Type-A OBIEE Developer […]

Read More
Page 4 of 6« First...23456