Dimension Layout | Assign dimensions to the row, column, and page axes. |
Database Connection | Database name the grid is accessing. |
Headings - Member Labels | Member Name shows member names as the heading. Alias: User Point of View shows the Point of View as the heading. Alias:Long Names shows the alias as the heading. Alias is used with Essbase Cloud or Planning database connection. Description shows the description as the heading. Description is used with a Financial Management data source. Both shows the member name and alias / description.
|
Headings - Member Labels | Member Name shows member names as the heading. Alias: User Point of View shows the Point of View as the heading. Alias:Long Names shows the alias as the heading. Description shows the description as the heading. Description is used with a Financial Management data source.
|
Headings - Row Headings Before | 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 | 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 | Alias table to use when showing aliases. By default, this option is set to the default alias table for the database connection. Note: When selecting “User Point of View” for the alias table, the User POV's alias table value is used when running any grid against Planning. The member aliases returned will be from that table. Also, this does not affect the “Alias Table” specified in Conditional Formatting or Conditional Suppression where the user indicates a specific alias table and values on the alias. Note: This does not affect the alias table specified in conditional formatting or conditional suppression. In those two areas, an end user indicates a specific alias table and values of the alias in those tables. |
Column Width | Width of all columns in the grid. |
Row Height | Height of all rows in the grid. |
Sort | Sorts a range of rows or columns. Click Setup to select sorting options. |
Autosize | Expands 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 | Keeps row and column headings visible when viewing HTML reports in Planning and Budgeting Cloud Workspace. To view the report within the entire Planning and Budgeting Cloud Workspace area, you must expand the grid size in Reporting Studio. |
Grid POV | Displays the grid POV bar below the grid title bar. |
Page Beak Before | Inserts a page break above the grid. |
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 | 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. |