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 config file but different deployments listed. This will grab the output of each report and save it into the results folder that you specified at the bottom of your config file.

To execute the test, open command prompt and cd to your folder. Mine is D:\ Next run the following command:

bin\obibvt.bat –config <Path to scripts folder and config file> -deployment <The name you gave the first instance in your config file> 

In my environment, I would run the following:

bin\obibvt.bat –config Scripts\SST_Report_Test.xml –deployment 11gDev -password 

You’ll be able to watch the output in the command prompt of how many reports it found and the progress running them.

If you are running the UI test, you’ll actually see browser windows open up on your computer, BVT will log you in and navigate to the report to run. If you set your config Thread Query Size greater than 1, you’ll see multiple browser windows open at once. Go ahead and surf social media while your computer makes you look busy running report. I’m sure the boss will be impressed. 😆

I was watching BVT type my username into this browser window as I took the screenshot

Once the test finishes, in command prompt hit the up arrow to pull up your last command and change your deployment name to your second instance that you want to test. For me this is production so I’d run:

bin\obibvt.bat –config Scripts\SST_Report_Test.xml –deployment 11gProd -password

At this point if you navigate in file explorer to your results folder, you should see two folders, one for each deployment that you ran BVT against. Under those deployment folders you’ll see a folder for each plugin test that you ran and then within those folders you’ll see your OBI catalog as folders containing the report exports which will be used for comparison.

Results folder with both instances named that I ran this BVT against
Within each report environment folder that I ran BVT on, the next level of folders are the tests I ran. The exports of the report results are contained in each of these folders.

Comparing the report exports

The last step for BVT is to run a command to compare the exports that were taken. Go back to command prompt for this step.

You should still be in the folder. Run the following command:

bin\obibvt.bat –compareresults <Results folder name>\<First Deployment Name> <Results folder name>\<Second Deployment Name> -config <Path to scripts folder and config file>

I ran the following:

bin\obibvt.bat –compareresults SST_Report_Results\11gDev SST_Report_Results\11gProd -config Scripts\SST_Report_Test.xml

I haven’t seen this take more than a minute to run. It’s much faster than the actual running of the reports!

Note: If you enabled timestamps on your results folders, you’ll need to lookup the specific folder name with that timestamp and enter that in as part of the folder name when comparing results. To be honest, I find this to be a pain so I back up my results folders if needed manually before running bvt again.

Important! I learned the hard way that the compareresults command will overwrite anything in your Comparisons folder for those same deployment tests. Since I prefer to run BVT on separate folders in the same instances, I’ve made it a habit to copy the results into another folder before running compare again.

Finding the BVT Test Results

After you run the –compareresults command, the results of the comparison will be stored in a folder in the folder called Comparisons. The next level will contain a folder with the two deployments that you ran the comparison against. Within that folder you’ll see a folder for each test plugin that you ran. Finally you’ll see an HTML file named after the plugin (ie. ReportPlugin.html, CatalogPlugin.html, etc.) which is the gold at the end of the rainbow that you were searching for. Open this HTML file in a web browser.

BVT results folder for Reports Plug In test

Finding the Test’s Export Files

No matter which test I’m running, I’ve found it useful to pull up the export files to determine what is different between the two environments when a report shows as Failed on the test plug-in. It’s not easy to navigate to these folders but it’s logical once you get the hang of it.

  1. In file explorer, navigate to the Results folder within your BVT folder (recall that you specified the name of the results folder in your config). The results folder may contain a timestamp if you specified that in the config also.
  2. Choose the name of the deployment for the export you’d like to open.
  3. Choose the name of the plug-in test you ran.
  4. Navigate through your catalog path to the results file. (ie. Shared — Sales — etc.)

As I’ve mentioned before, I like to pull these export files up side-by-side to easily view the differences between the environments. There are multiple tools that can do this for your csv or xml output files from the Report and Dashboard plug-ins. One I like is BeyondCompare which gives you a free 30 day trial. This tool will highlight differences in red so you can easily spot where things are different between the two environments.

Stay tuned for Part 4 of this series where I show you how to read the BVT results.

Using Oracle’s Baseline Validation Tool with OBIEE — Part 3 was originally published in Red Pill Analytics on Medium, where people are continuing the conversation by highlighting and responding to this story.

Two Minute Tutorial: Setting Up a Database for OAC - 16-Mar-2018 11:54 - US-Analytics

In this “two-minute tutorial,” I’ll walk you through the steps for setting up a database for OAC. This blog post does come with a caveat: while it will probably only take you two minutes or a little longer to set up the database, you have to wait for Oracle to create the database. That might take about 30 minutes.

