Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Create Custom Fields for the Reporting Model

Create Custom Fields for the Reporting Model

Custom fields provide a path to report on and drill to additional attributes directly in OfficeConnect.
The data type for a custom field gets defined when you create the initial field mapping. They become a part of the reporting model business object and you can map to them uniquely for future data sources.
You can configure the reporting model to include custom fields:
  • For Show Details to enable drilling to them in OfficeConnect.
  • As dimensions to enable reporting on them in OfficeConnect. You can configure only instance type custom fields as dimensions. To configure text fields as dimensions, you must first convert them using the Analytic Dimension business object. See Steps: Create Instance Fields for Prism Data Sources.
  1. In the
    Create Field Mapping for Reporting Model
     task, select
    Custom Fields
    .
  2. Click
    Add Row
     (plus icon) to add a row to the table.
  3. In
    Mapping Type
    , select
    Source Field
    .
  4. In
    Source
    , select a field from the Prism data source that doesn’t currently map to a target field in the reporting model.
  5. In
    Target
    , select the prompt and click
    Create Custom Field
    .
  6. Enter a field name and optionally a description. Click
    OK
    . Make a note of this name as you’ll need to configure this field in the reporting model.
  7. Click
    OK
     to save your changes.