BI Publisher Properties

  • Right-click on field and select BI Publisher / Properties to apply data type and formatting for numbers and dates, and for applying data aggregation functions.

    Figure B-14 BI Publisher Properties Dialog Box

    This figure shows the BI Publisher Properties dialog box.

  • The default date format used is dd-mmm-yy (for example 2-Jun-18).

  • The Advanced tab in the Properties dialog box can be used to apply more advanced functions to data field location, formatting, and aggregation.

    Figure B-15 BI Publisher Advanced Properties Dialog Box

    This shows the BI Publisher Advanced Properties dialog box.

  • When specifying the location of a data field, if the field name is not unique or the field is a column within a table, it may be necessary to specify the full path or a partial path. Notation can also be used to specify a relative path. Fields that have language translations may be contained within a localeData element.

    Examples of specifying the varying levels of path for a description field are as follows:

    Full Path:

    <?//dto/specificationSectionDetail/specificationSectionFoodMainDetailsSection/brand/localeData/description?>

    Partial Path:

    <?specificationSectionFoodMainDetailsSection/brand/localeData/description?>

    Locate Data Element:

    <?brand/localeData/description?>
<?../brand/localeData/description?>
<?./brand/localeData/description?>

    Data Element Only:

    <?description?>

    The meaning of the dot and slash notation is as follows (see the Oracle Business Intelligence Publisher Report Designer's Guide for full details):

    / Absolute (separates child elements)

    // Root (all elements)

    . Current node

    .. Parent node