This post is part 4 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). The previous posts are: Post 1: An intro to BVT Post 2: Setting up BVT Post 3: Running the Tests Interpreting the BVT Results As described in my third post in this series, here’s how to […]
This post is part 3 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Post 1 with an intro to BVT, can be found here. Post 2 about setting up BVT to run, can be found here. Running the Test Against Both Environments We need to execute BVT twice with the same […]
This post is part 2 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Post 1 with an intro to BVT, can be found here. Obtain the BVT tool Download the latest version of BVT from Oracle. http://www.oracle.com/technetwork/middleware/bi/downloads/bi-bvt-download-3587672.html Unzip the download into a directory on your computer. To save yourself typing later on, […]
I have a report that works fine in OBIEE 11g but when upgraded to 12.2.1.2, it gives an error stating: [nQSError: 22025] Function TimestampAdd is called with an incompatible type. This report has a SQL Expression in a filter that states: TimestampAdd(SQL_TSI_HOUR, 4.5, CURRENT_DATE) The problem is that we are trying to add hours onto […]
This post is part 1 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Overview of BVT With the 12c release of OBIEE, Oracle released a new tool called the Baseline Validation Tool or BVT. This tool allows you to run specific tests against your OBIEE reports, dashboards, and BI Publisher […]
Some of the best presentations at Oracle Open World are on User Group Sunday, on Oct 1st. It can be challenging to pay attention in sessions though when your stomach is growling because there’s no conference meal that day. Regional User Groups have the solution! Join regional user groups at the Children’s Museum next to […]
Last month a new R package was released called ODBC to improve the ability to connect to relational databases. By using these universal connection packages such as DBI and ODBC, you’ll be able to easily port your code to different databases. If you currently use RODBC to connect to Oracle, you’ll like ODBC more! ODBC […]
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. You spend all of this time and effort putting together an analysis to share with your users. But wait! Are your users able […]
Last Saturday an idea I’ve been wanting to do for a while finally came to fruition. I was able to pair up the resources around me and host a coding event for girls in Salt Lake City at the University of Utah campus called Let U Girls Code. I couldn’t have done this without Tyra […]