Displaying Data in Tables

The simplest style for displaying data is tables.

• Vertical tables: The vertical presentation style is the default style for presenting data. Vertical tables display header cells at the top of the table and the corresponding data in columns. By default, the header cells display the names of the dimensions, attributes, and measures included in the table. The body cells display the corresponding values.
• Horizontal or financial tables: A horizontal or financial table is similar to a vertical table, except that the data runs horizontally, rather than vertically. By default, the row headers display the names of the dimensions, attributes, and measures included in the table. The body cells display the corresponding values. The horizontal table format is useful for reports with several measures, such as financial reports and balance sheets.
• Cross tables: The appearance of a cross table is similar to that of a spreadsheet. The table displays data in a matrix in which the row and column headings describe the contents of each cell. Cross tables are most often used to show the cross-section of three axes of information. Cross tables display values for dimensions across the top axis and on the left axis. The body displays the values of a measure that correspond to the cross-section of the dimensions.
• Forms: Forms are useful in a report when you want to display detailed information for each customer, product, or partner. For example, a form is a useful way of displaying individual customer records with information such as the customer account, name, and address. You can also use forms to format address labels for envelopes.

Insert a Table

Creating a table with the Main Side Panel and the Build Side Panel:

Change Table Type

In Web Intelligence, changing the type of a table allows you to modify the way the data is presented and manipulated. The point of changing the type of a table is to customize the visual representation and behavior of the table to better suit your reporting and analysis needs.

When you want to add a new object to a table that is not in the query, you need to edit your query, add the data object in the Query Panel to the Result Objects panel and run the query before you can add the object to an existing table.

Watch this video to learn about the steps to add an object to an existing table.

In the Feeding sub-tab, under the Data Assignment section, drag an object above or below another object to move its position in the table.

You can use one of the copy and paste methods to copy a table and paste it as another block in the report.

This technique is useful to show the same data in another format, for example, as a chart with formatting to highlight certain information.

You can delete tables, rows, or columns by using a shortcut menu.