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.
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.
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.
The thin crosstab generates and handles the same events as the other thin presentation beans. In addition, the thin crosstab generates the following events:
PREVIOUS_COLS_EVENT
-- This event is triggered when a user
clicks the Left hyperlink. The crosstab handles
this event.
NEXT_COLS_EVENT
-- This event is triggered when a user clicks
the Right hyperlink. The crosstab handles this
event.