Skip to content

Display Standards

These guidelines were implemented for the aPriori Ad Hoc Data domain. As a best practice, apply these or similar guidelines when creating or updating a Domain:

  • For labels:

    • Provide descriptive names for each field.
    • Use upper case for the initial letter.
    • Use spaces instead of underscores.
    • Map names to their aPriori application labels where possible.
    • Include an indication of the data type and units as applicable, for example, length (mm),or area (mm2).

  • Include a description for tool tips which appear when users hover over a name.

  • Include a set for each dimension table. These sets do not need to have subsets since they have a small number of fields in each of them.
  • Include a set and one level of subsets for each fact table. For the scenario facts table the aPriori Ad Hoc Data Domain group fields into the categories that are shown in the “all data table view.”
  • Determine a sensical order for the sets and the fields or measures in each set. (Alphabetical is the default order.
  • Configure all ID items as fields, not as measures. You can hide ID items, but they may be used for counts. As a best practice, set the summary function for ID items to "Distinct Count".
  • Timestamp items – For example costed_timestamp in scenario facts, which uses the JasperReports DateTime format.
  • Date items – Some date attributes (in costed_date and export_date) are included as dimensions (for example, name of month). Others are defined as measures (for example, day in year). For full_date, specify the defaultMask as defaultMask=”medium,hide”.
  • For Currency fields, specify the defaultMask as defaultMask=”#,##0.00”. The defaultMask for doubles is defined as defaultMask=”#,##0.00”.

For display-related information for the aPriori Ad Hoc Data Domain, see the aP Analytics Schema Model Spreadsheet.