Tags

UCP Alert— Unidentified Connection Pools

May 19, 2016

|

by: GregSuk

|

Categories: Direct Database Request, OBIEE, Tips

The other day I was playing around with the Direct Database Request (DDR) feature within OBIEE. The reason I did this is I wanted to create a report that utilized columns from the database that were not exposed in OBIEE, yet still utilize the functionality of OBIEE. Why else would you use this and how […]

Help! The WebLogic Dog Ate My Pages!

April 27, 2016

|

by: Phil Goerdt

|

Categories: OBIEE, Tips, Weblogic Server

Help! The WebLogic Dog Ate My Pages!

OBIEE 11.1.1.9.0 is a big step up from the earlier versions, and there are plenty of great things to appreciate about it. However, one thing that I am not that excited about is an error that crops up from time to time in Enterprise Manager. The mystery error looks a little like this: As usual, […]

Mind the Gap — Getting the Number on ODI Sequences

April 25, 2016

|

by: pete.scott

|

Categories: ODI, Tips

Mind the Gap — Getting the Number on ODI Sequences

At work last week I lifted the covers on the Red Pill Analytics Slowly Changing Dimension ODI IKM for Oracle. If you haven’t heard about this knowledge module, it was specifically written to take a dimension source table and transform it to a slowly changing dimension target table. Unlike other similar IKMs, this module uses […]

ODI 12 LOOKUP Components

April 14, 2016

|

by: pete.scott

|

Categories: ODI, Tips

ODI 12 LOOKUP Components

In the depths of time before ODI 12c, ODI Studio had a fairly simple canvas to design our interfaces. We dropped on our datastores (tables) and then dragged columns between tables to create joins, and columns to the canvas to make filters. If we needed to use expressions we just typed them on the target […]

OBIA: 7.9.X to 11g (Informatica/DAC to ODI) Cross Reference Guide

April 4, 2016

|

by: FrankDavis

|

Categories: OBIA, Tips

OBIA: 7.9.X to 11g (Informatica/DAC to ODI) Cross Reference Guide

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 11g: Dimension Ch-Ch-Changes

March 16, 2016

|

by: FrankDavis

|

Categories: OBIA, Tips

OBIA 11g: Dimension Ch-Ch-Changes

A 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 […]

Making Stuff Up

March 8, 2016

|

by: pete.scott

|

Categories: General, SQL, Tips

Making Stuff Up

My 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 […]

When Node Manager and OPMN Won’t Play Nicely

March 7, 2016

|

by: Phil Goerdt

|

Categories: OBIEE, Tips

When Node Manager and OPMN Won’t Play Nicely

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 […]

12Page 3 of 645»