CUSTOMER_ATTR_###.hdbtable

table.schemaName = "GBI_###"; 
table.tableType = COLUMNSTORE; 
table.columns = [ 
    {name = "CUSTOMER_NUMBER"; sqlType = NVARCHAR; length = 10; }, 
    {name = "CUSTOMER_NAME"; sqlType = NVARCHAR; length = 20; }, 
    {name = "CITY"; sqlType = NVARCHAR; length = 35; }, 
    {name = "VALID_TO"; sqlType = DATE; }, 
    {name = "VALID_FROM"; sqlType = DATE; }, 
    {name = "SALES_ORGANIZATION"; sqlType = NVARCHAR; length = 4; },
    {name = "COUNTRY"; sqlType = NVARCHAR; length = 2; } 
    ]; 
    table.primaryKey.pkcolumns = ["CUSTOMER_NUMBER", "VALID_TO"];

PRODUCT_ATTR_###.hdbtable

table.schemaName = "GBI_###"; 
table.tableType = COLUMNSTORE; 
table.columns = [ 
    {name = "PRODUCT"; sqlType = NVARCHAR; length = 8; }, 
    {name = "PRODUCTNAME"; sqlType = NVARCHAR; length = 40; }, 
    {name = "PRODUCT_CATEGORY"; sqlType = NVARCHAR; length = 3; }, 
    {name = "DIVISION"; sqlType = NVARCHAR; length = 3; }, 
    {name = "INTERNAL_PRICE"; sqlType = DECIMAL; precision=17; scale=2; }, 
    {name = "PRICE";  sqlType = DECIMAL; precision=17; scale=2; },
    {name = "COLOR"; sqlType = NVARCHAR; length = 10; }, 
    {name = "PRODUCT_GROUP"; sqlType = NVARCHAR; length = 20; } 
    ]; 
    table.primaryKey.pkcolumns = ["PRODUCT"];

SALES_###.hdbtable

table.schemaName = "GBI_###"; 
table.tableType = COLUMNSTORE; 
table.columns = [ 
    {name = "YEAR"; sqlType = INTEGER;}, 
    {name = "MONTH"; sqlType = INTEGER;}, 
    {name = "DAY"; sqlType = INTEGER;}, 
    {name = "CUSTOMER_NUMBER"; sqlType = NVARCHAR; length = 10; },
    {name = "ORDER_NUMBER"; sqlType = NVARCHAR; length = 10; }, 
    {name = "ORDER_ITEM"; sqlType = NVARCHAR; length = 3; }, 
    {name = "PRODUCT"; sqlType = NVARCHAR; length = 8; },
    {name = "SALES_QUANTITY"; sqlType = INTEGER;},
    {name = "UNIT_OF_MEASURE"; sqlType = NVARCHAR; length = 3; }, 
    {name = "REVENUE"; sqlType = DECIMAL; precision=17; scale=2; }, 
    {name = "CURRENCY"; sqlType = NVARCHAR; length = 3; }, 
    {name = "DISCOUNT"; sqlType = DECIMAL; precision=17; scale=2; }
    ]; 
    table.primaryKey.pkcolumns = ["ORDER_NUMBER", "ORDER_ITEM"];

Provisioning of Sales Data

Currently there is an issue uploading the sales data to SALES_###.hdbtable. Use the following work-around:

1. Open 2017-04-09__19_27_11_--A-SAP_SALES_SALESDATA_FOR_LUMIRA.txt (the file is available for download in Moodle) with an text-editor, e.g. notepad++ on Windows.

2. Replace all occurences of "GBI_000"."gbi-student-000::SALES_000" with the equivalent string "GBI_###"."gbi-student-###::SALES_###" (replace ### with your user id).

3. In SAP HANA open the Catalog and navigate to your Sales Table. Then open the SQL editor (press the little blue SQL icon in the icon ribbon), copy the whole content of the file and paste it to the editor. Press F8 to execute. Be patient as the number of inserts (48384) will consume several minutes (10-15) and the page will block. Do not get nervous and always press Waitif asked by the browser. Getting a coffee might be a good idea. Do not leave the browser page, as this will stop the process.

After finish you will see a message like

....
10:35:05 AM (Content Persistence) Could not restore tab since editor was not restorable.
10:35:05 AM (Content Persistence) Could not restore tab since editor was not restorable.
10:35:17 AM (Data Preview) Result limited to 1000 row(s) due to value configured in the Catalog settings