6 Formatting Views

This chapter provides detailed information about specific formatting options available for each view in Oracle Business Activity Monitoring (Oracle BAM) Active Studio, for example axis properties in chart views, color themes in crosstab and matrix views, and active data display properties in list views. General formatting properties for view titles and background color, font and text alignment in view labels, and value formatting in fields containing numeric and datetime values are also included.

This chapter contains the following topics:

6.1 Introduction to Formatting Views

Formatting changes the way parts of the view look. A report can contain several views of different types. You apply formatting to each view in a report.

Formatting includes tasks such as adding display titles, formatting text and colors, and changing value formats. Several formatting features apply to specific view types only. Because each of the view types has different characteristics and structures, formatting options change depending on the view type.

When you create or edit a view, select the Properties button to display the formatting options.

6.2 Configuring General Formatting Properties

General formatting properties are those properties that are common to all views of a particular type. However there are a few properties described in this section that are general to all view types.

To specify general properties:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the General tab.

    Description of bam_ve_general.gif follows
    Description of the illustration bam_ve_general.gif

    The following general properties are available in all views:

    • View Title displays a title and title bar for this view in the report. Every view in a report can have its own title. The view title bar is also used to display surface prompts, menus, and the additional information button.

    • Display additional info button creates an icon in the view title with additional information that you enter in the field.

    • Allow view to be detached from report creates an icon in the view title that when clicked opens the view in a separate browser window. You can edit the browser window settings by clicking the link.

    Depending on the view you select there might be more options. See the related sections in this chapter for information about general options for each view.

  3. Click Apply or OK.

6.3 Configuring Axis Properties

For chart views (except Pie Chart), you can format the axes or accept the automatic axis formatting. Auto formatting adjusts the axes for active data. Other view types do not contain axes.

To specify axis properties:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the Axis tab.

    Description of bam_ve_axis.gif follows
    Description of the illustration bam_ve_axis.gif

  3. To use the automatic axis formatting, select the Auto Axis checkbox. If you turn off Auto Axis, you must specify numbers for the following settings:

    • Data Axis Min

    • Data Axis Max

    • Major Increment Marks

    • Minor Increment Marks

  4. If your view type is a Combo Chart, you can choose to display a secondary axis by selecting the Display Secondary Axis checkbox and specifying the secondary axis settings.

  5. Click Apply or OK.

6.4 Configuring View Borders, Shading, and Background Color

You can change the background color and borders of the view, the view title bar, column headers and any column in a list view, the report prompt input dialog box, the report prompt selected option, import a background image, and format the Go prompt button.

To change the color of view element:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the Shading tab.

    Description of bam_ve_shading.gif follows
    Description of the illustration bam_ve_shading.gif

  3. Select a target from the Apply To list.

  4. Click the color swatch next to the Color field to change the background color.

    A color palette is displayed.

  5. Select a color from the palette.

    The color and the color hexadecimal number display. You can also specify the color by typing or pasting a hexadecimal number in the Color field.

  6. Click Apply or OK.

To import background images:

  1. Click the Properties button in the View Editor.

  2. Select the Shading tab.

  3. Select a target from the Apply To list.

  4. In the Background section select Image, then click Browse to locate the image file.

    The file must be a GIF, JPG, or PNG file type.

    Description of bam_ve_shading_image.gif follows
    Description of the illustration bam_ve_shading_image.gif

  5. Select whether the image is to be centered, tiled, or stretched over the target location.

  6. Click Apply or OK.

To format borders:

  1. Click the Properties button in the View Editor.

  2. Select the Shading tab.

  3. Select a target from the Apply To list.

  4. Next to a border type, select a line style from the list, such as solid or double.

    Description of bam_ve_shading_border.gif follows
    Description of the illustration bam_ve_shading_border.gif

  5. Click the color swatch next the list you selected.

    A color palette is displayed.

  6. Select a color from the palette.

    Description of bam_ve_shading_border_color.gif follows
    Description of the illustration bam_ve_shading_border_color.gif

    The color is displayed in the swatch.

  7. Enter a number next to the color swatch to indicate the line thickness.

    Description of bam_ve_shading_border_thick.gif follows
    Description of the illustration bam_ve_shading_border_thick.gif

  8. In the Margin group (View target only) you can adjust the amount of white space between the view borders and the data displayed in the view.

    Description of bam_ve_shading_margin.gif follows
    Description of the illustration bam_ve_shading_margin.gif

  9. Click Apply or OK.

6.5 Configuring Text Alignment

The Text & Align tab in the View Editor lets you adjust the alignment of labels in the view including the view title, column headers, and column text.

Description of bam_tanda_tab.gif follows
Description of the illustration bam_tanda_tab.gif

You can configure text wrapping properties and edit column headers. You can configure with of columns in list views.

