Skip to content

Instantly share code, notes, and snippets.

View weberstephanhd's full-sized avatar

Stephan Weber weberstephanhd

6 followers · 1 following
View GitHub Profile
@weberstephanhd
weberstephanhd / deployments__cf-warden.yml
Created April 22, 2015 15:25
cf-boshworkspace-warden
---
name: cf-warden
director_uuid: YOUR_DIRECTOR_UUID
releases:
- name: cf
version: 207
git: https://github.com/cloudfoundry/cf-release.git
stemcells:
@weberstephanhd
weberstephanhd / deployments__cf-warden.yml
Created April 22, 2015 07:34
cf-boshworkspace
<%
require_relative "./lib/helper"
# the cloudfoundry release version e.g. 195
cf_release_version = ENV["JB_CF_RELEASE_VERSION"] || "207"
# the stemcell version NOTE: latest does not work
warden_stemcell_version = ENV["JB_WARDEN_STEMCELL_VERSION"] || "389"
# the director uuid of your bosh system
director_uuid = ENV["JB_DIRECTOR_UUID"] || "current"
@weberstephanhd
weberstephanhd / bosh vms
Created March 16, 2015 18:09
cf riak cs release v8 acceptance test failures
$ bosh vms
Deployment `cf-warden'
Director task 8
Task 8 done
+------------------------------------+---------+---------------+--------------+
| Job/index | State | Resource Pool | IPs |
+------------------------------------+---------+---------------+--------------+
@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;
}
@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 / 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 / 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 / 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 / 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 / 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