rmoff

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

rmoff

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

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

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/

rmoff

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  

rmoff

<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

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

This is for a Windows installation with FMW_HOME as c:\oracle\middleware. For a Linux response file see here : https://gist.github.com/rmoff/5772275/

To make use of them you may need to update paths, weblogic password, and DB details.

For more information about upgrading OBIEE to 11.1.1.7 using an in-place upgrade, see http://www.rittmanmead.com/2013/04/upgrading-obiee-to-11-1-1-7/

rmoff

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

[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