To format text alignment:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the Text & Align tab.

  3. Select a target from the Apply To list.

  4. Edit the column heading name by entering a name in the Column Heading text field. This name is displayed in the view but does not change the column name in the data object.

  5. Select an option for horizontal text alignment, and where applicable, for vertical text alignment.

  6. Choose from the following properties:

    • None applies no formatting. Text longer than the column is wide is truncated.

    • Wrap text causes data to start on a new line if the column is not wide enough to display all information.

    • Wrap text (break words) breaks long words to wrap them. No hyphen is used.

    • Ellipses truncates data after a set width and displays ellipses as an indicator in list view types only.

    • Width is the set width for the column measured in pixels, inches, or percentage.

      You can change the width of the column by choosing the column name in the Text and Align properties tab, and set the pixel value for width, for example, 150. By default, all of the columns have variable width in the report, so if you configure it to be a fixed width, as mentioned, you can increase or decrease the width. If you configure a fixed width for only one column, space is taken away from the remaining columns, but if you configure a fixed width for all of the columns, a scroll bar appears at the bottom of the view to help the user navigate the width of the view.

    • Height is the set height for the row measured in pixels.

    • Suppress Duplicate Cells lets you hide duplicate values in a particular column. See Section 6.5.1, "Suppressing Duplicate Fields" for more information.

  7. Click Apply or OK.

6.5.1 Suppressing Duplicate Fields

When you create a view with an updating ordered list or action list, you can sort it by one or more columns and then hide the duplicate data in each row so that the list resembles a columnar report.

For example, if you create an updating ordered list on Film Sales data object and then sorted the list by Brand first, then by Description, it would look like this:

Description of bam_suppress_none.gif follows
Description of the illustration bam_suppress_none.gif

In the Text & Align tab of the View Editor, select Brand in Apply To and then enable Suppress Duplicate Cells.

Description of bam_tanda_tab.gif follows
Description of the illustration bam_tanda_tab.gif

When you click apply, the duplicate Brand values are no longer displayed in the list:

Description of bam_suppress_brand.gif follows
Description of the illustration bam_suppress_brand.gif

6.6 Displaying Data Labels

In chart view types, you can choose to display data labels that show values, percentages, or data series names.

To display data labels:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the Data Labels tab.

    Description of bam_ve_label.gif follows
    Description of the illustration bam_ve_label.gif

  3. Select the checkboxes to display data labels.

    You can select any combination of label types to display.

  4. Click Apply or OK.

6.7 Configuring Font Formats

The Fonts tab in the View Editor lets you select and format the fonts used in the view.

To format fonts:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the Font tab.

    Description of bam_ve_font.gif follows
    Description of the illustration bam_ve_font.gif

  3. Select a target from the Apply To list.

  4. Select a font name from the Font list.

  5. Select a font style from the Style list.

  6. Select a font size from the Size list.

  7. Click the color swatch to change the font color.

    A color palette is displayed.

  8. Select a color from the palette.

    The color swatch changes color and the color hexadecimal number is displayed in the Color field. You can also specify the color by typing or pasting a hexadecimal number in this field.

  9. Choose effects to apply to the text by selecting the checkboxes and radio buttons.

  10. Click Apply or OK.

6.8 Configuring Themes

You can select color themes for chart views and the Crosstab and Matrix views, but not Summary Crosstab view.

To choose a theme:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the Themes tab.

    Description of bam_ve_theme.gif follows
    Description of the illustration bam_ve_theme.gif

  3. Select an option to choose a preconfigured color scheme.

    If your chart only includes two colors, the colors are applied in the order listed in the color scheme. If your chart requires more than seven colors, the colors are repeated with patterns applied to represent more values.

  4. Click Apply or OK.

6.8.1 Adding and Changing Themes

You can change the theme colors and add more themes using Oracle BAM Architect.

To add a theme:

  1. Open Oracle BAM Architect and select Data Objects from the list.

  2. Select the Chart Themes or Matrix Themes data object located in the Data Objects/System/Views folder.

  3. Click Contents.

  4. Click Edit Contents.

  5. Click Add.

  6. Enter an Name and unique Number.

  7. Enter a hexadecimal number corresponding to each color choice in each of the color fields. Chart Themes can have up to 16 colors. Matrix Themes let you specify a Border Color, Heading Border Color, and Cell Border Color. In addition you can add up to 10 colors and 10 font colors.

  8. Click Save.

6.9 Configuring Value Formats

Use value formatting to apply currency or decimal formatting to a field containing numeric values, or to apply date formatting to datetime fields. You can specify value formatting when you create or edit a report from the View Editor.

