Skip to content

Instantly share code, notes, and snippets.

Avatar

Robin Moffatt rmoff

View GitHub Profile
@rmoff
rmoff / Getting Graphiti working on Ubuntu 12.10.md
Last active Dec 14, 2015
Describes how to get Graphiti running on Ubuntu. Assumes that Graphite is already installed and available.
View Getting Graphiti working on Ubuntu 12.10.md

Getting Graphiti working on Ubuntu 12.10

https://github.com/paperlesspost/graphiti

Caveat

I know nothing about Ruby etc, so the below was done with sheer ignorance, brute force and Google.

Pre-requisites not covered here

View Creating gists from the commandline.md

Gists are a feature of git, and a nice way to share snippets of code or short documents. They benefit from being private or public, and can be cloned etc like standard git repositories.

To post a git from the command line there is a tool available called gist, installed with brew:

brew install gist

Then set your git username + password:

git config --global github.user "jbloggs"
git config --global github.password "welcome1"
@rmoff
rmoff / README.md
Last active Apr 19, 2017
A very simple OBIEE 11g JMeter script.
View README.md

Save the JMX file to your local machine and open it in JMeter. Tested with OBIEE 11.1.1.7.1. Other versions may require modifications to the Assertion tests.

NB you need to change instanceconfig.xml so that the Loading... text doesn't disrupt the test. See here for more details, and additional information on using JMeter with OBIEE.

@rmoff
rmoff / JMeter-JDBC-OBIEE.md
Last active Dec 14, 2015
An example of using JMeter to send Logical SQL to OBIEE via JDBC
View JMeter-JDBC-OBIEE.md

To use, download the jmeter_jdbc_obi_simple.jmx file from this gist, and open it in JMeter.

For it to work, you must make the OBIEE JDBC driver availabel to JMeter, which can be done in two ways. Put jdk16/bijdbc.jar in the JMeter classpath, or specify it directly using Add directory or jar to classpath option in the top level Test Plan step.

You will find jdk16/bijdbc.jar in $FMW_HOME/Oracle_BI1/bifoundation/jdbc/

View start-all-sampleapp.sh
cd ~/Desktop
./0-StartDB.sh &
sleep 30
./1-StartOID.sh &
sleep 30
./2-StartWLS.sh &
sleep 300
./3-StartBI.sh &
sleep 30
#./4-StartEssbase.sh
View trellis_pivot_firstlast.xml
<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">
<saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;A - Sample Sales&quot;">
<saw:columns>
<saw:column xsi:type="saw:regularColumn" columnID="cf43f9bc2886b224b">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Time"."T03 Per Name Qtr"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cf87e6e5395c89ec3">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Orders"."R2 Order Type"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="ce5f7785783d54d4a">
@rmoff
rmoff / .screenrc
Last active Dec 15, 2015
.screenrc
View .screenrc
hardstatus alwayslastline "%{= RY}%H %{kG}%{G} Screen(s): %{c}%w %=%{kG}%c %D, %M %d %Y LD:%l"
startup_message off
msgwait 1
defscrollback 100000
nethack on
@rmoff
rmoff / 0_README.md
Last active Dec 15, 2015
OBIEE 11.1.1.7 in-place upgrade - response files for Windows
View 0_README.md
@rmoff
rmoff / rcu.sh
Last active Dec 15, 2015
RCU silent install
View rcu.sh
cat > /tmp/pw.txt <<EOF
password
password
password
EOF
./rcuHome/bin/rcu -silent -createRepository -connectString localhost:1521:orcl -dbUser SYS -dbRole SYSDBA -schemaPrefix DEV -component BIPLATFORM -component MDS < /tmp/pw.txt
@rmoff
rmoff / obi11g_11116.unix.rsp
Last active Dec 15, 2015
OBIEE 11.1.1.6 silent install response file
View obi11g_11116.unix.rsp
[ENGINE]
#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0
[GENERIC]
#Set this to true if you wish to specify a directory where latest updates are downloaded. This option would use the software updates from the specified directory
SPECIFY_DOWNLOAD_LOCATION=false
You can’t perform that action at this time.