We all get by with a little help from our friends. Let us share a tech tip with you and offer you an opportunity to learn more from the Red Pill Analytics team. I came across a table with some troublesome duplicated rows and wanted to remove these dups so I used an old query of […]
Duplicated Rows No More Read More »
Red Pill Analytics Tips, TipsTrending Up Using the Trend Line Function in OBIEE 12c One of the new features in OBIEE 12c is the availability of an “internal” R instance. This instance will allow the execution of R scripts, and the folks at Oracle have been kind enough to include some functions out of the box with the OBIEE 12c
Yoda’s skepticism of Luke Skywalker’s readiness to begin training as a Jedi Knight was probably appropriate. I mean, if some guy wearing Marty McFly’s life preserver vest crash landed into my backyard with his robot sidekick in tow and brought a bad attitude too, I might feel the same way. Thankfully, Obi-Wan talked Yoda off
Too Old to Begin the Training? Read More »
Red Pill News, Tips, TrainingIf you read my Oracle Open World: A Newbie’s Retrospective post, I’ve hopefully convinced you that conferences are must-attend events. The knowledge-gain and networking opportunities offered across a few days simply can’t be matched elsewhere. To maximize your conference experiences, you should not only attend, but also speak. How does one get started on the conference speaking circuit?
How To Break Into the Conference Speaking Circuit Read More »
Events, TipsI know it sounds like I am writing about 1980s technology, and I am, but the fact remains that Excel is still a widely used tool in the business world. Besides, what else would you put your data dumps into? Often Excel reports get used for management reporting, which comes with a number of issues.
How to get BI with Excel Read More »
Analytics, BICS, Business Intelligence, Cloud, Coding, Data Visualization, Excel, Oracle, Tips, VBAWhether you are using Excel as a data source for your Business Intelligence (BI) platform, or you are doing the actual analysis within Excel, your data will need to be in a format that is queryable. Often though, the data is formatted to be read visually, whether an export from a system, or manually entered.
Preparing Excel Data For Analysis Read More »
Big Data, Business Intelligence, Excel, Red Pill Analytics Tips, Tips, VBAThe 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
UCP Alert— Unidentified Connection Pools Read More »
Direct Database Request, OBIEE, TipsOBIEE 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,
Help! The WebLogic Dog Ate My Pages! Read More »
OBIEE, Tips, Weblogic ServerAt 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
Mind the Gap — Getting the Number on ODI Sequences Read More »
ODI, TipsIn 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
ODI 12 LOOKUP Components Read More »
ODI, Tips