Obie does not allow for tables and pivot tables fix the header so that it is always visible. This is especially useful in case of long tables, where the scrolling, the user can easily lose track of what each column contains the data. This limitation can be partly overcome by using a small workaround using Javascript and DHTML. In order to write and not have to invent everything from scratch, you can use ready-made JavaScript libraries available on the web (of course, before their use carefully read the license agreement). So far, my most proven library jQuery (http://jquery.com) and its plugin Fixedtableheader (http://plugins.jquery.com/project/fixedtableheader). How to fix header table is then as follows: I. Online connection to the jQuery 1 / On the dashboard, where a long table with the necessity to fix the header to add text object, check that it contains the HTML and inserts a reference to both libraries: II. Download jQuery on your server 1 / Download latest jQuery library (eg http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js) for ease of use and renamed "jquery.min.js" and as well as download Fixedtableheader plugin (eg http://plugins.jquery.com/files/jquery.fixedtableheader-1-0-2.min.js.txt) for ease of use and renamed "jquery.fixedtableheader.min.js ". 2 / Move both libraries move into the directory [BI_HOME] \ oc4j_bi \ j2ee \ home \ default-web-app \ (root web server). 3 / Restart OC4J (or other Java Container) and the BI Presentation Server 4 / On the dashboard where a long table with the necessity to fix the header text object is added, check that it contains the HTML and insert the reference to both the library: It is then necessary to the same or a new text object (including HTML) to add lines to determine the object (s ) table type on the page, where it is necessary to fix the header. The object (s) on a page can be referenced in different ways (see the documentation on http://jquery.com). I used to identify the table name of the class (in the HTML class ="...."). Obie tables gives the class "ResultsTable" and pivot tables "PivotTable". So if the dashboard table with one header row, then add the following code: If the table has two header rows, then add a parameter specifying the number of lines the header: The pivot table is four header lines applies the following code (note that the pivot table is the identification of other classes!): That is the whole process. In Internet Explorer and Mozilla are not behaving quite correctly in the tables (if the browser font size set to "normal" or smaller). If the browser set font size larger then the pivot table fixed header bit fit. But this is millimeters, and the recognition of which the description in the column headers are not affected.
Posts
