weberstephanhd’s gists

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 / 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 / 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 / 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 / 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 / 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 / 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 / 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 / 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 / salesOrder.csv

Last active August 29, 2015 14:00

SAP HANA Cloud Platform - HANA native "Top Customers" - data/salesOrder.csv

Stephan Weber weberstephanhd