Business Objects correlation

18 May, 2007 – 10:30 am

I have been working on some template LoadRunner scripts for Business Objects Web Intelligence / Crystal Reports which require good ole fashioned manual correlation.

Before writing this post, in the background I have been working on a tool comparison between LoadRunner and my increasing favourite JMeter with a simple (?) scripting exercise that goes through recording, replaying and correlating data for Business Objects. Common to both tools, is the requirement to correlate essential run time data. As my good Dutch friend Desiderius Erasmus once told us in 1466 …

In the land of the blind, the one-eyed man is king.
[In regione caecorum rex est luscus.]

Knowing how to correlate is key …

But how?

I’m not sure knowing how to correlate is something that can be taught. But I could be wrong. Inevitably I think it’s practice but a good (simple) tool can go a long way to helping your cause. And I’m not talking about LoadRunner either and it’s ability to automatically correlate data.

The tools I like and the reasons why are listed as follows:

1. Start off with something simple that can capture (record) a clean/working session. End to end. For this simple task I like to use Mozilla’s plugin for firefox called Live HTTP Headers
.

2. Once you have your clean session, you can always refer back to it for later comparison. I also like to save multiple copies ofclean sessions in whatever load testing tool I’m using be it Load Runner or JMeter. However with something like Live HTTP Headers you are going to get all the detail including HTTP headers, content types, what’s being written to cookies, User-Agents and a multitude of other tid-bits that have affected automated attempts for me in the past…

3. Make use of tools already at your disposal. LoadRunner’s implementation of WDiff is handy but my favourite tool for file comparisons and a multitude of other handy features is GVim.

4. On the subject of vim, once you find the data that needs to be correlated, finding where it exists in the session is a lot easier, especially with search highlighting.

5. When all else fails, or you are having difficulty playing spot the difference, you can’t go past diff tools. If you’re using GVim you’ll get a nice side by side comparison of the data you are trying to diff. I recommend that you RTFM on diff tools, as a proper understanding will save you alot of time. I remember being quite put off by diff when I first starting using it but can’t recommend it strongly enough now.

So that’s it for the tools. Back to the topic at hand, for those that just wanted to know how to correlate Business Objects, the key data that needs to be correlated regardless of your choice in load testing tools are:

1. Cookies - quite obviously. Add the Cookie Manager to your test plan (JMeter users) if you haven’t already done so. Goes without saying. LoadRunner will handle this for you by default.

2. The logon object has a query parameter called token that you’ll need to parametize:

// {param_token} = "NUS740PI:36400@1566JMtQROFQXUPQDwl41563J0P6vGHijC9eTob4ONEOFF"
  web_reg_save_param("param_token",
    "LB=token=",
    "RB=&",
    "Ord=1",
    "Search=Body",
    "RelFrameId=1",
    LAST);


2. The main ‘body’ of your script will require sEntry or strEntry to be parametized. But that’s the tricky part and to be honest, something I wasted a few hours trying to puzzle out. sEntry is a changing dynamic value, so you need to parametize it at different points through your script. I know that’s a tautology in itself, but what I’m trying to say is that it has more than one value. You won’t get away with parametizing it at the first instance. The only way I spotted this was using diff and search highlighting in vim.

// {param_getPrompts_sEntry} created by tim.koopmans@90kts.com
// must precede web_url("viewCDZDocument.jsp" ...
  web_reg_save_param("param_getPrompts_sEntry",
    "LB=sEntry=",
    "RB=&",
    "Ord=1",
    "RelFrameId=1",
    "Search=Body",
    "IgnoreRedirections=Yes",
    LAST);
 
// Parameter {param_processPrompts_sEntry} created by tim.koopmans@90kts.com
// must preced web_url("getPrompts.jsp" ...
  web_reg_save_param("param_processPrompts_sEntry",
    "LB=strEntry=\"",
    "RB=\"",
    "Ord=1",
    "RelFrameId=1",
    "Search=Body",
    "IgnoreRedirections=Yes",
    LAST);
 
// Parameter {param_report_sEntry} created by tim.koopmans@90kts.com
// must precede  web_submit_data("processPrompts.jsp" ...
  web_reg_save_param("param_report_sEntry",
    "LB=sEntry=",
    "RB=&",
    "Ord=1",
    "RelFrameId=1",
    "Search=Body",
    "IgnoreRedirections=Yes",
    LAST);

Hopefully that saves someone else some pain when correlating data for Business Objects.