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.

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: