Skip to content

Instantly share code, notes, and snippets.

Avatar

Robin Moffatt rmoff

View GitHub Profile
@rmoff
rmoff / fs_example.py
Last active Aug 29, 2015
FluidSurvey API example
View fs_example.py
#!/usr/bin/python
#
# Example of calling the FluidSurveys API from python
#
# March 10, 2014
#
# @rmoff
# --------------------------
#
# To explore the API, use this syntax with curl:
View obiee_phantomcss.js
// @rmoff
// May 21, 2014
//
// Visual Regression Testing for OBIEE using PhantomCSS/CasperJS
//
// No kind of error or exception handling, no checks for successful login, etc
// Use at your own risk!
//-----------------------------------------------------------------------------
var phantomcss = require('./phantomcss.js');
@rmoff
rmoff / gotcha.md
Last active Aug 29, 2015
OBIEE runcat.cmd - $USER_INSTALL_DIR$
View gotcha.md

On an Admin tools only (no OBIEE server), version 11.1.1.7.1, runcat.cmd has two invalid lines:

set ORACLE_HOME=$USER_INSTALL_DIR$\oraclebi\orahome
set JAVA_HOME=$JAVA_HOME$

This means that the script fails to run (because $USER_INSTALL_DIR$ is invalid).

I suspect this is because $USER_INSTALL_DIR$ and $JAVA_HOME$ are tokens that the installer should be replacing when it builds runcat.cmd, but due to a bug doesn't

To get runcat.cmd to work, strip out the $var$ and replace it with the correct path, eg:

@rmoff
rmoff / custom-login-failure.md
Created Jun 24, 2014
Redirect OBIEE login page on failure
View custom-login-failure.md
  1. Open Oracle_BI1/bifoundation/web/msgdb/pages/common/signin.html in a text editor

  2. Find the line <sawm:if name="logonError"> (c. line 36)

  3. Insert a line after it and add the following

     <script language="javascript">setTimeout(function(){window.location.replace("http://rittmanmead.com")},1000)</script>
    
  4. Save the file

  5. Restart Presentation Services

@rmoff
rmoff / obiee-webservices-v8.md
Last active Aug 29, 2015
Changes in OBIEE v8 WSDL
View obiee-webservices-v8.md

Taken from v.11.1.1.7.140114

    http://biee-server:9704/analytics-ws/saw.dll/wsdl/v8

Some are covered in the documentation, some aren't.

Services:

    MultiTenancyManagementServiceSoap
@rmoff
rmoff / gist:3890bf310f1a55bc356c
Created Oct 20, 2014
OBIEE AGGREGATE AT - LEVEL SYNTAX
View gist:3890bf310f1a55bc356c
http://docs.oracle.com/cd/E21043_01/bi.1111/e10544/appasql.htm#CHDJJFEA
Aggreate(x at y) — what syntax is ‘y’ in, cos I’m getting Unresolved Level regardless of what I try
Answer:
Gianni: 'y' must be in the format of "presentation table"."hierarchy name"."hierarchy level"
View tweet.json
{
"interactionId" : "1e43eae605e9a380e074de1a617806dc",
"subscriptionId" : "f6cf211e03dca5da384786676c31fd3e",
"hash" : "65bd9dc4943ec426b04819e6291ef1ce",
"hashType" : "stream",
"interaction" : {
"interaction" : {
"author" : {
"avatar" : "http://pbs.twimg.com/profile_images/453880711519289344/PH0ZcxmW_normal.png",
"id" : 27462864,
@rmoff
rmoff / obips_logging.md
Last active Aug 29, 2015
Custom debug logging in Presentation Services
View obips_logging.md
@rmoff
rmoff / logstash-1.5-node.md
Created Jan 27, 2015
Logstash 1.5: The error reported is: pattern ... not defined
View logstash-1.5-node.md

Running an existing conf file from logstash 1.4.2 with logstash-1.5.0.beta1 fails with :

The error reported is:
  pattern %{WLSLOG} not defined

This seems to be because the grok plugin no longer defaults patterns_dir to ./patterns

Fix is to change all uses of grok in conf file to include patterns_dir:

grok {
@rmoff
rmoff / 01 symptom.sh
Created Mar 18, 2015
Proxmox - cannot enter container, cannot stop it
View 01 symptom.sh
root@proxmox03:~# vzctl enter 122
enter into CT 122 failed
root@proxmox03:~# vzctl stop 122
Stopping container ...
Child 91041 exited with status 7
Killing container ...
Child 91092 exited with status 7
Unable to stop container
You can’t perform that action at this time.