This section describes how to connect your data columns to entities in the Lexio global knowledge base. When you map your data columns, Lexio can more intelligently talk about the metrics and dimensions being used in your narratives. The Lexio Global Knowledge Base has information about how measures and dimensions should be expressed, as well as relationships between metrics.

What is Lexio's Ontology?

Lexio's Ontology is a global knowledge base of real-world concepts that allow users to get contextually relevant stories by default. Lexio doesn’t just regurgitate data fields. To help Lexio write intelligently, admins can teach Lexio what each field means by mapping data to Lexio's Ontology. Is it a person, place, or thing? An integer, percentage, or dollar amount? What should Lexio call this? What’s the preferred word choice?

Getting to the Ontology Mapping

Once you successfully load data into Lexio, you can click the button to "Configure Mapping":

When you get to the Ontology Mapping for the first time, you will see the list of data columns and then any 'Knowledge Base Concept' that the column is mapped to.

You will notice that upon loading data, many data columns will already be mapped for you. Lexio makes intelligent 'guesses' about what the logical mappings should be. This guide goes through the steps of making those mappings manually.


In order to map to a knowledge base concept, you can click the '+' button in the 'Knowledge Base Concept' column for the data column you want to map.

When you click the "+" button, you can either search for entities in the Lexio Knowledge Base or create a new one. When you start typing, you will see entities that Lexio knows about that match your search.

When you click on the entity you want to map to (in this example, 'city'), you will see the entity replace the "+" in the knowledge base concept column and you will see any of the metadata that comes with that concept.

Note: For the columns you specified as 'date' during data ingestion, you will see that Lexio has created additional columns for you. These are various time grains Lexio was able to decompose your date into (i.e., month, quarter, year). These decomposed dates can be used as time periods in your Lexio narrative.

If you are performing a mapping and an entity does not exist in the Lexio knowledge base, you can create your own.

In this case, the knowledge base does not have an entity for 'Discount', so you can create your own by clicking 'Create new Instead'

This will bring up a window where you can specify the name of this new entity and specify the singular and plural expressions for that entity.

When you click on the 'Type', it will expose a drop down where you can say what the base 'type' of that entity is. The available types are:

  • Currency
  • Number
  • Percentage
  • Person
  • Place
  • Thing
  • Timeperiod

Currency, Number, Percentage are types that can be used as 'metrics' in your KPI narrative. Person, place and thing can be used as optional 'group by dimensions'.

Click the black button at the bottom to create this new concept