Skip to content

Instantly share code, notes, and snippets.

View buggtb's full-sized avatar
🎯
Urgh..Why can't I set all my statuses in one place?

Tom Barber buggtb

🎯
Urgh..Why can't I set all my statuses in one place?
View GitHub Profile
WITH
SET [~COLUMNS] AS
{[Time].[Time].[1997]}
SET [~ROWS] AS
Order({[Employee].[Management Role].[Management Role].Members}, [Measures].[Avg Salary], BDESC)
SELECT
NON EMPTY CrossJoin([~COLUMNS], {[Measures].[Avg Salary]}) ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [HR]
WITH
SET [~TOP] AS {[Department].[Department].[2], [Department].[Department].[1]}
SET [~BOTTOM] AS {[Department].[Department].[4], [Department].[Department].[5], [Department].[Department].[11], [Department].[Department].[14], [Department].[Department].[15], [Department].[Department].[16], [Department].[Department].[17], [Department].[Department].[18], [Department].[Department].[19]}
SET [~ROWS] AS Union(Union([~TOP], {[Department].[Department].[3]}), [~BOTTOM])
SELECT
NON EMPTY {[Measures].[Org Salary]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [HR]
In pentaho-solutions/system/saiku/ unzip the https://dl.dropboxusercontent.com/u/8503756/components.tar.gz file it should create a components directory
In pentaho-solutions/system/saiku/ui/js/saiku unzip https://dl.dropboxusercontent.com/u/8503756/render.tar.gz and https://dl.dropboxusercontent.com/u/8503756/embed.tar.gz to create a render and embed directory.
Stop the server and delete the contents from tomcat/work and tomcat/temp/
Restart server.
Failed to execute goal org.apache.karaf.tooling:karaf-maven-plugin:4.0.0:assembly (default-assembly) on project mytool-engine: Unable to build assembly: Unable to resolve root: missing requirement [root] osgi.identity; osgi.identity=mytool-features; type=karaf.feature; version=1.0.0.SNAPSHOT; filter:="(&(osgi.identity=mytool-features)(type=karaf.feature)(version>=1.0.0.SNAPSHOT))" [caused by: Unable to resolve mytool-features/1.0.0.SNAPSHOT: missing requirement [mytool-features/1.0.0.SNAPSHOT] osgi.identity; osgi.identity=com.mytool.filemanager-client; type=osgi.bundle; version="[1.0.0.SNAPSHOT,1.0.0.SNAPSHOT]"; resolution:=mandatory [caused by: Unable to resolve com.mytool.filemanager-client/1.0.0.SNAPSHOT: missing requirement [com.mytool.filemanager-client/1.0.0.SNAPSHOT] osgi.wiring.package; filter:="(&(osgi.wiring.package=org.osgi.service.blueprint)(version>=1.0.0)(!(version>=2.0.0)))"]] -> [Help 1]
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<schema metamodelVersion="4.0" name="call">
<Cube name="Cube 1">
<Annotations xsi:type="xs:string" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></Annotations>
<Dimensions>
<Dimension source="Date" visible="true"/>
</Dimensions>
<MeasureGroups>
<MeasureGroup name="Default" table="fact">
<DimensionLinks>
<?xml version="1.0" encoding="UTF-8"?>
<Schema name="Test" metamodelVersion="4.0">
<!--Physical schema defines the tables used in the database, and how they join to each other -->
<PhysicalSchema>
<Table schema="dfs.tmp" name="testview">
<Key>
<Column name="CONTROL" />
</Key>
</Table>
</PhysicalSchema>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<features xmlns="http://karaf.apache.org/xmlns/features/v1.3.0" name="pdi-features">
<feature name="pdi-feature" description="Pentaho Data Integration Feature" version="1.0.0.SNAPSHOT">
<!--
<bundle>wrap:mvn:org.codehaus.woodstox/woodstox-core-asl/4.4.1\$overwrite=merge&amp;Export-Package=com.ctc
.wstx.exc,*&amp;Private-Package=</bundle>-->
<bundle>wrap:mvn:org.apache.poi/poi/3.13</bundle>
<bundle>mvn:commons-codec/commons-codec/1.9</bundle>
<bundle>mvn:com.googlecode.jsendnsca/jsendnsca/2.0.1</bundle>
<bundle>mvn:commons-lang/commons-lang/2.4</bundle>
<Schema name="FoodMart Test" missingLink="ignore" metamodelVersion="4.300">
<PhysicalSchema>
<Table name="sales_fact_1997" alias="sales_fact_1997">
<ColumnDefs>
<CalculatedColumnDef name="calc$9" type="Numeric">
<ExpressionView>
<SQL dialect="mysql">
<![CDATA[extract(YEAR from the_date)]]>
</SQL>
</ExpressionView>
@buggtb
buggtb / gist:7bdface06dd29a053c97
Last active January 26, 2016 20:40 — forked from madis/gist:4650014
Testing CORS OPTIONS request with curl
curl \
--verbose \
--request OPTIONS \
http://81.174.164.218:8181/cxf/rest/core/user \
--header 'Origin: http://localhost:9292' \
--header 'Access-Control-Request-Headers: Origin, Accept, Content-Type' \
--header 'Access-Control-Request-Method: GET'
# http://nils-blum-oeste.net/cors-api-with-oauth2-authentication-using-rails-and-angularjs/#.UQJeLkp4ZyE
2016-02-18 11:12:30 DEBUG juju.state open.go:52 dialing mongo
2016-02-18 11:12:30 DEBUG juju.worker.dependency engine.go:450 "upgradewaiter" manifold worker started
2016-02-18 11:12:30 DEBUG juju.worker.dependency engine.go:464 "logging-config-updater" manifold worker stopped: dependency not available
2016-02-18 11:12:30 DEBUG juju.worker.dependency engine.go:464 "apiworkers" manifold worker stopped: dependency not available
2016-02-18 11:12:30 DEBUG juju.worker.dependency engine.go:464 "reboot" manifold worker stopped: dependency not available
2016-02-18 11:12:30 INFO juju.mongo open.go:125 dialled mongo successfully on address "127.0.0.1:37017"
2016-02-18 11:12:30 DEBUG juju.worker.peergrouper worker.go:432 found new machine "0"
2016-02-18 11:12:30 INFO juju.apiserver apiserver.go:298 [7] API connection from 81.174.164.218:55112, active connections: 2
2016-02-18 11:12:30 DEBUG juju.apiserver utils.go:70 validate model uuid: controller model - f76edc4c-761d-4859-88fd-046e54aa0b84
2016-02-18 11:12:30 DEBUG ju