SSB dataset
Kyligence offers a built-in SSB dataset for trial. This chapter will explain the variables in this dataset.
The SSB dataset used in this environment contains 5 tables, with the fact table containing 60,000 rows of data:
P_LINEORDER
This is the fact table. It contains detailed information of sales orders. Each row holds information such as the customer, the supplier, the amount of orders, the date of sales, etc.
P_LINEORDER Field | Description |
---|---|
ORDERKEY | ID Of Order |
CUSTKEY | ID Of Customer |
PARTKEY | ID Of Part |
SUPPKEY | ID Of Supplier |
ORDERDATE | Date Of Order |
ORDERPRIORITY | Priority Of Order |
SHIPPRIORITY | Priority Of Ship |
QUANTITY | The Number Of Purchased Goods |
EXTENDEDPRICE | Extend Price Of Order |
ORDTOTALPRICE | Total Price Of Order |
DISCOUNT | Discount Of Order |
REVENUE | Revenue Of Order |
SUPPLYCOST | Cost of Supplier |
TAX | Tax |
COMMITDATE | Date Of Commit |
SHIPMODE | Mode Of Ship |
V_REVENUE | Virtual Revenue |
CUSTOMER
This is a dimension table. It includes details of customers, such as their name, address, and city.
CUSTOMER Field | Description |
---|---|
CUSTKEY | ID Of Customer |
NAME | Name Of Customer |
ADDRESS | Address Of Customer |
CITY | City Of Customer |
NATION_PREFIX | The Prefix Of Nation |
NATION | Nation Of Customer |
REGION | Region Of Customer |
PHONE | Phone Of Customer |
MKTSEGMENT | Market Segmen |
SUPPLIER
This dimension table contains information about the suppliers, such as their name, address, and city.
SUPPLIER Field | Description |
---|---|
SUPPKEY | ID Of Supplier |
NAME | Name Of Supplier |
ADDRESS | Address Of Supplier |
CITY | City Of Supplier |
NATION_PREFIX | The Prefix Of Nation |
NATION | Nation Of Supplier |
REGION | Region Of Supplier |
PHONE | Phone Of Supplier |
DATE
The dimension table contains information about the dates in these 7 years, such as the beginning date of the year, beginning date of the month, and beginning date of the week.
DATE Field | Descriptipon |
---|---|
DATEKEY | ID Of Date |
DATE | Date |
DAYOFWEEK | The Day Of Week |
MONTH | Month |
YEAR | Year |
YEARMONTHNUM | The Num Of Year And Month |
YEARMONTH | Year And Month |
DAYNUMINWEEK | The Num Of Day In A Week |
DAYNUMINMONTH | The Num Of Day In A Month |
DAYNUMINYEAR | The Num Of Day In A Year |
MONTHINYEAR | The Num Of Month In A Year |
WEEKNUMINYEAR | The Num Of Week In A Year |
SELLINGSEASON | Season Of Selling |
LASTDAYINWEEKFL | Last Day In Fiscal Week |
LASTDAYINMONTHFL | Last Day In Fiscal Month |
HOLIDAYFL | Holiday Fiscal |
WEEKDAYFL | Weekday Fiscal |
PART
The dimension table contains details of parts, such as their category, color, and type.
PART Field | Description |
---|---|
PARTKEY | ID Of Part |
NAME | Name of Part |
MFGR | Manufacturer Of Part |
CATEGORY | Category Of Part |
BRAND | Brand Of Part |
COLOR | Color Of Part |
TYPE | Type Of Part |
SIZE | Size Of Part |
The five tables together constitute the structure of the entire star data model. Below is a relational diagram of them:
Following is the table of calculation formulas used in this tutorial:
Measure | Calculation |
---|---|
TESTMEASURE0 | SUM(P_LINEORDER.LO_REVENUE) |
TESTMEASURE1 | SUM(P_LINEORDER.LO_SUPPLYCOST) |
TESTMEASURE2 | SUM(P_LINEORDER.V_REVENUE) |
TESTMEASURE3 | COUNT(DISTINCT P_LINEORDER.LO_CUSTKEY) |