To specify value format:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the Value Format tab.

    Description of bam_ve_valueformat.gif follows
    Description of the illustration bam_ve_valueformat.gif

  3. Select a field from the Apply To list.

  4. Select the category describing the value format, and select from the following options:

    • If you select General, no other formatting selections must be made.

    • If you select Number, specify a negative number format, the number of decimal places to include, and select the Digits Grouping Symbol checkbox to apply the comma as a thousands separator. Select the Round to the nearest checkbox to display numbers in shorter form such a 20K for 20,000.

      If you are formatting a data subtraction calculated field (such as a datetime–datetime field), you can select the To Time Unit checkbox to format the integer result in Days, H:mm:ss. When you use the date subtraction formatting feature, you cannot specify a negative number format or other formatting reserved for numeric values.

    • If you select Percent, specify the number of decimal places to include.

    • If you select Currency, specify a negative number format, the number of decimal places to include, and a currency symbol. Select the Round to the nearest checkbox to display numbers in shorter form such a 20K for 20,000.

    • If you select Timestamp, specify a timestamp format. You can select the Adjust time zone from GMT to checkbox to make time zone adjustments.

    • If you select Time or Date, choose a type of time or date format in the Type list. You can select the Adjust time zone from GMT to checkbox to make time zone adjustments.

    • If you select TimeUnit, choose the unit of time to represent from the Type list.

    • If you select HTML, no other formatting selections must be made. HTML only applies to calculated fields containing HTML to ensure that the HTML is displayed correctly in the view.

  5. Select the Zero checkbox and enter a value to substitute for zero values. This option is only enabled for Number, Currency, and Percent formats.

  6. Select the NULL checkbox and enter a value to substitute for null values.

  7. Click Apply or OK.

6.10 Configuring the Display of Active Data

You can format the look of the active data as it is added to the view. You can specify a color and a time interval to indicate how recently the information arrived.

To format the display of active data:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Click the Active Data tab.

    Description of bam_ve_activedata.gif follows
    Description of the illustration bam_ve_activedata.gif

  3. Click the New Transaction Color color swatch.

    A color palette is displayed.

  4. Select a color.

    The color and the color hexadecimal number display for the transaction color. You can also specify the color by typing or pasting a hexadecimal number in this field.

  5. Enter a number in the New Transaction Highlight Interval field to indicate the length of time to highlight active data.

  6. Click Apply or OK.

For the Updating Ordered List view you can select Show Rank Colors.

In the Action List view you can select Show Rank Colors and Does not support active data.

For Chart views you can select Disable chart movement on transition to improve performance, and you can uncheck Show New Transaction Color to disable the color change that highlights active data.

For Columnar Reports only, you can also select the Use the fade transition effect for Active Data checkbox. If you have large amounts of active data, this setting is not recommended. The New Transaction Highlight Area property lets you select Entire Row or Cell Only to indicate where active data is.

6.11 Setting a View-Level Poll Mode Refresh Interval

High data volume views in a report can be set to poll mode with a view-level refresh interval. In poll mode, Oracle BAM Server opens view sets in static snapshot mode. When the user-specified interval elapses, the server reloads the view set snapshot HTML. Setting individual views in a report to poll mode reduces the load on Oracle BAM Server, particularly the Active Data Cache.

To set a view in a report to poll mode:

  1. In the view you are editing, click the Properties button in the View Editor. (To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.)

  2. Click the Active Data tab.

    Description of bam_ve_activedata2.gif follows
    Description of the illustration bam_ve_activedata2.gif

  3. Select the Poll Mode checkbox to configure the selected view in poll mode.

  4. Enter a number in seconds for the view-level refresh interval.

    The default refresh interval in poll mode is 5 minutes (300 seconds). The minimum value must be 1 minute.

  5. Click Apply or OK.

Note:

You can set an entire report to poll mode instead of setting individual views in the report to poll mode.

The report-level poll mode setting takes precedence over any individual view-level poll mode settings already made in the report. This means setting a report-level poll mode refresh interval overrides all view-level poll mode interval values in the report.

To specify a whole report to launch in poll mode, see Section 3.6.11, "Setting a Report-Level Poll Mode Refresh Interval."

6.12 Configuring Patterns

If your Chart view contains two or more chart values (for example in a Stacked Bar Chart or Combo Chart), you can control the colors and borders used to define each value using the controls on the Patterns tab in the Oracle BAM Active Studio View Editor.

To configure patterns:

  1. Click the Properties button in the View Editor. To open the View Editor, double-click the view you are editing, or click Edit view in the View Tasks/Options list.

  2. Select the Patterns tab.

    Description of bam_ve_pattern.gif follows
    Description of the illustration bam_ve_pattern.gif

  3. Select a data group to apply a pattern to in the Apply To list.

    For example, assume you selected the Samples/Product Sales data object, grouped by the Region column, and charted the sum of Sales and the sum of Num Sold.

    data groupings for patterns example
    Description of the illustration bam_patterns_groups.gif

    In the Apply To list the chart values would be represented as SUM_Sales(/Samples/Product Sales) and SUM_Num_Sold(/Samples/Product Sales).

    apply to list in patterns
    Description of the illustration bam_patterns_applyto.gif

  4. To customize the area color for the selected chart value, select the Custom option under Area, then choose a color by clicking the color block, or enter its hexadecimal value in the field.

    choosing an area color
    Description of the illustration bam_patterns_area_hex.gif

  5. To customize the border color for the selected chart value, select the Custom option under Border, then choose a color by clicking the color block, or enter its hexadecimal value in the field.

    customizing border color
    Description of the illustration bam_patterns_border.gif

  6. Click Apply to save your changes and see them in the view.