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
|