Open topic with navigation

# 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-2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm