Answer Server 12.12

# 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 2015-2022 Micro Focus or one of its affiliates
Version 12.12 | Last updated June 2022

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 swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Answer Server 12.12

Topic Title: Generate the Fact Store Data