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 […]
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,
OBIEE 11.1.1.7.1 Cross Drilling: Read More »
OBIEE, TipsSo it seems that by default, BI Publisher uses CSS style sheets as opposed to inline CSS when generating reports in HTML format. This is perfectly fine as the reports render fabulously in our favorite browsers. However, in certain popular browser-based email services like Gmail, Hotmail, and so on… not so fabulous.. I first noticed
Emailed BI Publisher Reports in HTML Format Not Showing Properly Read More »
BI Publisher, TipsIf 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
Weblogic Admin Server Fails to Start Read More »
OBIEE, Tips, WeblogicThe Problem Not long ago, Stewart approached me to help him prepare an Amazon Web Services (AWS) environment that he could use for an ODTUG KScope hands-on lab. He sent me the original virtual machine and I got working on importing it into one of our S3 buckets. Usually, this is a pretty easy process (and well documented — thanks
Creating an AWS Image from a Partitioned Virtual Machine Read More »
TipsOverview: 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
BI Publisher Bursting Issue Read More »
BI Publisher, TipsIf 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
ODI Save vs. Save All Read More »
ODI, TipsODI 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
Having ODI 12c Studio Performance & Memory Issues? Read More »
ODI, TipsIf 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
OBIEE Warning: Unused Physical Tables Read More »
OBIEE, TipsAnytime I’m speaking or presenting on either AgileAnalytics or continuous integration/continuous delivery, I usually insert a “Shadow IT Wants Your Soul!” slide complete with an image of Batman lurking in the shadows. For one… I’m a super-hero fan, and there’s always room for Batman. But secondly, and this time seriously: the folks setting the pace for analytics and BI
Continuous Delivery of Analytics and BI: Part 1 Read More »
Tips