Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out, I was right, but for thoroughness sake, I’ll cover both approaches. Using […]
Which Version Was It Again? Read More »
OBIEE, Oracle 12c, TipsWe have seen recently how easily false narratives get picked up and repeated so many times that eventually it is believed as true. Perhaps this is an idea that was borrowed from cooking. Cooking has long been rife with traditions and ideas that have been passed down from generation to generation that while the original
It All Boils Down To Starting Temperature Read More »
Tableau, TipsWe 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, TipsLast time I blogged about getting started with the new Git VCS functionality in Oracle Data Integrator (ODI) 12.2. Then, I promised to write a bit on integrating Git into the deployment process. Firstly, a disclaimer. I used to work for a IT services company that also ran one of the largest ITIL training organizations
Using ODI with Git Versioning — Part 2: A Game of Tag Read More »
GitHubAs I’ve been discussing in my last few blogs, it’s possible to start using OBIEE for analytics, rather than the standard operational reporting and BI that is commonplace. Data science has been quite the buzz the last few years, and no doubt about it, data scientists can bring great value and understanding to an organization,
I think it’s fair to say that I like models. Whether manifested with Legos, metadata, or economic indicators, I love seeing how inputs can affect outputs. So, when I discovered the forecast capabilities in the R suite, I couldn’t wait to give it a go. Never Tell Me the Odds! Many of the companies I have
Use the Force, er… Forecast, I Mean Read More »
Analytics, Data Science, Forecasting, Machine Learning, OBIEEClustering. Whether we’re talking about headaches, compute nodes, or uh, well, I’ll let you fill in the blank… isn’t anything worth doing, worth doing together? Clustering can be a powerful tool for understanding the relationships between data, and in this post I’ll walk through how to use the OBIEE 12c Advanced Analytics Cluster Function. As
Last time I went through some of the basics about getting the latest patch-set of ODI to connect to a GitHub.com VCS repository. Today I will talk a little about versioning our ODI development in Git. Navigator The first point to make is that we can select the objects we wish to version-track in Git,
Using ODI with Git Versioning — Part 1: The Basics Read More »
GitHub, ODITrending 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
Working as an IT Professional I need to adhere to standards; working in consulting these standards may vary between customer organizations. Some places are Agile shops, some are classic waterfall, others use whatever flavor of methodology that suits them best. Two things are a given though: We use source control to protect and version the
Source, The No Longer Secret Sauce Read More »
GitHub