Answer Server 25.3
Answer Server Help

# Generate the Fact Store Data

This section describes how to convert a table of information into Fact Store content, for a SQL database backend type. It uses the example table specified in the Create Coding Files, and also assumes you have set the entity and property codes as described in that section.

    product_name, color, buy_price, sell_price, sold_last_year
    alpha, red, 10, 12, 3500000
    beta, blue, 11, 13, 2000000
    gamma, green, 9, 10, 1000000

## Create a Fact Store Table for a SQL Database

In the SQL database backend, each property and property value for a particular entity is a row in the `Facts` table. For more information about the format of this table, see Set Up a SQL Backend as Fact Store.

The following table shows the table rows for the alpha product, assuming that all these properties refer to the same qualifier combination.

entity_code | property_code | property_value | qualifier_combination
--- | --- | --- | ---
`ALPHA` | `COLOR` | `red` | 0
`ALPHA` | `BUY_PRICE` | `10` | 0
`ALPHA` | `SELL_PRICE` | `12` | 0
`ALPHA` | `SOLD_LAST_YEAR` | `35000000` | 0

For this data, the qualifiers you use in the `qualifiers` table might include a year, or a selling region. For example:

qualifier_combination | qualifier_code | qualifier_value
--- | --- | ---
0 | `YEAR` | `2015`
0 | `REGION` | `Americas`

Copyright 2016-2025 Open Text
Version 25.3 | Last updated July 2025

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery Answer Server 25.3

Topic Title: Generate the Fact Store Data