Using Interactive Crosstabs, you can add, remove, reorganize, and customize the data in a cross tab to examine relationships and trends. Interactive cross tabs provides you with the ability to drill down into dimension levels to display detail data, drill up to display summary data, filter, group, and sort data in a cross tab, perform calculations, create aggregate data, and display cross tab data in a grid or in a chart. These actions enable you to gather business intelligence information such as a product’s sales over a period of time, which products sell more or less by geography, how many units of a product shipped in a specific month, and so on.
You can launch Interactive Crosstabs in the following ways:
Navigate to a BIRT data object store (.data) file containing a cube or data model in the iHub volume. Choose the file and select an available cube or data model. Interactive Crosstabs launches displaying the selected data source. You can now create a cross tab.
Obtain a URL link from your report developer or system administrator to supported BIRT cube view (.cubeview) files or BIRT data object store (.data) files containing a cube or data model. In Interactive Crosstabs, you can modify the BIRT cube view file or create a cross tab using the BIRT data object store (.data) file.
Launch Interactive Crosstabs when viewing a cross tab in other applications such as BIRT Studio or Interactive Viewer. You can view and modify cross tabs in BIRT cube view (.cubeview) files, BIRT design (.rptdesign) files, and BIRT document (.rptdocument) files.
Use Actuate JavaScript API to access Interactive Crosstabs embedded in a web page by a developer. For more information see Actuate BIRT Java Components Developer Guide.
When you create a cross tab either in BIRT Designer Professional, BIRT Studio, or Interactive Crosstabs, you can use Interactive Viewer or Interactive Crosstabs to modify the cross tab. You can use either application to format cross tab data to change the appearance of specific values, display detail information for data values to view summary information at a glance, or modify a chart. You can also export cross tab content to other formats such as Excel, Word, PowerPoint, PostScript, PDF or XHTML. If you save a cross tab using Interactive Crosstabs or Interactive Viewer, you can save the cross tab as a BIRT cube view (.cubeview) file, a BIRT design (.rptdesign) file, or a BIRT document (.rptdocument) file. If you open a cross tab in BIRT Studio and modify it using Interactive Crosstabs, you must save the cross tab as a BIRT design file. You can print a cross tab using Interactive Viewer.
Navigate to a BIRT data object store (.data) file containing a cube or data model in the iHub volume. Choose the file and select an available cube or data model. Interactive Crosstabs launches displaying the selected data source. You can now create a cross tab.