Configuring for Displaying and Processing Data in Views

You can configure various options that change the display and processing of data in views.

See also Using Fusion Middleware Control to Set Configuration Options for Data in Tables and Pivot Tables and Using Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table for related information.

This section contains the following topics:

• Manually Configuring for Data in Views

• Manually Configuring for Graphs and Gauges

• Manually Changing Alternating Bar Color

• Manually Configuring for Interactions in Views

Manually Configuring for Data in Views

You can configure various options that change the processing and display of data in views.

See the following sections:

• Manually Configuring Cube Settings for Pivot Tables and Graphs

• Manually Configuring Settings for Data in Views

• Manually Configuring Settings for Fetching Data for Table Views, Pivot Table Views, and Trellis Views

Manually Configuring Cube Settings for Pivot Tables and Graphs

You can use settings within the Cube element to affect the display and processing of data in pivot tables and graphs. The settings also take effect for XMLA export.

1. Open the instanceconfig.xml file for editing, located in:

   BI_DOMAIN/config/fmwconfig/biconfig/OBIPS

2. Locate the Cube section, in which you must add the following element:

   • CubeMaxRecords — Specifies the maximum number of records that are returned by an analysis for the view to process. This roughly governs the maximum number of cells that can be populated in a view; unpopulated cells in a sparse view do not count. The default is 40000.

3. Include the elements and their ancestor elements as appropriate, as shown in the following example:

   <ServerInstance>
     <Views>
       <Cube>
         <CubeMaxRecords>40000</CubeMaxRecords>
       </Cube>
     </Views>
   </ServerInstance>
   

   Note:

   Both CubeMaxRecords and ResultRowLimit limit the number of rows returned. The limit is determined by the setting with the larger value (see Using Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table).
4. Save your changes and close the file.
5. Restart Oracle Business Intelligence.

Manually Configuring Settings for Data in Views

You can configure a similar group of settings that affects the display of data in table, pivot table, graph, trellis, narrative, ticker, and treemap views.

While the settings are often the same, you must include the element within each appropriate parent element to override the default setting that applies to that view. For example, many of the views use the MaxVisiblePages element. You must include that element within each of the Table, Pivot, Trellis, Charts, and Treemap parent elements, to override the default value of that setting for each of those view types.

1. Open the instanceconfig.xml file for editing, located in:

   BI_DOMAIN/config/fmwconfig/biconfig/OBIPS

2. Locate the Table, Pivot, Trellis, Charts, Narrative, Ticker, and Treemap parent sections, in which you must add the elements that are described in the table below.
3. Include the elements and their ancestor elements as appropriate, as shown in the following example:

   <ServerInstance>
     <Views>
         <Table>
           <MaxCells>10000</MaxCells>
           <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
           <MaxVisiblePages>1000</MaxVisiblePages>
           <MaxVisibleRows>500</MaxVisibleRows>
           <MaxVisibleSections>25</MaxVisibleSections>
           <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
           <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
           <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
           <DefaultRowsDisplayedInDownloadCSV>65000</DefaultRowsDisplayedInDownloadCSV>
         </Table>
         <Pivot>
           <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
           <MaxVisibleColumns>300</MaxVisibleColumns>
           <MaxVisiblePages>1000</MaxVisiblePages>
           <MaxVisibleRows>500</MaxVisibleRows>
           <MaxVisibleSections>25</MaxVisibleSections>
           <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
           <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
           <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
                 </Pivot>
         <Trellis>
           <Simple>
               <MaxCells>1000</MaxCells>
               <MaxVisibleSections>10</MaxVisibleSections>
               <MaxVisiblePages>1000</MaxVisiblePages>
               <MaxVisibleRows>100</MaxVisibleRows>
               <MaxVisibleColumns>75</MaxVisibleColumns>
               <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
               <DefaultRowsDisplayed>10</DefaultRowsDisplayed>
               <DefaultRowsDisplayedInDelivery>100</DefaultRowsDisplayedInDelivery>
               <DefaultRowsDisplayedInDownload>6500</DefaultRowsDisplayedInDownload>
           </Simple>
           <Advanced>
               <MaxCells>5000</MaxCells>
               <MaxVisibleSections>50</MaxVisibleSections>
               <MaxVisiblePages>1000</MaxVisiblePages>
               <MaxVisibleRows>250</MaxVisibleRows>
               <MaxVisibleColumns>150</MaxVisibleColumns>
               <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
               <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
               <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
               <DefaultRowsDisplayedInDownload>10000</DefaultRowsDisplayedInDownload>
           </Advanced>
         </Trellis>
         <Charts>
           <MaxVisibleColumns>2000</MaxVisibleColumns>
           <MaxVisiblePages>1000</MaxVisiblePages>
           <MaxVisibleRows>2000</MaxVisibleRows>
           <MaxVisibleSections>25</MaxVisibleSections>
           <JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>
         </Charts>
         <Narrative>
           <MaxRecords>40000</MaxRecords>
           <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
         </Narrative>
         <Ticker>
           <MaxRecords>40000</MaxRecords>
         </Ticker>
         <Treemap>
           <MaxCells>5000</MaxCells>
           <MaxVisiblePages>10000</MaxVisiblePages>
           <MaxVisibleRows>10000</MaxVisibleRows>
           <MaxVisibleSections>50</MaxVisibleSections>
         </Treemap>
     </Views>
   </ServerInstance>
   

   Note that this example does not include elements that might exist in the file, but that are centrally managed by Fusion Middleware Control and cannot be changed manually.

