Skip to content

Instantly share code, notes, and snippets.

View weberstephanhd's full-sized avatar

Stephan Weber weberstephanhd

6 followers · 2 following
View GitHub Profile
@weberstephanhd
weberstephanhd / .xsaccess
Last active August 29, 2015 14:00
SAP HANA Cloud Platform - HANA native "Top Customers" - .xsaccess
{
"exposed" : true,
"default_file": "index.html"
}
@weberstephanhd
weberstephanhd / businessPartner.hdbtable
Last active August 29, 2015 14:00
SAP HANA Cloud Platform - HANA native "Top Customers" - data/businessPartner.hdbtable
table.schemaName = "{{SCHEMA_NAME}}";
table.tableType = COLUMNSTORE;
table.description = "EPM Business Partners";
table.columns = [
{name = "PartnerId"; sqlType = NVARCHAR; nullable = false; length = 10; comment = "Partner ID"; },
{name = "PartnerRole"; sqlType = NVARCHAR; nullable = false; length = 3; comment = "Business Partner Role"; },
{name = "EmailAddress"; sqlType = NVARCHAR; nullable = false; length = 255; comment = "E-Mail Address"; },
{name = "PhoneNumber"; sqlType = NVARCHAR; nullable = false; length = 30; comment = "Business Phone Number"; },
{name = "FaxNumber"; sqlType = NVARCHAR; nullable = true; length = 30; comment = "Business Fax Number"; },
{name = "WebAddress"; sqlType = NVARCHAR; nullable = false; length = 1024; comment = "Web Address"; },
@weberstephanhd
weberstephanhd / businessPartner.csv
Created April 23, 2014 19:15
SAP HANA Cloud Platform - HANA native "Top Customers" - data/businessPartner.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 14 columns, instead of 13 in line 6.
0100000000,01,[email protected],0622734567,,http://www.sap.com,1000000034,SAP,AG,0000000033,20121003,0000000033,20121003,EUR
0100000001,02,[email protected],3088530,,http://www.beckerberlin.de,1000000035,Becker Berlin,GmbH,0000000033,20121003,0000000033,20121003,EUR
0100000002,01,[email protected],3023352668,,http://www.delbont.com,1000000036,DelBont Industries,Ltd.,0000000033,20121003,0000000033,20121003,USD
0100000003,01,[email protected],511403266,,http://www.talpa-hannover.de,1000000037,Talpa,GmbH,0000000033,20121003,0000000033,20121003,EUR
0100000004,01,[email protected],2244668800,,http://www.panorama-studios.biz,1000000038,Panorama Studios,Inc.,0000000033,20121003,0000000033,20121003,USD
0100000005,01,[email protected],2511415,,http://www.tecum-ag.de,1000000039,TECUM,AG,0000000033,20121003,0000000033,20121003,EUR
0100000006,01,[email protected],9078563412,,http://www.asia-ht.com,1000000040,Asia High tech,Inc.,0000000033,20121003,0000000033,
@weberstephanhd
weberstephanhd / salesOrder.csv
Last active August 29, 2015 14:00
SAP HANA Cloud Platform - HANA native "Top Customers" - data/salesOrder.csv
0500000000 0000000033 20120101 0000000033 20120115 0100000000 EUR 26581.03 22337 4244.03 X I I
0500000001 0000000033 20120102 0000000033 20120116 0100000001 EUR 9417.66 7914 1503.66 N I I
0500000002 0000000033 20120103 0000000033 20120117 0100000002 EUR 5631.08 4732 899.08 P I D
0500000003 0000000033 20120104 0000000033 20120118 0100000003 EUR 1405.39 1181 224.39 N I I
0500000004 0000000033 20120105 0000000033 20120119 0100000004 EUR 761.24 639.7 121.54 C P D
0500000005 0000000033 20120106 0000000033 20120120 0100000005 EUR 101299.22 85125.4 16173.82 X I I
0500000006 0000000033 20120107 0000000033 20120121 0100000006 EUR 250.73 210.7 40.03 X I I
0500000007 0000000033 20120108 0000000033 20120122 0100000007 EUR 10549.35 8865 1684.35 C P D
0500000008 0000000033 20120109 0000000033 20120123 0100000008 EUR 195.16 164 31.16 X I I
0500000009 0000000033 20120110 0000000033 20120124 0100000009 EUR 3972.22 3338 634.22 P P I
@weberstephanhd
weberstephanhd / salesOrder.hdbtable
Created April 24, 2014 13:57
SAP HANA Cloud Platform - HANA native "Top Customers" - data/salesOrder.hdbtable
table.schemaName = "{{SCHEMA_NAME}}";
table.tableType = COLUMNSTORE;
table.description = "EPM Sales Order Header";
table.columns = [
{name = "SalesOrderId"; sqlType = NVARCHAR; nullable = false; length = 10; comment = "Sales Order ID"; },
{name = "CreatedBy"; sqlType = NVARCHAR; nullable = false; length = 10; comment = "Created By"; },
{name = "CreatedAt"; sqlType = DATE; nullable = false; comment = "Created At - Date and Time"; },
{name = "ChangedBy"; sqlType = NVARCHAR; nullable = true; length = 10; comment = "Last Changed By"; },
{name = "ChangedAt"; sqlType = DATE; nullable = true; comment = "Last Changed At - Date and Time"; },
{name = "NoteId"; sqlType = NVARCHAR; nullable = true; length = 10; comment = "SO Note Text ID"; },
@weberstephanhd
weberstephanhd / salesOrdersAndBusinessPartners.hdbti
Created April 24, 2014 14:18
SAP HANA Cloud Platform - HANA native "Top Customers" - data/salesOrdersAndBusinessPartners.hdbti
import = [
{
table = "{{PACKAGE_NAME}}.data::businessPartner";
schema = "{{SCHEMA_NAME}}";
file = "{{PACKAGE_NAME}}.data:businessPartner.csv";
header = false;
},
{
table = "{{PACKAGE_NAME}}.data::salesOrder";
@weberstephanhd
weberstephanhd / salesOrderService.xsjs
Last active August 29, 2015 14:00
SAP HANA Cloud Platform - HANA native "Top Customers" - services/salesOrderService.xsjs
var select_all_sales_orders_query =
"SELECT TOP 10 \"CompanyName\", \"NetAmount\", \"GrossAmount\" " +
"FROM \"{{SCHEMA_NAME}}\".\"{{PACKAGE_NAME}}/SO_CV\" " +
"ORDER BY \"GrossAmount\" DESC";
function close(closables) {
var closable;
var i;
for (i = 0; i < closables.length; i++) {
closable = closables[i];
if(closable) {
@weberstephanhd
weberstephanhd / Companies.view.js
Created May 5, 2014 07:32
SAP HANA Cloud Platform - HANA native "Top Customers" - views/Companies.view.js
sap.ui.jsview("views.Companies", {
/** Specifies the Controller belonging to this View.
* In the case that it is not implemented, or that "null" is returned, this View does not have a Controller.
* @memberOf views.Companies
*/
getControllerName : function() {
return null;
},
/** Is initially called once after the Controller has been instantiated. It is the place where the UI is constructed.
* Since the Controller is given to this method, its event handlers can be attached right away.
@weberstephanhd
weberstephanhd / index.html
Created May 5, 2014 07:44
SAP HANA Cloud Platform - HANA native "Top Customers" - index.html
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<script src="/sap/ui5/1/resources/sap-ui-core.js" id="sap-ui-bootstrap" data-sap-ui-libs="sap.ui.ux3,sap.ui.commons,sap.ui.table,sap.viz" data-sap-ui-theme="sap_goldreflection" >
</script>
<script>
sap.ui.localResources("views");
var view = sap.ui.view({id:"companies", viewName:"views.Companies", type:sap.ui.core.mvc.ViewType.JS});
view.placeAt("content");
</script>
@weberstephanhd
weberstephanhd / model_access.hdbrole
Created May 5, 2014 08:51
SAP HANA Cloud Platform - HANA native "Top Customers" - roles/ model_access.hdbrole
role {{PACKAGE_NAME}}.roles::model_access {
sql object {{PACKAGE_NAME}}:SO_CV.calculationview : SELECT;
}