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

_HP_HTML5_bannerTitle.htm