4. Save your changes and close the file.
5. Restart Oracle Business Intelligence.

The table below describes the common elements that affect the display of data in views. If the user exceeds these values, then the Oracle BI Server returns an error message when the view is rendered.

Element	Description	Default Value	Applicable Views
DefaultRowsDisplayed	Specifies the default number of rows to display in views in analyses and dashboards. This number should not exceed the number that is specified for the MaxVisibleRows element.	25 (10 for Simple Trellis)	Narrative, Pivot Table, Table, Trellis
DefaultRowsDisplayedInDelivery	Specifies the default number of rows that can be included in the view when it is displayed on a dashboard.	100 for Simple Trellis; 250 for Advanced Trellis, Table, and Pivot Table	Pivot Table, Table, Trellis
DefaultRowsDisplayedInDownload	Specifies the default number of rows that can be included in the view when it is downloaded, such as to a PDF file.	65000 (6500 for Simple Trellis; 10000 for Advanced Trellis)	Pivot Table, Table, Trellis
DefaultRowsDisplayedInDownloadCSV	Specifies the default number of rows that can be included in the view when it is downloaded to a CSV file.	65000	Table
MaxCells	Specifies the maximum number of cells or for a treemap, the maximum number of groups and tiles, to be displayed in a view. For pivot tables, tables, and trellises, this number should not exceed the product of MaxVisibleColumns times MaxVisibleRows, which is what the system attempts to render.	50000 (1000 for Simple Trellis; 5000 for Treemap)	Pivot Table, Table, Trellis, Treemap
MaxPagesToRollOutInDelivery	Specifies the maximum number of pages that can be included in the view when it is displayed on a dashboard.	1000	Pivot Table, Table, Trellis
MaxRecords	Specifies the maximum number of records that can be included in the view.	40000	Narrative, Ticker
MaxVisibleColumns	Specifies the maximum number of columns to be displayed in a view.	2000 (75 for Simple Trellis; 150 for Advanced Trellis)	Graph, Pivot Table, Trellis
MaxVisiblePages	Specifies the maximum number of view prompts (or pages in PDF) to be displayed in a view.	1000 (10000 for Treemap)	Graph, Pivot Table, Table, Trellis, Treemap
MaxVisibleRows	Specifies the maximum number of rows to be displayed in a view. The value of DefaultRowsDisplayed should not exceed this value. For tables and pivot tables, specifies the number of rows that is displayed on the tooltip for the Display Maximum Rows per Page paging control button.	2000 (100 for Simple Trellis; 250 for Advanced Trellis; 10000 for Treemap)	Graph, Pivot Table, Table, Trellis, Treemap
MaxVisibleSections	Specifies the maximum number of sections to be displayed in a view. This element does not apply when a slider is in place for a graph. The SectionSliderDefault and SectionSliderLimit elements apply to limit section values when a slider is in place. See Table 17-*.	25 (10 for Simple Trellis; 50 for Advanced Trellis and Treemap)	Graph, Pivot Table, Table, Trellis, Treemap
JavaHostReadLimitInKB	Specifies the maximum amount of data that is sent to the browser for a single graph.	4096	Graph

Manually Configuring Settings for Fetching Data for Table Views, Pivot Table Views, and Trellis Views