But, after the half hour is up, you can get to work on your OAC build, which will be covered in my next blog post.

DEVEPM will be at Kscope18! - 14-Mar-2018 13:19 - Ricardo Giampaoli
Hi all, how are you doing? With some delay (same as last year, I was on vacation 🙂 ) we are very happy to announce that DEVEPM will be once again at KScope! We are very honored to be selected to present on the best EPM conference in the word! We got two presentations in, […]
ODTUG Kscope18 EPM & BI Content SNEAK PEEK! - 14-Mar-2018 11:46 - ODTUG Kscope
The official ODTUG Kscope18 content announcement is Monday, March 19, 2018! We're SO excited that we wanted to share a content sneak peek from Tiffany Briseño, the EPM and BI ODTUG Kscope18 content chair.
ODTUG Kscope18 APEX & Database Content SNEAK PEEK! - 14-Mar-2018 11:44 - ODTUG Kscope
The official ODTUG Kscope18 content announcement is Monday, March 19, 2018! We're SO excited that we wanted to share a content sneak peek from Jorge Rimblas, the APEX and Database ODTUG Kscope18 content chair.
12 OBIEE Performance Tips You Need to Know - 13-Mar-2018 15:09 - US-Analytics

If your users are complaining about performance issues, you know you have problems. But, what are they? How do you solve them?

As the administrator, you want to be on top of these performance issues, solving them before they affect your users. These 12 performance tips can help you become a more proactive administrator.

Oracle Development User Tools Group (ODTUG), an Oracle user group community focused on education, announced that it has adopted Oracle’s Enterprise Planning and Budgeting Cloud Service (EPBCS) to manage the organization’s financial reporting and budgeting needs.
Oracle Code Presentation March 2018 - 12-Mar-2018 09:46 - Brendan Tierney

Last week I was presenting at Oracle Code in New York. I've presented at a few Oracle Code events over the past 12 months and it is always interesting to meet and talk with developers from around the World.

The title of my presentation this time was 'SQL: The one language to rule all your data'.

I've given this presentation a few times at different events (POUG, OOW, Oracle Code). I take the contents of this presentation for granted and that most people know these things. But the opposite is true. Well a lot of people do know these things, but a magnitude more do not seem to know.

For example, at last weeks Oracle Code event, I had about 100 people in the room. I started out by asking the attendees 'How many of you write SQL every day?'. About 90% put up their hand. Then a few minutes later after I start talking about various statistical functions in the database, I then ask them to 'Count how many statistical functions they have used?' I then asked them to raise their hands if they use over five statistical functions. About eight people put up their hands. Then I asked how many people use over ten functions. To my surprise only one (yes one) person put up their hand.

The feedback from the attendees was fantastic and they were very eager to go back to their day jobs and start implementing better SQL code and to learn more about the database. All they have to do is to send me 15% of their pay rises (a bit of a joke during the presentation. You had to be there ...)

The first half of the presentation talks about statistical, analytical and machine learning in the database.

The second half covers some (not all) of the various data types and locations of data that can be accessed from the database.

The presentation then concludes with the title of the presentation about SQL being the one language to rule all your data.

Based on last weeks experience, it looks like a lot more people need to hear it !

Hopefully I'll get the chance to share this presentation with other events and Oracle User Group conferences.

Two of the key take away messages are:

  • Google makes us stupid
  • We need to RTFM more often

Here is a link to the slides on SlideShare

And I recorded a short video about the presentation with Bob from OTN/ODC.

Two Minute Tutorial: OAC Creation Error Workaround - 09-Mar-2018 14:53 - US-Analytics

OAC: Oracle Analytics Cloud(OAC) Service Creation fails with "PSM-LCM-01008 Unable to create service" Error (Doc ID 2353287.1)

I was unable to find the GUID ID referenced in the above Doc ID — so I fought until I found a way to find it. This is most likely due to the most recent version of OAC and the cloud having slightly different screens and naming for things. In this quick blog post, I’ll go through the steps for a workaround for finding the GUID for your storage containers:

The Value of Adding Commentary to OBIEE - 09-Mar-2018 11:04 - US-Analytics

As you probably already know, OBIEE does not have a commentary function built in.

So, you and your team are probably using manual workarounds — taking screenshots, adding text descriptions, referencing documents in email attachments — to discuss insights.

But what if you could add comments and documents directly to OBIEE dashboards and reports? How much time and effort would that feature save you?

In this blog post, we’ll share how you can implement that functionality with one simple tool and — more importantly — how it will help your team.