BI Journey

OBIEE: Enable/Disable Cache  Login to EM using below link http://localhost :7001/em Log in as an administrative user. Typically you use the administrative user name and password provided during the Oracle BI installation.  In the left navigation pane of em home screen, expand Business Intelligence and click coreapplication  Click the Capacity Management tab and then  Click the Performance sub tab   Locate the Enable BI Server Cache section.  Click Lock and Edit Configuration. Deselect/Select  Cache enabled to disable or enable cache. also set the maximum cache entry size and maximum cache entries. Click Apply and  Click Activate Changes . click Restart to apply recent changes. Hope it helps

Variables in OBIEE Part 3 Presentation Variable : Presentation variable is the variable available in presentation service. Presentation variable can be initialized from prompts. Presentation can be initialized from Prompt by either creating Presentation prompt or can set variable from column prompt set varaiable option Presentation variable can call in report using below syntax  ('@{Variable_name}{variable value}') Below is the syntax to pass multi-select characters to column filter @{varaiable_name} ['@'] {'varaiable value'}

Variables in OBIEE Part 2 Session Variable: Session variable is similar to the dynamic repository variable in that they obtain values from initialization block. The difference is session variable scope is limited to the user session.  Session initialization block will run every time if a new user logged in There are two types of session variables available System Session variable Non system session variable System session variable : System variables are OBIEE reserved variable. Example for system session variable is USER.  USER variable holds username always. Non System Session Variable:   Non system session variable can be initialized using initialization block. Like system session variable the scope of non system session variable is limited to session.  Non system variables are commonly used for security implementation. For eg:  if we want the region of a user, we can create initialization block to get regi...

Variables in OBIEE Part 1 Below are the major types of variables available in OBIEE  1)       Repository variable   2)       Session Variable  3)       Presentation variable Repository variable       A repository variable has a single value at any point in time. Repository variable can be classified into two: a)       Static b)       Dynamic Static Repository variable: Will contain static value always unless administrator tries to change it. Eg:  below is static variable created for Current_date. I have specified the value  2013-11-16 as the current date .The variable will hold this value always and this can be changed only by the administrator. RPD deployment is required after the change. Dynamic Repository variable:      Dynamic Repository variab...

OBIEE: Important File Paths File Paths in OBIEE 11g   Repository Path      :- OBIEE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository  Webcatlog Path       :- OBIEE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog  NQS Config File      :- OBIEE_INSTANCE/config/OracleBIServerComponent/coreapplication_obis1  Instance Config      :- OBIEE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1 Application Role xml file :- user_projects/domains/bifoundation_domain/config/fmwconfig system-jazn-data.xml I mportant Logs Paths in OBIEE 11g Weblogic Log         :- user_projects/domains/bifoundation_domain/servers/AdminServer/logs/AdminServer.log Managed Server Log   :- user_projects/domains/bifoundation_domain/servers/bi_server1/logs//bi_server1.log Node Manager...

OBIEE:Enable Evaluate function Hi all, To enable evaluate function in obiee 11g we have to change the EVALUATE_SUPPORT_LEVEL parameter in NQSConfig file.  NQS config file located in OBIEE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn. we can change EVALUATE_SUPPORT_LEVEL to 1,2 and any number. The details of each are available in NQSConfig itself.  EVALUATE_SUPPORT_LEVEL:      1: evaluate is supported for users with manageRepositories permission      2: evaluate is supported for any user.       other: evaluate is not supported if the value is anything else.  Change EVALUATE_SUPPORT_LEVEL to 2 if you want the users to use evaluate function in their report. Restart the server after the change to make it effective. And do mention aggregation rule in edit column formula if you are using evaluate in any report to avoid e...

OBIEE Scripts :  A Script to check the Errors reported in nqsquery log and nqserver log. I have created small scripts to identify the errors noted in nqslog. The script will check the errors reported in current day and send it as mail #!/bin/sh fPath='file path for nqslog and nqsserver' hfile="Outputfile" hfile2="Outputfile" lPath='output file path' touch -t `date +%y%m%d0000` $lPath/$$ find "$fPath" -type f -newer $lPath/$$ | grep "nqquery">Nqquery.out find "$fPath" -type f -newer $lPath/$$ | grep "nqserver">Nqserver.out rm $lPath/$$ #find "$fPath" `pwd` -mtime -1 -type f -print | grep "nqquery">Nqquery.out #find "$fPath" `pwd` -mtime -1 -type f -print | grep "nqserver">Nqserver.out echo ""> Nqquery.txt while read f;do echo "Processing $f" fname=`basename $f` echo "---$Path/$fname---" echo "----...

OBIEE Scripts: Script to backup catalog Below is the script to backup the OBIEE catalog #!/bin/bash # # Backup OBIEE Catalog # # set variables now=`date '+%Y%m%d%H%M%S'` dirbkp= backup path dircat= catalog path catalog=catalog name # change to catalog directory. otherwise the names are too long for tar. cd ${dircat} # tar the directory into backup directory tar -cvf ${dirbkp}/${catalog}_${now}.tar ${catalog}/ if [[ $? == 0 ]]; then   echo "${now} INFO : Archival of ${catalog} successful\n" else   echo "${now} ERROR: Archival of ${catalog} failed\n"   exit 1 fi # compress the tar file gzip ${dirbkp}/${catalog}_${now}.tar if [[ $? == 0 ]]; then   echo "${now} INFO : Gzip of ${catalog} successful" else   echo "${now} ERROR: Gzip of ${catalog} failed"   # note: do not exit since this is the last operation fi # switch back to the original directory cd - # exit n...

OBIEE Scripts : Upload RPD Below is python script to upload RPD. I have used WLST to run this python script # $ORACLE_FMW/wlserver_10.3/common/bin/wlst.sh Upload.py # Created by Sreejith from java.io import FileInputStream from weblogic.management.utils import AlreadyExistsException, NotFoundException, InvalidParameterException def print_title(title):     print title     print '--------------------------------------------------------------------------------' user = raw_input("Enter user : ") password = raw_input("Enter password : ") #host = raw_input("Enter host(ex. adminAddress:adminPort) : ") rpd_path = raw_input("Enter RPD Path and Name (ex. C:/~/rpd_name.rpd) ") rpd_password = raw_input("Enter RPD Password : ") try:     connect('user', 'password', 't3://localhost:port') except:     print '*** ERROR *** Error occured while performing connect'     exit() #connect(us...

OBIEE Scripts: Start and Stop Scripts A Script Start and Stop OBIEE Servers #!/bin/bash # # Run-level Startup script for OBIEE # set required paths export ORACLE_FMW= OBIEE Path export ORACLE_INSTANCE=OBIEE Instance Path ScriptDir= ANY DIR LogDir=${ScriptDir}/logs updated case "$1" in start) echo -e "Starting Weblogic Server...." nohup $ORACLE_FMW/user_projects/domains/bifoundation_domain/bin/startWebLogic.sh & sleep 120 echo -e "Starting Node Manager..." nohup $ORACLE_FMW/wlserver_10.3/server/bin/startNodeManager.sh & sleep 120 echo -e "Starting Managed Server: bi_server1..." nohup $ORACLE_FMW/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1 t3://localhost:7001 & sleep 150 echo -e "Starting Components...." nohup $ORACLE_FMW/instances/instance1/bin/opmnctl startall & sleep 150 ;; stop) echo -e "Stopping Components......

OBIEE: Netezza ODBC Driver Configuration      Below are the steps I follow to configure OBIEE with Netezza in AIX. Step 1: Download the Netezza ODBC client for obiee :  available in IBM knowledge Center  Step 2: Uncompress the Netezza odbc client installer :  Install the driver in                       Oracle_bi/common/ODBC/Netezza              Use uncompress filename              also use tar -XVF filename to untar. Step 3:  Create soft link for libnzodbc.a              ln -s  libnzodbc.a  libnzodbc.so Step 4 :  Change the OBIEE user.sh and add libpath for netezza (user.sh is available    in  ORACLE_INSTANCE /bifoundation/OracleBIApplication/coreapplication/setup)                   ...

OBIEE : Change Database based on USER login    Due to some performance concerns my client wants to switch some of users to a different Db and reduce the load on first Db and they want the liberty of changing the users to both database whenever they want. Below is the solution we have implemented  1)  The client provided 2 databases and by using database clone method(volume copy)  data will be copied to second Db every morning. 2) To Implement the switching added 2 tables in  Database              Table 1 Group Connection_String G1 Database Connection String G2 Database Connection String Table 2 User Group User1 G1 User 2 G2 3) Create  Session initialization block to get the group name for the user by sending query to table 2       Sample query: Select 'GROUP_NAME',Group from table...

Automate the Admin Activities        It's been while I am thinking to automate my most of the admin jobs. The client I am working wants to restart the OBIEE server every day(not preferred option) and there will be lots changes happening in RPD and I might have to deploy the RPD at least once in every week. Below are some steps I have taken to automate most of the admin work. 1) Created Shell script for OBIEE Start/Stop 2) Created python script to deploy the RPD from specified folder. This script can call using WLST 3) Created shell script to remove the temp file 4) Created Script to clear the cache Scheduled  Cron jobs to run OBIEE start/Stop,Remove temp file and Clear cache scripts to run every day.also scheduled Cron tab for deploy RPD script to run once in every week. Now the only issue is I have to make sure the I have copied my latest RPD in path before my cron tab start(Planning to write some script for that as well :)) These...