You can use settings within the GridViews element (such as DefaultRowFetchSlicesCount) to specify how data is fetched for table views, pivot table views, and trellis views that use scrolling as the method to browse data.

Content designers specify the method to be used to browse data (either scrolling or paging controls) in a table view, pivot table view, or trellis view in the Table Properties dialog: Style tab, the Pivot Table Properties dialog, or the Trellis Properties dialog: General tab, respectively. See User's Guide for Oracle Business Intelligence Enterprise Edition.

1. Open the instanceconfig.xml file for editing, located in:

   BI_DOMAIN/config/fmwconfig/biconfig/OBIPS

2. Locate the GridViews parent section, in which you must add the elements that are described in the table below.
3. Include the elements and their ancestor elements as appropriate, as shown in the following example:

   <ServerInstance>
     <Views>
       <GridViews>
           <DefaultRowFetchSlicesCount>1000</DefaultRowFetchSlicesCount>
           <DefaultColumnFetchSlicesCount>300</DefaultColumnFetchSlicesCount>
           <DefaultFreezeHeadersClientRowBlockSize>60</DefaultFreezeHeadersClientRowBlockSize>
           <DefaultFreezeHeadersClientColumnBlockSize>15</DefaultFreezeHeadersClientColumnBlockSize>
           <DefaultFreezeHeadersWidth>1000</DefaultFreezeHeadersWidth>
           <DefaultFreezeHeadersHeight>1000</DefaultFreezeHeadersHeight>
       <DefaultScrollingEnabled>false</DefaultScrollingEnabled>
       </GridViews>
     </Views>
   </ServerInstance>
   

4. Save your changes and close the file.
5. Restart Oracle Business Intelligence.

The table below describes the common elements for fetching data.

Element	Description	Default Value
DefaultRowFetchSlicesCount	Specifies the maximum number of rows to be used in calculating the size of the scrolling view when it is initially displayed. When a user scrolls to the last row in the view, a link to fetch more rows (if there are more) is displayed.	1000
DefaultColumnFetchSlicesCount	Specifies the maximum number of columns to be used in calculating the size of the scrolling view when it is initially displayed. When a user scrolls to the last column in the view, a link to fetch more columns (if there are more) is displayed.	300
DefaultFreezeHeadersClientRowBlockSize	Specifies the number of rows to be returned to the client on an AJAX request (that is, when a user scrolls such that a request needs to be made to the server to get more rows into the table view, pivot table view, or trellis view).	60
DefaultFreezeHeadersClientColumnBlockSize	Specifies the number of columns to be returned to the client on an AJAX request (that is, when a user scrolls such that a request needs to be made to the server to get more columns into the table view, pivot table view, or trellis view).	15
DefaultFreezeHeadersWidth	Specifies the default maximum width of table views, pivot table views, and trellis views in pixels. Content designers can override this value using the Maximum Width field in the properties dialog for the view.	700
DefaultFreezeHeadersHeight	Specifies the default maximum height of table views, pivot table views, and trellis views in pixels. Content designers can override this value using the Maximum Height field in the properties dialog for the view.	400
DefaultScrollingEnabled	Specifies the Data View scrolling of table views, as follows: - false (Default on installation), sets reports to show the output with Data View as 'Fixed headers with scrolling content' - true, sets reports to show the Data View as 'Content Paging'.	false

Manually Configuring for Graphs and Gauges

You can configure various options that change the display of graphs, including funnel graphs, and gauges.

These views types are also affected by the settings that are described in Manually Configuring for Data in Views.

1. Open the instanceconfig.xml file for editing, located in:

   BI_DOMAIN/config/fmwconfig/biconfig/OBIPS

2. Search for the Charts sections, in which you must add the elements that are described in the table below.
3. Include the elements and their ancestor elements as appropriate, as shown in the following example:

   <ServerInstance>
     <Views>
       <Charts>
        <EmbedFonts>true</EmbedFonts>
        <SectionSliderDefault>150</SectionSliderDefault>
        <SectionSliderLimit>300</SectionSliderLimit>
        <DefaultWebImageType>flash</DefaultWebImageType>
        <FlashCodeBase>\\CORPORATE\Download\Flash</FlashCodeBase>
        <FlashCLSID>E38CDB6E-BA6D-21CF-96B8-432553540000</FlashCLSID>
       </Charts>
     </Views>
   </ServerInstance>
   

