Dimension Layout | Assign dimensions to the row, column, and page axes. |
Database Connection | Displays the database name the grid is accessing. |
Headings - Member Labels | Perform an action: Select Member Name to show member names as the heading. Select Alias:Long Names to show the alias as the heading. Alias is used with Oracle Essbase or Planning Details database connection. Select Description to show the description as the heading. Description is used with a Financial Management data source. It is a default setting with SAP BW.
|
Headings - Row Headings Before | Select the column before which you want to display row headings. For example, select the third column (C), to place the heading before the third column (C). Columns are represented as alphabet characters (A, B, C, and so on). |
Headings - Suppress Repeats | Select to suppress repeated row or column headings. When selected, one column or row heading is displayed across multiple columns or rows. When deselected, the column or row heading is repeated in each column or row. |
Headings - Alias Table | This item is used only in Oracle Essbase and Planning Details. Select the alias table to use when showing aliases. By default, this option is set to the default alias table for the database connection. |
Column Width | Enter the width of all columns in the grid. |
Row Height | Enter the height of all rows in the grid. |
Sort | Click to enable sorting on a range of rows or columns, then click Setup to select sorting options. |
Autosize | Select to enable the system to expand the grid to display all data when viewing or printing. Deselect to control the size of the grid manually. If Autosize is not selected, the report contains scroll bars when viewed online, or it is displayed on separate pages when printed. Note: Autosize will not expand the grid in Workspace view if Freeze Grid Headers is also selected. To view the report within the entire Workspace area, expand the grid size in Reporting Studio. |
Freeze Grid Headers | Select a grid, then select Freeze Grid Headers to keep row and column headings visible when viewing HTML reports in Workspace. If you want to view the report within the entire Workspace area, you must expand the grid size in Reporting StudioStudio. |
Grid POV | Select to display the grid POV bar. The grid POV bar is displayed below the grid title bar. |
Page Beak Before | Select to insert a page break above the grid. The grid is printed on the following page. |
Link to Source Object | This check box is only enabled after the grid is saved to the repository and the Link to Source Object check box is selected. Deselect it to unlink the grid from its source object in the repository. Caution! You cannot reverse this action. |
Add Related Content | Select the rows, columns, or data cells for which you want to provide a link to Related Content. Then select Add Related Content, and click Setup to provides access to another report or a URL through a hyperlink. |
Drill Though | Select to show drill through to Financial Data Quality Management (FDM) links in the report viewer as Related Content links. If drill through is defined in the underlying data source, and this checkbox is selected, then the link will appear as a related content link. By default, this setting is not selected. Note: Drill Through link in Snapshot reports is supported with the following restriction: The drill through link will be resolved when a user clicks on the link (when the user clicks on the drill-through link). If the drill through xml was removed from the data source after the snapshot is saved, the link/underlined value will still show in the report. However when you click on it, nothing happens. This behavior is consistent with the concept of related content links to live data from a snapshot. |