Thin Crosstab Bean

The thin crosstab is a BI Beans thin bean, for use in an HTML-client application. It presents data in a crosstab, in a form that is appropriate for analysis. When you display a View Toolbar in the same HTML page, you can allow users to rotate the data in the thin crosstab, change the view type, sort the data, and apply favorites.

The thin crosstab provides navigation to rows and columns that do not initially appear in the page. Users can navigate by a number of rows or columns, by measure, or by level. For example, in a crosstab in which the column header shows Geography values and then Time values, a user can see the next six rows when they choose Next. Or they can see the columns for the next Geography value, or they can see the columns for the next Quarter or Month in the time dimension.

The ThinBeanUI implementation of the thin crosstab is the oracle.dss.thin.beans.crosstab.ThinCrosstab class. The UINode for the thin crosstab is oracle.dss.thin.beans.crosstab.CrosstabBean. To render a thin crosstab, your servlet must associate the ThinCrosstab object with the CrosstabBean object.

The JSP tag for this bean is the Presentation tag. In the UIX Language, the definition element is the presentationDef element, and the UINode is the presentation element.

To change the appearance of a thin crosstab, you set properties of the ThinCrosstab object. When you work with a crosstab in JDeveloper, that crosstab is a Java-client crosstab. When you save the crosstab, the crosstab is saved as XML. This same XML can then be opened as a thin crosstab in your HTML-client application, but you must configure the BI Beans catalog for thin beans before you open the XML in your application.

You should store a thin crosstab in the HTTP session whenever the thin crosstab displays live data.

The thin crosstab keeps track of the current row and column as state information.

Displaying the paging control

To display the paging control, call the setPagingControlVisible method. You should also use a Find Member dialog, so that the paging control can provide access to all of the members for each page dimension.

Allowing manipulation

Use a View Toolbar to allow users to rotate data, to sort dimension members, to apply favorites, or to change the view type. You can also use the tools individually.

Events that this bean generates and handles

The thin crosstab generates and handles the same events as the other thin presentation beans. In addition, the thin crosstab generates the following events: