Just a quick note on OBIEE 12c’s Visual Analyzer. It is installed by default, but there is no Single Sign On enabled between OBIEE and Visual Analyzer.  Each user will be prompted to login. Appears access to Visual Analyzer (VA) is controlled by the Application Roles etc. It does not look easy to restrict a…

select total.tablespace_name tsname, –count(free.bytes) nfrags, nvl(max(free.bytes)/1024/1024,0) “Total(gb)”, total.bytes/1024/1024/1024 “Used(gb)”, –nvl(sum(free.bytes)/1024,0) avasiz, nvl(max(free.bytes)/1024/1024,0)-total.bytes/1024/1024/1024 “Freespace(gb)”, (1-nvl(sum(free.bytes),0)/total.bytes)*100 “% used” from dba_data_files total, dba_free_space free where total.tablespace_name = free.tablespace_name(+) and total.file_id=free.file_id(+) group by total.tablespace_name,total.bytes   “Total Disk Used”  select sum(space_used_delta) / 1024 / 1024 “Space used (M)”, sum(c.bytes) / 1024 / 1024 “Total Schema Size (M)”, round(sum(space_used_delta) / sum(c.bytes) *…

This post details how you can configure Oracle SQL Developer to connect and manage MySQL and MS SQL Server databases. Please refer to this document http://www.oracle.com/technetwork/developer-tools/sql-developer/thirdparty-095608.html From here you can download the various drivers.

This is the main script that you can use to call individual load test  scripts, examples below. #!/bin/bash usage() { echo “Usage : Please supply TestDuration in secs,NoOfThreads,LogWriteFrequency in secs,RampUp in secs” exit 1 } #Set Local Parameters TestDuration=”$1″ NoOfThreads=”$2″ LogWriteFreq=”$3″ RampUp=”$4″ ScriptLocation=”/home/oraobi/TestScripts/runtime/nqcmd*.sh” #Call Usage if Parameters not passed [[ $# -eq 0 ]] &&…

Some Oracle Data Pump examples… Data Pump Export ( list of tables, over a db link ) expdp system/manager parallel=1 logfile=exp_ntcv2_ams.log dumpfile=ntcv2ams_%u.dmp estimate=statistics network_link=ntcv2 directory=dp_ntut tables=’AMS.AMS_LIST_ENTRIES,\ AMS.AMS_OBJECT_ASSOCIATIONS,\’ The script below calls Data Pump to export a schema, containing the SALES and COSTS tables, but only where PROD_ID = 13. An example of passing a query…

ODI Runtime Audit SQL This sql works on an odi 11g environment. Useful for running sql against the audit tables to look at runtime, errors , rows effected when an odi interface has run. Run this SQL within the ODI Work Repository Schema. select * from     snp_session ss,     snp_sess_step,     snp_step_log Where 1=1…

Multi Value Presentation Variables You may often find that if you have a prompt that allows users to select multiple string  values then sets a presentation variable. If later you need to use this as a filter as an IN list for another analysis, you need to ensure the BI server places single quotes around…

Worked example below documenting a simple RPD development change.  This shows how you can make a simple change, then deploy that change into an XML file. This XML file can then be used to apply the change to the UAT/PREPROD and PROD RPDs during the release process. Take an offline copy of the RPD to…

When configuring the OBIEE Admin tool, so you can open the RPD on-line with OBIEE 12c, the steps are the same as OBIEE 11g, however the port number you need to configure your ODBC driver is different. See screenshots below of how to configure the ODBC BI Server driver, importantly the port number needs to…

Often you might have a requirement to ensure  an ODI Linux server, is able to connect to a Windows 2012 R2 FTPs server running SSL certificates. This document details the configuration steps that would be required to connect a Linux machine to a Windows FTPs server.   This Proof of Concept has been carried out within an…