|An||CHARacter (fixed length)|
|AnV||CHARacter VARying (maximum length)|
|TX||TEXT, CLOB – Character Large Object|
|BLOB||BLOB – Binary Large Object|
|I2||SMALLINT – 2 bytes|
|I4||INTEGER – 4 bytes|
|F||FLOAT – floating point 4 bytes|
|D||DOUBLE PRECISION – floating point 8 bytes|
|Pn||PACKED DECIMAL (number of bytes specified 1-16)|
A common piece of functionality in most programming languages is a search and replace character function; the more sophisticated languages allow for regular expressions. In any case, here’s how to do a search and replace character in a string using WebFOCUS:
This one was was buried in a forum thread. Note that this is as of WebFOCUS 7.1.3.
WebFOCUS is a rich language that you can do almost anything with. Unfortunately, the depth of the language makes it hard to find how to do certain tasks; I’ve had to search very hard in our documentation, Focal Point, and Google to accomplish what I would consider common tasks.
Here’s an example. When I first started to learn WebFOCUS, I was trying to show the leading zero of a fractional 0 value in a report.
I.e. a zero real value shows up like .00 instead of 0.00.
In most cases that’s fine to save real estate. However, I like it with the leading zero to help with visually aligning decimal places. Simple enough task right? It is, but you have to know the right command and what to search for.
I searched for (always preceding with WebFOCUS):
• Add a zero to a real number in a report
• Suppressing zero values in report (the opposite)
• Formatting numeric values
It took a while (20 minutes), to find what I was looking for. It was:
SET CENT-ZERO = ON
It’s easy to do, just hard to find how to do it.
This got me thinking; I thought it would be useful to start blogging about various features I’ve found and sharing them with Google. The trick is adding the right keywords to make it easier to find things.
Hopefully, everyone can benefit from this activity. I know I will when a have a mental lapse.
This post is going to provide step by step instructions on how to implement sparklines
within WebFOCUS reports using a jquery plugin rather than the standard Information
Builders approach. The major advantage with this technique is it’s quite simple to implement and maintain because of the small code footprint.
Who is this for?
- Intermediate WebFOCUS knowledge is required
with reading APIs
In most reports, you typically have a column that represents a dimension (a grouping)
and values of measures for that row. Here’s an example:
Additional context that would be useful would be to provide how the measure is doing
over time. This is where sparklines can be used.
A sparkline is a very small line chart, typically drawn without axes or coordinates
Here is an example of a sparkline that shows the trend of a fictitious trading index:
Now I’m going to show you a way to do that with WebFOCUS.
- Download the Excel spreadsheet
here and upload it to your WebFOCUS application folder (mine is called sparkline-example)
by right clicking on the folder, choosing ‘New’->’Upload Data’ and follow the wizard.
- This process will create a master file called Sheet1 assuming you choose all default
- Download this
fex file and place into your WebFOCUS app folder that you added the Excel spreadsheet
to. Read the in line comments to understand what’s going on.
- Finally, add the js files to your web application folder. You can download the js
If you got everything set up properly, it should look like this when you run the
The major gotcha is you will not be able to render this WebFOCUS report
as a PDF or do a page print with your browser. I.e. use this technique only if these are not required.
For those who have visited my blog before, you’ll notice that I don’t have any posts before November 2013. Well, that’s because my old hosting service decommissioned the server without letting me know.
Always the eternal optimist, I see this as an opportunity to reboot my blog. I’m going to revisit a few concepts including some data visualization techniques and WebFOCUS specific examples.
I hope to have something new up later this week.
Stay tuned for updates.