The Big difference between Oracle BI Applications 7.9.X and 11g is the Integration or ETL tier. 11g no longer uses DAC or Informatica. Instead Oracle Data Integrator replaces those components. This cross-reference I created here is for those thinking of or moving to 11g from 7.9.X. Below, you will find a cross reference guide I […]
OBIA: 7.9.X to 11g (Informatica/DAC to ODI) Cross Reference Guide Read More »
OBIA, TipsA little primer on Slowly Changing Dimensions (SCD). Slowly Changing Dimensions are a star schema design principle and design pattern used to reflect how source data field changes are handled in dimension tables. There are basically 5 types that I know of. Of which 2 are the most prevalent and used in OBIA. These 2
OBIA 11g: Dimension Ch-Ch-Changes Read More »
OBIA, TipsMy whole data career has been about finding the truth within data, seeking correlations within and between data sources (and not always relational sources at that). You get to notice patterns in the world and even develop skills to spot outliers on a rapidly scrolling screen. In those early days I used tools like i2
Who doesn’t love a solid VM workstation? I’m a big fan of these given their scalability and low maintenance (just update that master image and redeploy!). Not to mention the fact that I can use fancy buzzwords like “cloud” and “virtualization”. Jokes aside, VMs are awesome developer tools and here at Red Pill, we recommend using
When Node Manager and OPMN Won’t Play Nicely Read More »
OBIEE, TipsWhat are you in for when migrating from OBIEE 11g to 12c? Short answer is there is a lot less pain going from 11g to 12c than there was going from OBIEE 10g to 11g. The upgrade to 12c is an out of place upgrade as was the 10g to 11g which means new software
How It’ll Go Down – Upgrading OBIEE 11g to 12c Read More »
Oracle 12c, TipsLast week I presented at the BIWA Summit a “Cage Match” between Oracle Business Intelligence (OBIEE) Answers and Data Visualization. In full disclosure, these slides were created by Kevin McGinley and I simply was the presenter of these slides. However, I believe that I set the bar high for when Kevin presents these next. 🙂 This
The Cage Match between OBIEE Answers and Data Visualization Read More »
Data Visualization, Oracle DV, TipsI’m super-excited about a presentation I’m giving with Kellyn PotVin-Gormanat RMOUG Training Days next month, called Performance Analytics: Visualizing the Power of the AWR Warehouse. Alright… if you insist… I’ll give a quick plug. Kellyn and the team have been working to build the AWR Warehouse component of Enteprise Manager to store Automatic Workload Repository (AWR) history for the
Does Oracle Database 12c Just Not Work on Windows? Read More »
Oracle 12c, TipsWelcome 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
OBIEE 12c – Where It All Went Read More »
Oracle 12c, TipsGet 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, TipsAlmost 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