4. Save your changes and close the file.
5. Restart Oracle Business Intelligence.

Element	Description	Default Value
EmbedFonts	See Configuring Fonts for Graphs for details.	false
DefaultWebImageType	Specifies the default type for rendering an image when a format has not been specified in the URL or in the XML file for the view. Valid values are: flash In a browser that does not support the flash format, the image does not render. You should use the html5 value instead. png (W3C Portable Network Graphics) svg (W3C Scalable Vector Graphics) The svg value is not supported in this release, so flash is used if svg is specified. html5 In a browser that does not support the html5 format, the image renders in the flash format instead. Flash, png, and html5 images provide the greatest degree of interaction because they support mouse-over behaviors (such as popup data labels), navigation, and drilling.	flash
SectionSliderDefault	Specifies the default number of values that can be displayed on a section slider bar. A section slider displays members of one or more attribute or hierarchical columns as values on a rectangular bar and provides mechanisms to select a value. For more information about defining section sliders in graphs, gauges, and funnels, see User's Guide for Oracle Business Intelligence Enterprise Edition.	5
SectionSliderLimit	Specifies the maximum number of values that can be displayed on a section slider bar.	10
FlashCodeBase	Specifies the name of the source for downloading the Flash plug-in. The default download source for the Flash plug-in is the vendor's website. In some organizations, users are instructed to download the latest Flash software from a corporate location instead of the vendor's website. You can modify the setting to point to another location that holds the Flash code base. Then, when users view a graph and a newer version of the Flash software is available on the corporate server, they can be prompted to download the newer version.	vendor's web site
FlashCLSID	Specifies a custom global identifier (clsid) property for downloading Flash. After modifying the Flash download directory using the FlashCodeBase element, you can enable a download prompt by creating a new classID for the Flash ActiveX control to add a custom global identifier property. You can obtain the current global identifier property from any computer where Oracle BI Presentation Services graphing is being used. (The global identifier property used by Oracle Business Intelligence is D27CDB6E-AE6D-11CF-96B8-444553540000.) The custom global identifier property must contain the same number of characters and dashes as the global identifier used in the default Flash ActiveX control. Test flash graphs independent of Oracle Business Intelligence to ensure that they function with the custom global identifier property.	No default value

Configuring Fonts for Graphs

There are two ways you can configure fonts for graphs.

• Set the embed fonts element

• Deliver font files for printing

Setting the Embed Fonts Element

By default, graphs rely on users to have the appropriate device fonts installed on their system to display multilingual text in the graphs. When users enable rotation on O1 axis labels, the graphs can look unattractive at certain angles. The labels appear obscured without any anti-aliasing. You can set the EmbedFonts element to true to specify the use of embedded fonts instead of device fonts, which resolves this display issue.

Be aware that the use of embedded fonts can cause a loss of fidelity. Whenever end users select fonts, they see the Oracle-licensed Albany WT plain fonts by default. Because the graphing engine does not provide embedded fonts for Chinese, Japanese, and Korean locales, users with those locales might obtain unattractive results for label rotation.

Delivering Font Files for Printing

If you plan to print graphs in bi-directional languages to PDF or graphs in Chinese, Japanese, or Korean to PNG images, then you must deliver required font files (.TTF) as follows:

• To print graphs in bi-directional languages to PDF, you must deliver the Albany family of fonts to this Java Runtime Environment (JRE) directory:

  JAVA.HOME/lib/fonts

  where JAVA.HOME is the directory name as specified by the "java.home" system property.

• To print graphs in Chinese, Japanese, or Korean to PNG images, you must deliver the font file that contains all the needed glyphs to this JRE directory:

  lib/fonts/fallback

For more information about font configuration files, see your Java documentation.

Configuring Graph and Gauge Rendering

You can use the DefaultWebImageType element to specify the default type for rendering an image when a format has not been specified in the URL or in the XML file for the view.

Valid values are:

• flash

  In browsers that do not support flash format, the graph or gauge will not render. You should use the html5 value instead.

• png (W3C Portable Network Graphics)

• svg (W3C Scalable Vector Graphics)

  The svg value is not supported in this release, so flash is used if svg is specified.

• html5

  In browsers that support only the flash format, the graph or gauge will render in flash format.

Flash and SVG images provide the greatest degree of interaction because they support mouse-over behaviors (such as popup data labels), navigation, and drilling.

Manually Changing Alternating Bar Color

