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:

Entity Relationship Graph
Entity Relationship Graph

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)
Copyright © Kyligence Inc. all right reserved,powered by GitbookLast Modified: 2022-05-20 17:20:50

results matching ""

    No results matching ""