General Properties
General properties affect the entire grid. Use general properties to edit the following:
Table 4-1 Grid - General Properties
Property Name | Descriptions |
---|---|
Name |
Edit the grid name. A best practice is to name your grids with a meaningful name for easier identification of multiple grids in a report. |
Title |
Specify a grid title, which can include text and Text Functions, to include at the top of the grid output, which can span across column headers. The grid title can also have font, border and shading formatting applied, see the related Formatting Grid Cells. To add multiple lines to the grid title, use the Alt+Enter keys (Option+Enter on the Mac). |
Data Source |
Change the data source for the grid |
Column Width / Row Height |
Set the default column width and row height. |
Row Banding |
Apply shading to alternate rows in a grid. You can select the default shading color. Any columns or rows with existing shading in the grid are not affected by row banding. |
Zoom Zoom Before |
Zoom allows you to expand a row or column parent member to see its children, descendants, or bottom level members when you preview a report in HTML. |
Ancestors Before Children |
Use Ancestor Before Children to display the ancestor members before child members instead of after the child members, when using specific member selection functions such as Children or Descendants. The default setting is False. |
Supporting Details Option |
Select to display Supporting Details either before or after a member, and with or without the unary operator. |
Smart List View |
Select to either display the Smart List Name or Value. |
Drill Through to Source |
To enable Drill Through to Source, where a file attached to a cell at the data source, such as an Oracle Fusion Cloud Enterprise Performance Management cell file attachment or Essbase Linked Reporting Object (LRO), for the entire grid, set Drill Through to Source to "Show". If set to "Hide", individual cells can still be enabled in Cell Properties. See Working with Drill Through and Cell File Attachments. |
Use Expense Variance |
Select to allow the Variance and |
Compare to Zero: Decimal Precision |
The Compare to Zero: Decimal Precision property specifies how many decimal places are used to determine the suppression and text replacement for zero. By default, the property is "Off" and the comparison with zero is exact (for example: data value of 0.0000000001 is not zero). If the value is not "Off", Reports uses the specified number of decimals of precision when comparing against zero. For example:
|
Headings |
|
Member Labels |
Change how the row and column headings are displayed. For example, you can display member names, aliases, or both. Note: These settings can be overridden at the column or row level. See Overriding a Data Row or Column Heading. |
Repeated Heading |
Specify whether to suppress, show or merge repeated row or column headings. |
Alias Table Name |
By default, grids use the alias table that was selected by the end user while previewing the report. However, you can select a different alias table at the grid level. Use Alias Table Name to set an alias table for the grid. |
Row Headings Before |
By using the Row Headings Before Grid General property, you can define a "butterfly report", positioning the row heading between any two columns. See Working with Butterfly Reports. |
Text Options
|
Set the text replacement options for cells with zeroes, no data, error results from a formula, or no access due to cell-level security applied. |
Text character width | The property allows you to choose between more and less conservative sizing of text in a table text cell. The property can have a value of Large, Medium, or Small. By default, the property is set to Large. |
Suppression |
Note: If a grid’s row or column suppression is disabled, at least one data or formula segment, or a text segment with the text functions CellText or CellValue, needs to be displayed in the grid, then the entire grid will be suppressed. If you want to hide all data segments but still want to display the text in the grid, then you can perform one of these steps:
|
Zero Values |
Suppress row and columns with data values of zero. |
No Data |
Suppress rows and columns that contain only cells for which no data exists. NOTE: Formula cells results are not suppressed via "Suppress No Data" (#missing) because:
To suppress data values in formula cells, use conditional suppression to evaluate them. |
No Access |
Suppress rows and columns that contain data that you do not have the security access to view. |
Error |
Suppress rows and columns that contain data in cells that cannot be retrieved or calculated because of errors. |
Missing Blocks |
Suppress blocks of cells for which no data exists in the database. This can improve the efficiency of Suppress Missing Data. However, this option can degrade performance if no or few rows are suppressed. Note:
|
Native (Database) |
Applies row suppression at the Oracle Oracle Essbase level instead of at the business process level, which reduces the amount of data on the business process side and eliminates the impact on query thresholds. Note: This option can degrade performance if no or few rows are suppressed. Test reports before and after using this setting to determine if performance is improved. |
Date Format |
The date format for grid cells that contain dates is derived from the User Preferences date format setting. Use Date Format in grid properties to override the date format with a format specific to the grid. This date format will apply to any date cell values in the grid. If you do not specify a date format for the grid, the format from User Preferences is used. |
Cell Padding
|
Specify the number of pixels used to pad cells vertically and horizontally. The default number is 5 pixels. Migrated Financial Reporting (which does not support cell padding) reports have this value set to zero. |
Grouping
|
Defines how page breaks are handled when previewing the report in PDF format. For more information, see Grouping and Page Breaks |
Conditional Expression Use scaled/rounded value |
To specify whether conditional formatting and suppression, as well as basic (grid, column or row) suppression, use scaled or unscaled raw data values within a condition, use the grid property Use scaled/rounded value.
|