Focal Point
OLAP Customization

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9211097572

March 12, 2008, 10:18 AM
RPond
OLAP Customization
Does anyone know if there is a way to customize the look and feel of tabs, filters, and buttons in an OLAP report? I've looked through tech support and focal point, but I wasn't able to locate any documentation on whether or not this can be done.

Thanks,

Rob


WebFOCUS 716
Linux Kernel-2.6.9 x86_64 64bit
Excel, PDF, HTML, Active Reports, Visual Discovery
March 12, 2008, 10:39 AM
Francis Mariani
You don't specify what version you're on.

I think all you really need to do is examine the result of an OLAP report - view the source. Look for the path where the images are. In WF v5.3 they're here:

Drive:\ibi\WebFOCUS53\ibi_html\javaassist\ibi\html\olap

I would change the images that are in this path, keeping the replacement images to a similar size as the originals, and backing up the originals, of course.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 12, 2008, 03:42 PM
RPond
Francis,

Thank you for your quick response. In WF v7.1 found the files in:

Drive:\ibi\WebFOCUS71\ibi_html\javaassist\images\olap

Once I receive the images I'll try backing everything up and then making the switch.

Thanks,

Rob


WebFOCUS 716
Linux Kernel-2.6.9 x86_64 64bit
Excel, PDF, HTML, Active Reports, Visual Discovery
March 13, 2008, 04:34 AM
GamP
As of 71 release you can customize your olap-environemnt.
The following information is valid for release 713, it may very well be changed in later releases, however I think the basics of it are valid for at least the 71x line.

There are 4 areas to look at.
1- the so-called 'blue lines'
2- the OLAP panel itself
3- the report
4- the OLAP Control panel

1. The blue lines are only shown with olappane top and bottom. Th eimage used for that is in /ibi_html/javaassist/images/olap and is called olapbgtop_fade.gif.
2. The OLAP panel itself. The simplest is the form where there just the olap-button. The images used are called olap_button.gif (normal) and olap_button_hi.gif (mouseover).
Then there is TOP/BOTTOM and TABBED.
All parts of these three are controlled by means of a translation table (javascript file olapctltrans.js, found in /ibi_html/javaassist/intl/en -en is the language specified). In this file you can indicate which skin to use. The value is hardcoded in the file and is set to blue. This is done in the line 'var skincolor="blue";' on one of the first lines in the file.
Two skins are provided - blue and softblue - each in their own directory.
Skins are stored in /ibi_html/javaassist/images/olap/skins.
If you create a custom skin, be advised to create images with exactly the same sizes. You may create your naming, but that is not advisable, since you then will have to change (and maintain) your translation table also.
There are two types of images, one type without words, and one type with words, which consequently are language dependant. In 713 there are several languages implemented for the blue skin only.
3. The report. In the report there are a few images that are used for sorting and for the dimensions. The images used are called olap_blue_box.gif, olap_arrow_dim_large.gif, olap_arrow_dn_large.gif and olap_arrow_up_large.gif.
4.The olap control panel. Fortunately, this is controlled in the same way as the olap panel and uses the same skin setting.

And then there is the OLAP stylesheet, called olapctl.css and located in /ibi_html/javaassist/ibi/html/olap.
It contains a lot of classes that control what the panel(s) look like. I have not been successful in finding out the meaning and purpose of each and every class in the file, but most do have effect in one way or another.

Still, after having gone through all these steps, there still are some things on the OLAP page that can't be styled or in any other way controlled, because of the simple fact that it is hardcoded somewhere in the javascript modules.

This may all have been improved in releases after 713, haven't had the need of looking into this for a later release.

Anyway, good luck with customising. Hope the above has been able to set a direction for you.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
March 19, 2008, 03:53 PM
RPond
GamP,

Thank you very much for the information, it has proven to be extremely useful.

Thanks again,

Rob


WebFOCUS 716
Linux Kernel-2.6.9 x86_64 64bit
Excel, PDF, HTML, Active Reports, Visual Discovery