Get yourself a virtual machine (VM)! With a VM its easy to snapshot along the way or start all over again. If your machine is not capabale of hosting a VM than perhaps pick an older or newer laptop / desktop with 8GB of memory to spare that you do not mind installing / filling […]
Get Down to Business with Business !ntelligence 12c Read More »
Oracle 12c, TipsRecently, Red Pill Analytics announced an innovative new training simulation for those who not only want to learn how to use OBIEE 12c, but also want to learn how to use it effectively in the real world. We call this new training “The Jump Program,” named after a simulation program in our favorite move The Matrix.
You Have To Let It All Go Read More »
Events, Red Pill News, TrainingAlmost 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
A number of months ago I wrote a story on how Mike Riley reached out to myself and a few others to head-up ODTUG’s new Community initiative for the BI space. In that story, I talked about meet ups being one of the core areas of focus in 2015, but more specifically meetups that generate a sense of fun and
ODTUG BI Meet Up 2015 Read More »
Events, Red Pill NewsNext 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, Tips