Both tables and pivot tables can have colored bars on alternating lines. Such formatting is sometimes called "green bar styling," and the default color for these alternating bars is green. For pivot tables, content designers can control formatting features when editing tables and pivot tables, including whether alternating bar color is enabled.

As the administrator, you can change the default color for alternating bars, by editing a style configuration file. To change the color, edit the views.css file in the b_mozilla_4 folder, as shown in the following list. Change the six-digit hexadecimal color value to a new color value.

• Tables use the CSS selector:

  .ECell (for even-numbered rows)

  .OCell (for odd-numbered) rows.

• Pivot tables use the CSS selector:

  .PTE (for odd-numbered rows)

The option for enabling the alternating bars is in the Edit View dialog and is labeled Enable alternating row "green bar" styling. If you change the color of the bars, then you might also want to change the label to indicate the color that you have set.

To change the label in the dialog for both the table and pivot table, open the tableviewmessages.xml file and find this entry:

WebMessageName = "kmsgTableViewEnableGreenbarReporting"

Copy the entry and the text line under it to a custom messages file in the custom messages folder, and change the text line appropriately. For example:

WebMessageName = "kmsgTableViewEnableGreenbarReporting"
<TEXT>Enable alternating row "RED bar" styling</TEXT>"

Manually Configuring for Interactions in Views

You can configure various options that change the way that right-click interactions are handled in views for an analysis at runtime.

The elements in the instanceconfig.xml file specify the default settings for a new or upgraded analysis. You can edit the properties of an analysis in Presentation Services to modify how the analysis handles right-click interactions in views.

1. Open the instanceconfig.xml file for editing, located in:
   BI_DOMAIN/config/fmwconfig/biconfig/OBIPS
2. Locate the sections in which you must add the elements that are described in the table below.
3. Include the elements and their ancestor elements as appropriate, as shown in the following example:

   <ServerInstance>
     <Analysis>
       <InteractionProperties>
         <InteractionPropertyAddRemoveValues>false</InteractionPropertyAddRemoveValues>
         <InteractionPropertyCalcItemOperations>false</InteractionPropertyCalcItemOperations>
         <InteractionPropertyDrill>true</InteractionPropertyDrill>
         <InteractionPropertyGroupOperations>false</InteractionPropertyGroupOperations>
         <InteractionPropertyInclExclColumns>true</InteractionPropertyInclExclColumns>
         <InteractionPropertyMoveColumns>true</InteractionPropertyMoveColumns>
         <InteractionPropertyRunningSum>false</InteractionPropertyRunningSum>
         <InteractionPropertyShowHideSubTotal>false</InteractionPropertyShowHideSubTotal>
         <InteractionPropertySortColumns>true</InteractionPropertySortColumns>
         <InteractionPropertyHideColumns>false</InteractionPropertyHideColumns>
       </InteractionProperties>
     </Analysis>
   </ServerInstance>
   

4. Save your changes and close the file.
5. Restart Oracle Business Intelligence.

Element	Description	Default Value
InteractionPropertyAddRemoveValues	Specifies whether the Add/Remove Values option is selected by default in the Analysis Properties dialog: Interactions tab.	false
InteractionPropertyCalcItemOperations	Specifies whether the Create/Edit/Remove Calculated Items option is selected by default in the Analysis Properties dialog: Interactions tab.	false
InteractionPropertyDrill	Specifies whether the Drill (when not a primary interaction) option is selected by default in the Analysis Properties dialog: Interactions tab.	true
InteractionPropertyGroupOperations	Specifies whether the Create/Edit/Remove Groups option is selected by default in the Analysis Properties dialog: Interactions tab.	false
InteractionPropertyInclExclColumns	Specifies whether the Include/Exclude Columns option is selected by default in the Analysis Properties dialog: Interactions tab.	true
InteractionPropertyMoveColumns	Specifies whether the Move Columns option is selected by default in the Analysis Properties dialog: Interactions tab.	true
InteractionPropertyRunningSum	Specifies whether the Display/Hide Running Sum option is selected by default in the Analysis Properties dialog: Interactions tab.	false
InteractionPropertyShowHideSubTotal	Specifies whether the Display/Hide Sub-totals option is selected by default in the Analysis Properties dialog: Interactions tab.	false
InteractionPropertySortColumns	Specifies whether the Sort Columns option is selected by default in the Analysis Properties dialog: Interactions tab.	true