OBIEE 10g_11G services recycling File locations & Default Ports



OBIEE 10g_11G services recycling File locations & Default Ports

OBIEE 10g  Clustering services Start \Stop order 

OBIEE 11G  Services & Files Locations

Weblogic Admin Server
/eXXXdata1/OBIEE11g/user_projects/domains/bifoundation_domain/bin and run the  startWebLogic.sh
Weblogic Managed Server
/eXXXdata1/OBIEE11g/user_projects/domains/bifoundation_domain/bin and run the  startManagedWebLogic.sh
Weblogic Node Manager
opmnctl
/eXXXdata1/OBIEE11g/instances/instance1/bin/.opmctl stopall for stopping the services
/eXXXdata1/OBIEE11g/instances/instance1/bin/.opmctl startall for starting the services

NQSConfig.ini 
/eXXdata1/OBIEE11g/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1

To enable or disable caching in the system level and table level In the NQSConfig.ini file use ENABLE under CACHE Section for System Level
for tables .If you want to enable the cache at table level , open the repository in offline mode(not the current working repository). this should be different from the current repository and click enable or disable the cache . right click the table and properties and click the cache or deselect the cache. then merge the repository with the current working one.


BI_EE_HOME Repository Variable

/eXXdata1/OBIEE11g/instances/instance1/bifoundation/OracleServerComponent/coreaplication_obis1


Sample app  repository path
/eXXdata1/OBIEE11g/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository
Catalog Path
/eXXdata1/OBIEE11g/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog

UI Changes Files

custom.css /app1/biadmin/OBIEE11g/Oracle/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp

/_WL_user/analytics_11.1.1/7dezjl/war/res/sk_blafp/b_mozilla_4
views.css /app1/biadmin/OBIEE11g/Oracle/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp
/_WL_user/analytics_11.1.1/7dezjl/war/res/sk_blafp/b_mozilla_4
custom.css /app1/biadmin/OBIEE11g/Oracle/Oracle_BI1/bifoundation/web/app/res/s_blafp
/b_mozilla_4
views.css /app1/biadmin/OBIEE11g/Oracle/Oracle_BI1/bifoundation/web/app/res/s_blafp
/b_mozilla_4

OBIEE 11G Ports

OBIEE Code Migration Techniques

OBIEE Code Migration Techniques

Migration techniques for OBIEE components (RPD etc) into various test and production environments
           Dev  to  Integration to Production ,share best practices around code migration activities ?
        RPD  Deployment  OBIEE 1og vs OBIEE 11g
OBIEE 1og
OBIEE 11g
      ·         This was  performed by  copying it from      source (Dev) region and pasting it to respective environments based on the request (DevQA-Prod)
        ·         Change it instanceconfig.xml and NQSConfig.ini file then restart

  •              It is deployed through Enterprise Manager


  •             Navigation: Business Intelligence >Coreapplication>Deployment key in the RPD Credentials




RPD  Deployment  Best Practices \Migration Techniques.
Back up the entire RPD in source and target environments
  •      RPD .
  •      Catalog.


If the developers in Development Team are still updating the RPD notify them to make changes accordingly then ,once they are done with it take a quick backup of code to be moved (RPD & Web catalog)

Production  code Drop:At my prior client there were multiple development teams associated with clients different  business to avoid the code drop suggested  respective day with particular team provided them the template which contains the  before and after changes to the Catalog and  Subject Areas to be added \Deleted\ ADF Components deployment (score cards\gantt charts) developers have to fill that out send \upload the RPD & Web catalog  to the the Configuration Management Team .
Action Item for the Configuration Management Team\Administrators.
       ·   Notify the respective teams that  the system will not be available as part of the code drop .
       ·    It is usually done after hours  .
      ·         Launch the BI Administration Tool from the  Administrator’s machine make sure that the connection pools are set properly in the source environment  RPD  change the data source name and password open the RPD always in Online Mode.


      ·    Perform the Consistency check (ctrl+k) save the RPD.
      ·     Back up the entire RPD in source and target environments (RPD &Catalog) tar \zip it with current date stamp.
     ·   Deploy RPD through EM  ONLINE MODE.
     ·    Check RPD VERSIONING before and after deployment.
    ·      Stop only the opmnctl services  and  start all.  
  • Either  STOP OPMCTL  FIRST .
  • Validate the new RPD Sequence in prod environment.
  •  Validate the Dashboards\Reports & Catalog (Folders)
  •  Make sure permissions are set after the code deployment.

Note:The Application Development team should always open the RPD in offline Mode 

CATALOG

Moving the catalog across the environment can be done in two ways
  •  Enterprise Manager
  •  Catalog Manager
  •  Archive only Shared folders  not user folders if you do so there would be an crash of security .
  •  To avoid overwrite rename the old folder and archive, delete the it . 

This we can do in multiple ways

  •  Check if the request is to move Complete catalog or Few subject areas.
  •     Check whether DEV & PRODUCTION Users are same  if it is “Yes
  •     Validate if the Users have Permissions to create ADHOC Reports if it is” Yes”.
  •      Users have permissions .

Disadvantage\Issue: Moving the entire catalog with users having permission will overwrite the existing folders and security there are chances  of getting crash

As a best practice in OBIEE 11g always Archive \Unarchive the folders that needs to be moved from Dev-QA-Stag-Prod there are two ways to deal it  
  • Login through EM 
  •   Launch the Catalog Manager
  • To Connect to Enterprise Manager (EM) you should have the  ADMIN /SUPER USER permissions.
  • Login to the Dashboard –click on Catalog— >Admin view


Mode :Offline  via  catalog  manager  identify the folder from source archive it   and  logon to em in prod \unarchive in target  make sure to perform only the folders under Shared folders  not user folders
Multiuser Development: Diff teams working on same RPD they have to go with checkin & checkout as this will avoid confusion and help the team in re-doing the activity.

OBIEE 10g vs 11g Security

OBIEE 10g vs 11g Security

The below metrics illustrates the differences between OBIEE 10g & 11g Security

































OBIEE 11g security is assigmed through Application Roles

OBIEE 10g  Security is assigned through groups


OBIEE 10G/11G – Repository (RPD file)

The repository is the file that contain all metadata of the BI Server and is managed through the administration tool.
It stores all the informations about the application environment:
  • Security,
  • Data modeling,
  • Aggregate navigation,
  • Caching and connectivity information
    The BI Server can access multiple repositories.
    They are located:
    • OBIEE  10g: BI_ORACLE_HOME/server/Repository
    • OBIEE11g: ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obisn/reposi

    OBIEE 11G Files and Services Start -Stop Location 

    Weblogic Admin Server:/eXXXdata1/OBIEE11g/user_projects/domains/bifoundation_domain/bin and run the   startWebLogic.sh

    Weblogic Managed Server/eXXXdata1/OBIEE11g/user_projects/domains/bifoundation_domain/bin and run the  startManagedWebLogic.sh
    Weblogic Node Manager
    opmnctl /eXXXdata1/OBIEE11g/instances/instance1/bin/.opmctl stopall for stopping the services
    /eXXXdata1/OBIEE11g/instances/instance1/bin/.opmctl startall for starting the services

    NQSConfig.ini 
    /eXXdata1/OBIEE11g/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1

    To enable or disable caching in the system level and table level In the NQSConfig.ini file use ENABLE under CACHE Section for System Level
    for tables .If you want to enable the cache at table level , open the repository in offline mode(not the current working repository). this should be different from the current repository and click enable or disable the cache . right click the table and properties and click the cache or deselect the cache. then merge the repository with the current working one.


    BI_EE_HOME Repository Variable

    /eXXdata1/OBIEE11g/instances/instance1/bifoundation/OracleServerComponent/coreaplication_obis1

    Sample app Repository Path
    /eXXdata1/OBIEE11g/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository

    Catalog Path
    /eXXdata1/OBIEE11g/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog

    UI Changes Files

    custom.css /app1/biadmin/OBIEE11g/Oracle/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/sk_blafp/b_mozilla_4
    views.css /app1/biadmin/OBIEE11g/Oracle/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/sk_blafp/b_mozilla_4
    custom.css /app1/biadmin/OBIEE11g/Oracle/Oracle_BI1/bifoundation/web/app/res/s_blafp/b_mozilla_4
    views.css /app1/biadmin/OBIEE11g/Oracle/Oracle_BI1/bifoundation/web/app/res/s_blafp/b_mozilla_4

    OBIEE 11g BP1 Patch Fixes

    OBIEE 11g BP1 Patch Fixes


    one-off  the Patch for Bug:13562882
    ====================================

    Date: Thu Jan 19 23:10:36 PST 2012
    ———————————-
    Platform Patch for   : Linux x86-64
    Product Patched      : Oracle Business Intelligence Enterprise Edition
    Product Version      : 11.1.1.5.0
    -auto enabled        : Yes
    Bugs Fixed by this patch:
    ————————-
    10295403:EXCEL DOWNLOAD TOTAL RULE LINES ARE MISSING
    11793832:MULTIPLE VALUES IN A DASHBOARD PROMPT DOESN’T WORK WITH BI PUBLISHER INTEGRATED
    11815935:NLS:THE SETTING FIRSTDAYOFWEEK IN LOCALEDEFINITIONS.XML DON’T AFFECT CALENDAR UI
    11837656:NLS:THE EXPORTED CSV WOULD BECOME MISALIGNED WHEN TITLE OR VALUE CONTAIN COMMAS
    12315036:PSR:ST3B16 NO TIMEOUT  BETWEEN OBIS AND WLS SECURITY AUTHENTICATION
    12373034:SEARCH DIALOG BOX IS SLOW WHEN THERE IS AN EXISTING FILTER
    12391045:FUNCTION REPORT_AGGREGATE REQUIRES AT LEAST ONE MEASURE COLUMN IN ITS FIRST ARGU
    12393459:WRONG WEBCATALOG PERMISSION GIVEN TO LOGIN USER  (security issue)
    12407600:STRESS: NQSSERVER CRASHED IN THE ODBC LOGICAL QUERIES 360 STRESS TEST
    12550336:RC2-HOT-BIAPPS: GUIDED NAVIGATION NOT SHOWING ON DASHBOARD PAGES
    12561330:DRILL DOWN REPORTS WITH SQL FILTER ARE  ERRORING OUT  IN SYSTEM TEST ENV
    12562702:PERIODICALLY CALL MACOMPACT()
    12587722:AFTER UPGRADE, NQSERROR 42015 CANNOT FUNCTION SHIP THE FOLLOWING EXPRESSION
    12638186:EXCEL EXPORT GENERATES A SPACE BEHIND ANY MEASURE VALUE WHEN USING ACTION LINK
    12656913:OBI 11G ONDEMAND – DASHBOARD MENU ITEMS DISAPPEAR FROM MENU
    12676102:DIVISION BETWEEN INTEGERS ARE NOT CONSISTENT BETWEEN WINDOWS AND LINUX.
    12696084:FORMAT HEADINGS > HORIZONTAL ALIGNMENT IS NOT WORKING IN TABLE OR PIVOT VIEW
    12701383:11G DOWNLOAD TO EXCEL INCLUDES A BLANK TEXT ROW BELOW THE LAST ROW OF DATA
    12710524:ORA-1704 ERROR OCCURS WITH QUERY_BLOB CLOUMN OF USAGE TRACKING
    12715885:HORIZONTAL ALIGNMENT WON’T WORK FOR NARRATIVE, STATIC TEXT VIEW IF EXPORT TO PDF
    12716399:TOTAL_TIME_SEC VALUES INFLATED WHEN REQUEST HAS ‘DISPLAY MAXIMUM’ BUTTON
    12725139:VARIABLE VALUES NOT RESOLVED IN TITLE/LEGEND OF CHART, SHOWS FORMULA
    12810496:BIPS NAVIGATION SPINS DUPLICATE LOGICAL QUERIES (WITH BYPASS CACHE OPTION).
    12822192:INCORRECT RESULTS AFTER DOWNLOADING TO EXCEL (LOCALE DIFFERENT THAN ENGLISH)
    12831483:INTERNAL ASSERTION: CONDITION BYTECONVERTED <= FROMBUFFERSIZEINBYTES
    12836077:PERFORMANCE DIFFERENCE AFTER UPGRADING TO 11.1.1.5
    12870926:NO ABILITY TO CONFIGURE SMA COMPACT FREQUENCY
    12888983:FIELDSTORAGE ON 64-BIT NEEDS 8K BUCKETS ADDED TO SMA
    12900745:NARRATIVE VIEW IS FETCHING ALL RECORDS EVEN WHEN ROWCOUNT IS SPECIFIED
    12911049:EXPORT (PDF, EXCEL, ETC.) OPTION IS NOT EXPORTING ALL ROWS OF A REPORT
    12921728:DXE MAKING UNNECESSARY COPY OF DATA FOR SINGLE AXIS LAYOUTS
    12926133:EXPAND \ COLLAPSE NOT WORKING FOR PARENT CHILD DIM AFTER PATCH 12899699
    12937512:BI SERVER CRASHES AND RESTARTS STD BAD_ALLOC ORA-24550 ERROR
    12960177:ADDING CALCULATION TO THE HIERARCHY COLUMN IN SELECTION STEPS RESULTS IN ERROR
    13026233:USAGE TRACKING INSERT MISSING A COMMA
    13031827:XSLFO PROCESSING CONSUMES TOO MUCH MEMORY
    13070272:READING XSL-FO XML MEMORY CONSUMPTION CAN BE REDUCED BY 50%
    13083732:IN PARENT CHILD HIERARCHY EXCESS MEMORY SPIKE
    13084799:QUERIES AGAINST BISERVER NOT LEVERAGING FORWARD ONLY OPTION
    13087545:CONDITIONAL FORMATS IN TABLE VIEW CAUSE EXTRA COMPUTATIONS
    13102881:DATALAYOUT METADATA  IMPLEMENTATION HEAP INTENSIVE
    13251234:SMALL STRINGS ON 64-BIT RESERVE EXTRA CAPACITY
    13258962:BITHIRDPARTY ATOMIC OPERATION CAN CORRUPT NEXT 32-BIT WORD IN LINUX-64
    13262149:IBOT SUBSCRIPTION CODE CAN CRASH ACCESSING USER GUID
    13263694:CATALOG MANAGER OFFLINE MODE DISPLAYS INIT BLOCK USERS AS INVALID
    13324965:SAWSERVER CRASH IN IBOTGETMETADATA
    13336101:UNNECESSARY COPY OF DATA IN CACHINGTABLE
    13355961:STRESS BI NQ SERVER CRASHES DUE TO ANAATOMICDECREMENT CORRUPTION
    13366675:INAPPROPRIATE PRE-RESERVES WITH STRINGBUFFER
    13377442:EXPORT LINKS SHOULD WARN / ERROR WHEN ALREADY EXPORTING
    13383217:QDR ISCUSTOMGROUPUNIQUEID DOES UNNECESSARY STRING CONCATENATION
    13383976:PERFORMANCE REGRESSION IN CLIENT DATA SCROLLING IN BIPS
    13384157:LARGE SMA BUCKET SIZES NEED TO BE ALIGNED TO POWERS OF 2
    13404742:REDUCE DL MEMORY FOOTPRINT FOR 64-BIT BY CHANGING INST MEMBER DATA TYPES
    13409646:CALCULATED ITEMS CAUSE MANY INTERNAL CUBES  WITHIN DXE
    13416870:RACE CONDITION IN PRESORTED CUBE
    13425631:CONDITIONAL FORMAT ON NUMERIC LITERAL COLUMN GIVES ASSERTION ERROR
    13442873:REMOVE QDR CACHE IN DLITEMINSTANCE
    13455402:DXE UNNECESSARLY STORING MULTIPLE COPIES OF VARCHARS WITH MANY COLUMNS
    13455408:ENHANCE DXE FIELDSTORAGE TO GROUP SMALLER ALLOCATIONS
    13455412:DXE MAKING EXTRA COPIES OF DATA
    13455456:CERTAIN DXE SORTS ARE BEING DONE IN MEMORY INSTEAD OF ON DISK
    13474382:MEMORY LEAK IN COLUMNORDER / MEASUREORDER OBJECT HANDLING
    13529441:MULTI DASHBOARD PROMPT DOESN’T WORK WITH BI PUBLISHER INTEGRATED
    Prerequisites:
    ————–
    1. Before applying non-mandatory patches, check whether you have the exact symptoms
    described in the bug.
    2. Review and download the latest version of OPatch 11.1.x via Bug 6880880.
    (OPatch version 11.1.0.8.2 or higher)
    Oracle recommends that all customers be on the latest version of OPatch.
      Please review the following My Oracle Support note and follow the instructions
      to update to the latest version if needed:
      Note 224346.1 – Opatch – Where Can I Find the Latest Version of Opatch?
      For FMW Opatch usage, please refer the doc at :
      Additional Step Needed for AUTO option:
      2.1) Starting with OPatch 11.1.0.8.2+ the -auto flag asks for the Node Manager
      username and password. To validate it, please check:
      Note 1146793.1 – How to check/verify/modify Node Manager username & password?
    3. Verify the OUI Inventory.
    OPatch needs access to a valid OUI inventory to apply patches.
    Validate the OUI inventory with the following command:
    - opatch lsinventory -jre $ORACLE_HOME/jdk/jre
    If the command errors out, contact Oracle Support and work to validate
    and verify the inventory setup before proceeding.
    4. Confirm executables appear in your system PATH.
    The patching process will use the unzip and the opatch executables. After
    setting the ORACLE_HOME environment, confirm both of these exist before
    continuing:
    - “which opatch”
    - “which unzip”
    If either of these executables do not show in the PATH, correct the problem
    before proceeding.
    5. Create a location for storing the unzipped patch. This location
    will be referred to later in the document as PATCH_TOP.
    Follow Steps 6 and 7 only if you choose to use the AUTO flag:
    6. Node Manager Configuration:
    With the AUTO flag, the OPatch utility uses WLST with the Node Manager to
    start/shutdown the required WLS server(s) – Admin server and/or Managed Server(s).
    To properly configure the Node Manager follow below instructions:
      i) Create or validate the nodemanager.properties file, which by default is located at:
      [MW_HOME]/[WLS_HOME]/common/nodemanager (on UNIX operating systems) or
      [MW_HOME]\[WLS_HOME]\common\nodemanager (on Windows operating systems) directory.
      Example:
      /opt/product/fmw11g/wlserver_10.3/common/nodemanager/nodemanager.properties
      ii) Add or validate the following lines onto the nodemanager.properties file:
      StartScriptEnabled =true
      StopScriptEnabled =true
      iii) Ensure NodeManager is running by using:
      [MW_HOME]/[WLS_HOME]/server/bin/startNodeManager.sh (UNIX)
      [MW_HOME]\[WLS_HOME]\server\bin\startNodeManager.cmd (Windows)
    7. Setting the Machine Name and Listen Address:
      Machine Name and Listen Address can be blank on a default installation. So for the AUTO option:
      The Machine Name for each WebLogic Server (including the Administration Server) must be
      set to a valid value. It cannot be set to blank or None.
      The Listen Address of the Administration and Managed Servers must be set to the real physical
      host’s address (hostname, FQDN, or IP address). It cannot be set to blank or localhost.
      (a) Configure the Managed Server(s):
      Within the WLS Admin Console, proceed as below:
      1. In the Domain Structure navigate to:
      -> [DOMAIN_NAME] > Environments > Machines
      2. Click the ‘Lock & Edit’ button on the left hand side (if WLS in Production mode)
      3. Create a new machine, by clicking the ‘NEW’ button – give it a name
      and choose Unix, for example, if you are in an unix env. (at ‘Machine OS’).
      4. Select the Machine you’ve just created and go to the:
      Configuration > Node Manager and change the ‘Listen Address’ to [HOST_NAME]
      (eg, the host which the Node Manager is listening) and then click the ‘Save’ button.
      5. In the Domain Structure navigate to:
      -> [DOMAIN_NAME] > Environments > Servers
      6. Click on each Managed Server (bi_server1 in OBIEE),
      assign the Machine you’ve created in step 3. Additionaly type in within the ‘Listen Address’
      the name of the host where the NodeManager is running. Click the ‘Save’ button.
      7. Click the ‘Activate Changes’ button on the left hand side (if WLS in Production mode)
      NOTE: If the WLS is in Development mode steps 2 & 7 will not be needed.
      (b) Configure the Admin Server:
      Within the WLS Admin Console, proceed as below:
      1. Stop the Admin Server (and all the Managed Servers).
      Only if WLS in Production mode:
      2.Take a backup of the existing config.xml file of the WLS domain.
      The default one is at:
      [MW_HOME]/user_projects/domains/[DOMAIN_NAME]/config/config.xml
      Modify the config.xml to:
      Search for “AdminServer” entry and add the below entries under it:
      ————————————————
      [HOST_NAME]
      [HOST_NAME]
      ————————————————
      Save the file   Only if WLS in Development mode:
      2. Assign the Machine you’ve created previously and click the ‘Save’ button.
      Additionaly type in within the ‘Listen Address’ the name of the host where
      the NodeManager is running.
      (c) Change the Hostname Verification for the Admin Server:
      Additionally, WLS Admin Console, proceed as below:
      1. Click the ‘Lock & Edit’ button on the left hand side (if in Production mode).
      2. In the Domain Structure navigate to:
      -> [DOMAIN_NAME] > Environments > Servers
      3. Click on the AdminServer and then within the Configuration tab and over the SSL subtab.
      4. Click within the Advanced link and then change the ‘Hostname Verification’ from
      ‘BEA Hostname Verifier’ to ‘None’.
      5. Click the ‘Save’ button.
      6. Click the ‘Activate Changes’ button on the left hand side (if WLS in Production mode)
      7. Restart the Admin Server.
      NOTE:
      =====
      1. If the WLS is in Development mode steps 1 & 6 will not be needed.
      2. If the WLS won’t start, please revert back the config.xml and contact the Oracle Support.
     Pre Install Instructions:
    ————————-
    • Set the ORACLE_HOME environment variable,  for example “[MW_HOME]/Oracle_BI1″ directory.
      
    Patch Apply Modes:
    ——————
    With AUTO flag : The Admin Server and NodeManager have to be running for ‘opatch -auto’ operations.
    The Managed Servers may or may not be in a running state.
    OPatch will bounce all the local servers (and the servers sharing the Middleware Home)
    affected by the patch. If the patch affects an application deployed on the Admin server,
    the Admin server will also be bounced. If the Managed Servers are not running, OPatch
    won’t restart the affected servers.
    It is users’ responsibility to start those servers in order to uptake the patch.
    Without AUTO flag : No servers need to be started.
    At the end of the patch apply all servers must (re-)started to uptake the patch.

    Install Instructions:
    ———————
    1. Unzip the patch zip file into the PATCH_TOP.
       unzip -d PATCH_TOP p13562882_111150_Linux-x86-64.zip
    2. Set your current directory to the directory where the patch is located.
       cd PATCH_TOP/13562882
    3. Run OPatch to apply the patch.
      NOTE: Though this patch is AUTO flag enabled, the user still has the choice to apply it without the AUTO option.
      However doing so involves manual restarting of the affected servers.
      (a) If applying without AUTO:
      Run following command:
      – opatch apply -jre $ORACLE_HOME/jdk/jre
      (b) If applying with AUTO:
      Run following command:
      – opatch apply -auto -jre $ORACLE_HOME/jdk/jre
      NOTE:
      —–
      i. The user would be prompted for the following inputs by OPatch
      to complete the auto patch application process.
      AdminUser : Please enter the WebLogic Admin Server username
      AdminPassword : Please enter the WebLogic Admin Server password
      AdminServerURL : Please enter the WebLogic Admin Server URL
      DomainHome : Please enter the WebLogic domain directory location
      ApplicationsDir : Please enter the WebLogic applications directory location
      default location is : [MW_HOME]/user_projects/applications/[DOMAIN_NAME]
      NodeManagerUser : Please enter the NodeManager username
      NodeManagerPassword : Please enter the NodeManager password
      Please ensure input values are exact & correct to avoid undesired patch failures.
      ii. At the end of “opatch apply -auto” command, if you see the WARNING message below,
      The following warnings have occurred during OPatch execution:
      1) OUI-67851: All the applications affected by this patch are deployed in ‘No Stage’ mode.
      Redeploy operation will not be performed for the affected applications.
      Please refer to the log file for more details.
      It may be just cause the OPatch expects secure connections.
      Please kindly review the log file to be sure.
     When OPatch starts, it will validate the patch and make sure there
    are no conflicts with the software already installed in the ORACLE_HOME.
    OPatch categorizes two types of conflicts:
      (a) Conflicts with a patch already applied to the ORACLE_HOME
      In this case, please stop the patch installation and contact
      Oracle Support Services.
      (b) Conflicts with subset patch already applied to the ORACLE_HOME
      In this case, please continue the install, as the new patch
      contains all the fixes from the existing patch in the ORACLE_HOME.
      The subset patch will automatically be rolled back prior to the
      installation of the new patch.
    4. If any of the J2EE server files (*.ear, *.jar, *.war etc) were updated during
       the previous step, you would need to deploy these files into your web server,
       by consulting your specific Web Server documentation.
      NOTE: when the OPatch was applied with -auto option, step 4 is not needed.
     Post Install Instructions:
    ————————–
    1. In case, you have opted to apply without AUTO:
    • Deploy this analytics.ear file through your application server if it is not automatically deployed.
    •  Restart all servers (AdminServer and all Managed server(s))
    2. In case, you have opted to apply with AUTO:No Action Needed.
      
    Deinstallation Instructions:
    —————————-
    If you experience any problems after installing this patch, remove the patch as follows:
    1. Make sure to follow the same Prerequisites or pre-install steps (if any) when deinstalling a patch.
       This includes setting up any environment variables like ORACLE_HOME and verifying the OUI inventory
       before deinstalling.
    2. Change to the directory where the patch was unzipped.
       cd PATCH_TOP/13562882
    3. Run OPatch to deinstall the patch.
      (a) If rolling back without AUTO :
      Run following command: opatch rollback -id 13562882 -jre $ORACLE_HOME/jdk/jre
      (b) If rolling back with AUTO :
    •   Run following command:
    •   opatch rollback -id 13562882 -jre $ORACLE_HOME/jdk/jre -auto
     Post Deinstallation Instructions:
    ———————————
    1. In case, you have opted to apply without AUTO:
    • Restart all servers (AdminServer and all Managed server(s))
    2. In case, you have opted to apply with AUTO:No Action Needed.

    OBIEE 11g OCI Connectivity Issues

    OBIEE 11g OCI Connectivity Issues

    OCI Connectivity Issue

    Issues with  Oracle Database Connectivty using OCI.

    Solution:Make sure that the following conditions are true:

    •  The computer\system running the Oracle BI Server must use Oracle Call Interface (OCI) to connect to the database.
    •  If you choose not to use the entire connect string in the repository connection pool, you must ensure that a valid tnsnames.ora file is set up in the following location within the Oracle Business Intelligence environment, so that the Oracle BI Server can locate the entry:


    ORACLE_HOME/network/admin

    •  If you choose not to use the entire connect string in the repository connection pool, ensure that the net service name in the tnsnames.ora file matches the Data Source Name used in the connection pool. For example, in the following example of a tnsnames.ora entry, the corresponding Oracle BI repository connection pool Data Source Name is VZ.

           IT =
          (DESCRIPTION =
         (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = VZWL.corp)(PORT = 1521))
        (CONNECT_DATA =
       (SERVICE_NAME = VZWLcorp)
       )
       )
    The following procedure shows how to check repository database and connection pool settings against the Oracle tnsnames.ora settings.
    To check that the repository database and connection pool settings are correct:
    1. Open your repository in the Administration Tool.
    2. In the Physical layer, double-click the database you want to check to display the Database dialog.
    3. On the General tab, in the Data source definition: Database field, ensure that the appropriate Oracle Database version is selected. Then, click OK.
    4. Open the Connection Pool dialog for this data source. You might need to expand the database object in the Physical layer to see the Connection Pool object.
    5. In the Connection Pool dialog, check that the following is true:

    •    The Call interface field displays the appropriate value for the release of the Oracle Database you are using.
    •    The Data source name field displays the Oracle Database net service name that you defined in the tnsnames.ora entry.
    •    The User name and password fields contain the correct values.

    Change the values if necessary, then click OK.
    6. In the Oracle Business Intelligence environment, open the tnsnames.ora file located in the following directory:
    ORACLE_HOME/network/admin
    7. Check that a valid net service name exists with the following characteristics:

    • Matches the connection pool settings for the Data Source Name
    •  Specifies the targeted Oracle physical database

    Oracle Map viewer Installation & Configuration

    Oracle Map viewer Installation & Configuration


    Map viewer Installation & Configuration

    MapViewer Introduction.

     MapViewer is a J2EE service for rendering maps using spatial data managed
     by Oracle Spatial.MapViewer provides services and tools that hide the complexity of spatial
    data queries and cartographic rendering, while providing customizable options for more
     advanced users. MapViewer is designed to integrate with Location-Based services and
    applications.

    Configure Install script
    Copy the map_install from other server where it is deployed (eicfdcn35) or  if it’s not in any other server
    Download SampleApp V10722 Installation ZIP Files from OTN which contains installation files including database dump files

    Save the zip file on to the machine where OBIEE 11g is preconfigured, up and running.
    Change it using chmod 777 map_install
    Edit the “installSA.sh” installation script using a text editor to specify correct values for the following variable names. “installSA.sh”. Incorrect values can result in incorrect .

    Troubleshooting Install Script

    When the installSA.sh is executed  we may encounter the following error
    -bash: ./installSA.sh: /bin/sh^M: bad interpreter: No such file or directory

    If you encounter this error, then create a new file called installSA1.sh, copy and paste the contents of installSA.sh into the new file installSA1.sh. Then grant execute privileges on this new file using chmod 777 installSA1.sh. Now execute installSA1.sh to run the installer.
    If your OBIEE installation is of is of „Enterprise‟ and not „Simple‟ type, then your setup will have both AdminServer and bi_server1. In this case, the installer will give the following error while trying to copy a couple of files for Actions because the path needs to be bi_server1 instead of AdminServer.

    The below option has to be worked out if the below changes are not made .

    1.     Oracle \OBIEE home path \
    2.     Replace bifoundation_domain1 with bifoundation_domain

    [INFO] Copying files for Actions
    cp: target `/app/oracle/product/obiee/11g/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/_WL_user/analytics_11.1.1/silp1v/war/res/b_mozilla/actions/’ is not a directory
    cp: target `/app/oracle/product/obiee/11g/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/_WL_user/analytics_11.1.1/silp1v/war/res/s_blafp/images/’ is not a directory
    These two copy steps need to be manually executed with the appropriate paths on your setup.
    1) Copy Comment.gif and NoComment.gif from your SampleApp install location /Actions/CommentaryArtifacts to the following two locations on your OBIEE install

    /installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions
    and /installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/s_blafp/images
    2) Copy UserScripts.js from your SampleApp install location /Actions/CommentaryArtifacts to the following two locations on your OBIEE install

    /installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions
    and
    /installhome/ Oracle_BI1/bifoundation/web/app/res/b_mozilla/actions
    C:\OBI11G\Oracle_BI1\bifoundation\web\app\res\b_mozilla\actions
    If your environment doesn‟t support neither batch nor shell scripts, then you will have to carry out the copy process manually before you proceed with the rest of the steps. Similarly if any part of the “installSA” script fails, retry the failed command and all the remaining commands manually. You may open the script using a text editor and refer it to understand the source and target files paths and the list of files to be copied.
     The below status indicates the list of files that got copied after running the installSA.sh file

    1) Copy Comment.gif and NoComment.gif from your SampleApp install location /Actions/CommentaryArtifacts to the
    following two locations on your OBIEE install
                                  
    /installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7
    dezjl/war/res/b_mozilla/actions
    and                            
    /installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/s_blafp/images

    From the sample app  location copy the2 gif files
    [biadmin@eicfdcn37 CommentaryArtifacts]$ pwd
    /essdata1/map_install/SampleApp_10722/Actions/CommentaryArtifacts
    Copy the files Manually to the location if  you run into file copy issues
    /essdata1/OBIEE11g/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions
                   
    Gif .files

    RPD file: The SampleApp.rpd file that is in the install directory does NOT need to be moved into your BIEE install. It will be used directly by EM administration process, and needs to be copied to the machine where you will run EM browser from.

    Restoring Data Dumps

         Oracle data dump is used to import the definition and data for several database schemas. If any of these schemas exist, they must be dropped before you begin the import. In case they cannot be dropped, the schemas may be imported into different schema names using schema mapping options available for impdp command. If the schema names and/or passwords are changed, it will require additional corrections and configurations in SampleApp RPD.

    Send an email to the DBA Team requesting them to create the Mpaviewer schemas and send them the Mapviewer documentation link[           ]

    These tasks will be performed by DBA .

    From  the  SampleApp installation files, copy \DataSources\ORCL\SASCHEMAS.dmp file to the machine where Oracle database 11gR2 is up and running
    Unzip this file to a folder on the database server, say “C:\datapump\”
    Connect to database using a sysdba user and create a directory object to import the database dump. Change the data base connection parameters (highlighted in red) to reflect your connection settings.
    sqlplus “sys/Admin123@sampledb1 as sysdba”
    create or replace directory datapumpdir as ‘c:\datapump’;
    Import the database dump using the command below.

    impdp “‘”sys/Admin123@sampledb1 as sysdba”‘” directory=datapumpdir dumpfile=SASchemas.dmp version=11.2.0.0.0 schemas=BISAMPLE,OBIEE_NAVTEQ,BIFOD,BIBPM,DEV_ODI_REPO,ODI_STAGING LOGFILE=SASchemas_imp.log
    NOTE:- Change the value of Version parameter depending on the version of your target database.
    During the import process you may get the warning ORA-39082: Object type VIEW:”BISAMPLE”.”ODM_SAMP_CUSTOMERS_LTV” created with compilation warnings
    This a known warning and can be ignored.
    Once the import is completed, connect back to the database using a sysdba user and execute the following sql commands.

    To connect use - sqlplus “sys/Admin123@sampledb1 as sysdba”
    alter user BISAMPLE identified by BISAMPLE;
    alter user OBIEE_NAVTEQ identified by obiee_navteq;
    alter user BIFOD identified by BIFOD;
    alter user BIBPM identified by BIBPM;
    alter user DEV_ODI_REPO identified by DEV_ODI_REPO;
    alter user ODI_STAGING identified by ODI_STAGING;

    insert into user_sdo_maps select * from obiee_navteq.my_maps;
    insert into user_sdo_themes select * from obiee_navteq.my_themes;
    insert into user_sdo_styles select * from obiee_navteq.my_styles;
    insert into user_sdo_cached_maps select * from obiee_navteq.my_tile_cache;
    commit;

     Creating Weblogic Server Users

    Start Weblogic AdminServer

     On your server, navigate to: /essdata1/OBIEE11g/user_projects/domains/bifoundation_domain/bin and run the  startWebLogic.sh depending on your environment OS. You will be prompted with your Administrator credentials created during platform install. Bringing up this service may take a few minutes depending on your environment, wait until the command line.

    Importing Users in Weblogic

     This step is required in order to have most of the SampleApp features to work. Make sure the FMW import happens properly on your environment. Open the weblogic Administration console online (http://eicxxcxxx.ebiz.xxxxx.com:7001/console use the login that was  created in BIEE installation to log in). 
      
       From home screen, click on Security Realms link.

    Go to the migration page tab. Go to the  Import tab.
    In the ‘Import Directory on Server’,  point to the directory where you saved
    the SampleApp Install files, navigate to the core folder and FMW_Users_Definition subdirectory within that.

    Click on Save. This should import all the SampleApp users into your  environment. To confirm it, click
    on Users and Groups tab.

    Activate the changes
    ·         Verify that you can see the new users like abell, etc created now. You should be able to login using any of these users in OBIEE
    The list of users in this build is listed in the table below. Passwords for all SampleApp users imported, as well as the RPD encryption password is uniquely set to :Admin123

    Verify by logging with the Admin123 for any of the above users listed.

    This step allows to point WLS to the file folder location where you have pasted custom files
    for SampleApp (Images, styles, messages…).
    Login to weblogic Administration console (http://eicxxxxx.ebiz.xxxxx.com:6001/console   use the login
    you created in BIEE installation to log in).
    Navigate to deployments area. 
    Click on the Install button in the  deployments area to install a new  web application. (If Install button is
    not enabled, click on Lock & Edit  on the left frame).

    In the Install Application Assistant  dialog, provide the path:
    \installhome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1
    This should give the option to select analyticsRes as a valid application to deploy.
    Select analyticsRes and click on Next In the Install Application Assistant  dialog, provide the path:
    \installhome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1
    This should give the option to select analyticsRes as a valid application to deploy


    This step is required to make metadata dictionary available within SampleApp.
    ü IMPORTANT Note :

    The metadata dictionary folder name SampleApp_BI0001 in the path
    OBIEE11g]$ cd instances/instance1/metadatadict/SampleApp_BI0001/
    should be the same as the rpd name that is online currently. If your rpd name has changed to say SampleApp_BI0002 or SampleApp_BI0003, then change the directory name of the SampleApp_BI0001 under metadatadict to the same name as the rpd.

    Deploying the Dictionary in WLS

     eblogic Administration console screen, click on Deployments area.
    Click on the Install button in the deployments area to install a new web application. (If Install button is not enabled,
    click on Lock & Edit on the left frame).

    Specify the path as indicated below for the metadatadict deployment click Next proceed .

    Path:/essdata1/OBIEE11g/instances/instance1/metadatadict

    Choose the deployment type as application

    It should be deployed on bi_cluster

    NQSConfig.ini Edits

    Open NQSConfig.ini file from the following location:
    /essdata1/OBIEE11g/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1

    BEFORE CHANGE

    USER_REF_GUIDS

    Make sure the following tag (in green) is set as shown below in your NQConfig file and save it :
    ->[SERVER]
    FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

    2.6.1.2.Usage Tracking

    The following entry is not mandatory, but will allow the usage tracking SampleContent to show data, it is advised that you set
    these tags as described :
    ->[USAGE_TRACKING]
    ENABLE = YES; 
    DIRECT_INSERT = YES; 
    PHYSICAL_TABLE_NAME = “10 – System DB (ORCL)”.”Catalog”.”dbo”.”S_NQ_ACCT”; 
    CONNECTION_POOL = “10 – System DB (ORCL)”.”UT Connection Pool”;
    Before Changing
    AFTER CHANGING THE NQSConfig file
    1USER_REF_GUIDS
    Make sure the following tag (in green) is set as shown below in your NQConfig file and save it

    Instanceconfig.xml Edits

    Open Instanceconfig.xml file from the below location :

    /essdata1/OBIEE11g/instances/instance1/config/OracleBIPresentationServicesComponent\coreapplication_obips1

    Comment the following tag.
    false

    Make sure you have all the following tags (in green below) in the file, within the existing tag. Some of these entries may already be present in your file. Ensure that entries are made only once and are in appropriate locations.
    1000
    true
    false
    UpdateAndStartNormally
    LogonParamSQLTemplate
    100
    /metadatadict/

    Instanceconfig.xml edits
    Added under server instance
    1000
    true
    false
    UpdateAndStartNormally
    LogonParamSQLTemplate
    100
    /metadatadict/

    Add the similar code in instance config.xml SAC server under this path
    /apps/biadmin/OBIEE11g/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

    RPD Edits

    ü IMPORTANT Note :
    Always open Admintool by opening the Start program menu, and navigating on to the menu icon within the Oracle Business Intelligence menu. Do NOT open the RPD simply double click on the RPD file or typing Admintool.exe in command line
    Open Admintool then open the SampleApp.RPD file offline from your installer location :
    RPD Password for opening offline : Admin123

    RPD Existing Connections


    Navigate to Manage>Variables menu, double click on the BI_EE_HOME Repository Variable, update the default initializer string from its current value to the correct fullpath of the following directory on your BIEE install :

    /essdata1/OBIEE11g/instances/instance1/bifoundation/OracleServerComponent/coreaplication_obis1

     Update RPD variables that contain database connection information

    The connection pools setting uses repository variables to connect to the underlying database. You must update these variables to allow the RPD to properly connect. On the RPD click on Manage->Variables and update the following variables to appropriate values to connect to your database.

    DB_HOST - This variable holds the value of the database host machine.
    DB_PORT - This variable holds the value of the port.
    DB_SID - This variable holds the SID information.
    DB_USERNAME - This variable holds the database username. (Must be BISAMPLE)
    WLS_HOST - This host information should be the computer name (or IP) of your Weblogic Server host.

    If you have not changed the OOB password for BISAMPLE user (pwd = „BISAMPLE‟), then there should be no edit needed in the RPD. If you have changed the value of the password for the BISAMPLE user, you need to edit password values for all the Connection Pool entries in RPD that use the above variables with your correct password value.

    Update settings with RCU db for Scheduler Connection Pool

    The values in “Scheduler Connection Pool” under “07 – Scheduler Jobs” database need to be updated to point to the BIPLATFORM schema that is installed during OBIEE installation. In the connection pool, update the data source name with the appropriate values of database host, sid, port, username and password of the BIPLATFORM schema.
    ü Note :
    The BIPLATFORM schema is the one that is used during the OBIEE installation process.

    Expected Consistency Warnings

    ü Important : Expected Consistency Warning

    Run a consistency check of your RPD. You should see the single following consistency warning message :
    RPD Consistency check

    This warning is expected; do not try to fix it. Fixing it would break the OLAP API functionality. In case you see other errors or warnings coming up, please process previous steps again starting from the original RPD.

    Save the RPD Offline after updating the required changes

    Setting the default rpd and webcat paths through EM

    Login to the EM administration screen using the url http://eicfxxxx.ebiz.xxxx.com:6001/em

    RPD selection

    Use the login that was created during OBIEE installation to log in to the EM  http://eicfxxxx.ebiz.xxxx.com:6001/em
    Expand ‘Business Intelligence’ node on the left and choose Coreapplication

    ·         Click on ‘Lock and Edit Configuration’ to enable you to change the default settings.

    ·         Click on the Deployment tab on the right. Navigate to the Repository tab.

     ·         In the ‘Upload BI Server Repository’ section, click on the Browse button and locate the SampleApp.rpd that you updated with correct connection information, on your client machine.
    ·         Enter Admin123 as the password ( this is the offline password for SampleApp.rpd)
    ·         Stay on the same configuration screen to update webcat selection
     This platform install, does not yet point to SampleApp catalog, you need to update the path at the bottom of the same EM screen, with the location looking like this.
    Change the path to point to SampleApp Webcat so the location gets reflected as indicated below.
    Sample AppWebcat path:/essdata1/OBIEE11g/instances/instance1/SampleAppWebcat
    Default path: $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/SampleAppLite
    Sample app  repository path
    /essdata1/OBIEE11g/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository
    Catalog Path:[biadmin@eicfdcn37 catalog]$ pwd
    /essdata1/OBIEE11g/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog
    Default  catalog path in em
    $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/SampleAppLite

    Apply changes

    ·         Click on Apply (top right corner of screen)
    ·         Click on activate changes

     Configuring SampleApp Mapviewer Content

     Confirm that WLS server and WLS managed servers are up and running, and make sure OMPNCTL is not running (neither OBIS nor OBIPS are running). Stop BI Server and Presentation Server if they are running.

    MapViewerConfig.xml Edits

    Open the map viewer console login with the user name and password that was provided while installing the product
      
    In the property of this file, make the following changes:

    Change the property to the following :

    Substitute the hostname, IP address and port to the correct values on your setup.
    (NOTE:- There are 4 entries here. Two of them refer to the hostname and while two refer to the ip address of the machine where OBI is installed. Update all 4 entries to the hostname and ip address on your setup)
    ———————————–

    Substitute any entries with these tags with the property entries below: If the entry already exists, confirm that the value is as shown below. If the entry does not exist, then add a new entry with the value given below.

    < true
    true
    true
    true
     At the end of the file, in the section named ‘Predefined Data Sources’, add the following data source entry. Replace the ipaddress, sid and port to the correct values of the database where the obiee_navteq schema has been created in the above steps.
    <map_data_source name="OBIEE_NAVTEQ_Sample"
    jdbc_host=”10.229.147.238″ (use your db ip)
    jdbc_sid=”orcl” (use your db sid)
    jdbc_port=”1521″ (use your db port)
    jdbc_user=”obiee_navteq”
    jdbc_password=”!obiee_navteq” (use your selected password if different from OOB)
    jdbc_mode=”thin”
    number_of_mappers=”3″
    allow_jdbc_theme_based_foi=”false”
    />
    Make sure all tags have been closed correctly and also make sure the above data source is not within the comments section (ensure that it is outside the comments section which is represented by )

    Post changes

    This should reflect as indicated below
    <map_data_source name="OBIEE_NAVTEQ_Sample"
    jdbc_host=”eicfxxxx.ebiz.xxxx.com”
    jdbc_sid=”VS2″
    jdbc_port=”1521″
    jdbc_user=”obiee_navteq”
    jdbc_password=”!obiee_navteq”
    jdbc_mode=”thin”
    number_of_mappers=”3″
    allow_jdbc_theme_based_foi=”false”
       />  
    uncomment the above in default code and password should be prefixed with !

     Save & Restart, Verify

    Click on Save & Restart button at the bottom of the file. Once it is restarted, Click on Data sources. You should now see OBIEE_NAVTEQ_Sample as an entry there.To confirm that the Mapviewer configuration is working, choose the Map Tile Layer called OBIEE_WORLD_MAP and click on ‘View Map / Manage tiles’ option. In the window that opens up, click on the ‘Show Map’ button. This should display the world map. Repeat the steps for the Map Tile Layer called OBIEE_WORLD_MAP_FAST and confirm that the world map is displayed.
    ·         Click on save and re start the password now be viewed in the  encrypted form.

    No need to add the data source manually it would get reflected as indicated below.

     MapViewer Configuration settings screenshots

       

    Known Mapviewer Issues:If the schemas are not created properly and the relevant inserts statements are not passed on the default maps wouldb’t get reflected.


    ·         Click on “Manage Tile Layers”. Click “Create”
    ·         Select Google Maps as Tile Layer Type
    ·         Select “Google Maps” as type of map source. Click “Continue”  
    ·         Enter “key”

    On the tile layer properties page, enter a valid value for the key. Select a data source from the Data Source dropdown. Click “Submit”. Test the tile layer by selecting the tile layer from the list of layers and click “View Map / Manage Tiles”

    Edit/view API Key
    On the tile layer properties page, enter a valid value for the key. Select a data source from the Data Source dropdown. Click “Submit”. Test the tile layer by selecting the tile layer from the list of layers and click “View Map / Manage Tiles”

    Key assigned on eicfdcn35: use the same keyABQIAAAAPnwEhDNdNs3kx2nW2Es5GRT1apVUF891Z07_t00B1qRQi77KhhTUOv9Qdye_uCBq9xS_yZ9IPLOGCQ

    Add the  GOOGLE MAPS and assign the above key and click on submit

    Obtaining a Google Maps API Key

    Open URL http://code.google.com/apis/maps/signup.html in your browser. Log in to Google with a google.com user id. Read the Terms & Conditions. Enter the URL of your web site. Click “Generate API Key”. Copy and store this key value in a safe place. Use this key value when creating tile layers in MapViewer.

    On some of the dashboard pages with maps, you might see the error Fail to load “/mapviewer/fsmc/jslib/oraclemaps.js”.
    An immediate workaround to this problem is to refresh the screen and the map should show up.
    To fix it permanently, make the following changes to the mapviewer configuration. Edit the file web.xml located under the folder
    /essdata1/OBIEE11g /Oracle_BI1/bifoundation/jee/mapviewer.ear/web.war/WEB-INF
    In this file, search for the string „mime‟. Insert the full tag shown below just after the first tag, as shown in the
    picture (tag to insert is highlighted)   
    js
    text/javascript
    </mime-mapping

     Removing drop-shadow effect on graphs

     By default, whenever a chart is created, there is a drop-shadow effect on it. This property makes it difficult to read some of the SampleApp charts. In order to turn it off this property, edit the file dvt-graph-skin.xml from the following location on your installation. 

    /essdata1/OBIEE11g/Oracle_BI1/bifoundation/web/msgdb/s_blafp/viewui/chart Edit the tag, add the attribute visualEffects=”NONE”. (Do not remove the rest of the contents in the file). After editing, the contents should look like this.

    <!– decimalDigitUsed is false here so that non-percentage pie slices do not pick up this value
    The DVTChartProcessor sets decimalDigitUsed to true if this is a percentage pie slice –>
    < 
    Path:/essdata1/OBIEE11g/Oracle_BI1/bifoundation/web/msgdb/s_blafp/viewui/chart

     Change /add the below tag to the  dvt-graph-skin.xml
    By default, whenever a chart is created, there is a drop-shadow effect on it. This property makes it difficult to read some of the
    SampleApp charts. In order to turn it off this property, edit the file dvt-graph-skin.xml from the following location on your
    installation.
    \InstallHome\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart
    Edit the tag, add the attribute visualEffects=”NONE”. (Do not remove the rest of the contents in the file). After  editing, the contents should look like this.
       <!– decimalDigitUsed is false here so that non-percentage pie slices do not pick up this value
            The DVTChartProcessor sets decimalDigitUsed to true if this is a percentage pie slice –>
      
    Save the file.
    Graph visualEffects=”NONE”
    Save the file.
     Login to the EM administration screen using the url http://localhost:7001/em (Replace the hostname and port number based on your setup). Use the login you created in BIEE installation to log in.
    Expand ‘Business Intelligence’ node on the left and choose Coreapplication.
    Click on the Overview Tab,
    Click on blue button „Restart‟ (or green button
    „Start‟) under the Manage System category, middle of screen,
    Click yes on dialog box to confirm the move. Wait for message that confirms successful restart.

       
    üNote

    If starting using EM is not successful and complaining about OPMNCTL not up, please follow starting process with OPMNCTL

    Start services using OPMNCTL

     This step is not required if you have started the services successfully using EM (previous step)
    Open a command prompt, navigate to /essdata1/OBIEE11g/instances/instance1/bin
     run “opmnctl status, this will show you status of all the OBIEE core services
    run “opmnctl startall” or “opmnctl stopall” depending on your need

    The list of possible users is given in section Error! Reference source not found.

     Verify the Spatial & Mapviewer connection

    Login to Answers.
    Go to Administration –> Manage Map Data.
    Click the “Layers” tab.
    Click the “Add Layer” link. The data source dropdown at the top should contain at least one entry, one of which should be “OBIEE_NAVTEQ_Sample”.
    Click the OBIEE_NAVTEQ_Sample entry. It should populate the listbox with all available layers in the data source “OBIEE_NAVTEQ_Sample”.
    Check the tabs “Background Maps” and “Images” and ensure that you can see “OBIEE_NAVTEQ_Sample” entry.

    OBIEE 11G RPD Issues

    OBIEE 11G  RPD Issues

    OBIEE 11g Enterprise Manager missing RPD upload functionality in EM.

    Error: OBIEE 11g: Error: “Stream Closed” Server Exception in Enterprise Manager during PPR, #13 .1)OBIEE 11G – Selecting ‘Coreapplication’ Reports ADF_FACES-60096 Error Message

    Solution:

    1. Delete the instance.jspx.xml file in folder $Middleware_home\user_projects\domains\bifoundation_domain\sysman\mds\partition1\ai\bi\mdssys\cust\user\USER_NAME where USER_NAME represents the user id of the user in question.
    2. Stop and re-start all services, including WebLogic. The instance.jspx.xml file will be recreated.

    OBIEE 11.1.1.6 New Features

    Oracle Business Intelligence Enterprise Edition 11.1.1.6 New Features

    Installation
    The installer for the Oracle BI client tools now also installs Catalog Manager


    Ability to Limit and Offset Rows Returned
    You can use the FETCH and OFFSET clauses to constrain the number of rows returned by the SELECT statement and to offset the returned rows by a given number. Both clauses are optional and can be used together, or independently.

    Identify Query Candidates with Oracle BI Summary Advisor
    If you are running Oracle Business Intelligence on the Oracle Exalytics Machine, you can use the Oracle BI Summary Advisor feature to identify which aggregates will increase query performance. Summary Advisor intelligently recommends an optimal list of aggregate tables based on query patterns that will achieve maximum query performance gain while meeting specific resource constraints.

    Integrate the Administration Tool with a Third-Party Source Control Management System
    As an alternative to using a MUD environment, you can choose to save your repository in MDS XML format and integrate the Administration Tool with a third-party source control management system.  

    Streamlined MUD Merge Process
    Repository developers using a multiuser development (MUD) environment can now merge and publish changes in a single step, rather than merging local changes and then publishing changes as two separate steps. They can also perform subset refreshes to perform incremental local merges with the master repository.

    Automated Repository Patching Process
    You can now use an option in the patchrpd command-line utility to enable automated patching without prompting for user input. In addition, new patching-specific rules are applied during patch merges.

    Support for Aggregate Persistence in a Cluster 
    You can now use the aggregate persistence feature in a clustered environment.

    FIRST_PERIOD and LAST_PERIOD Time Series Functions
    You can now use the FIRST_PERIOD and LAST_PERIOD functions to compute the first and last value of an expression using the chronological key rather than the primary level key. 

    Aggregate Persistence usage:Utility is used for creating, modelling and populating aggregate tables available in OBIEE 10g and 11g. This utility is especially useful to quickly build a single aggregation layer upon federated heterogeneous physical sources.  OBIEE will create, model and populate aggregate dimensions and facts based upon the intelligence you have built into the RPD. This avoids re-writing the same logic into your ETL.

    For this walk through, you will need a physical database connection where you can create and populate tables and the OBIEE Scheduler to schedule the automatic creation of aggregates.


    Ability to Print the Physical and Business Model Diagrams
    You can now use Print Preview and Print to view and print the Physical and Business Model Diagrams in the Administration Tool.

    New Configuration Elements for Prompts and Custom Links
    You can use new configuration elements to affect the following:
    - How users work with prompts on dashboard pages
    - How you add custom links for users

    Changes in the Interface for Fusion Middleware Control
    Various changes were made in the user interface for Fusion Middleware Control:
    -          View System Component Availability”
    -          Identify Single Points of Failure
    -          Configure Primary and Secondary Instances
    -          View Log Information, Error Messages, and Alerts
    -          Log File Rotation Policy and Specifying Log Levels

    Enhancements to Full-Text Search
    The way that you configure for users to perform a full-text search has been enhanced.

    Configuration Settings for Analyses and Dashboards
    New configuration settings are available for working with analyses and dashboards.

    Configuration Settings in NQSConfig.INI
    The NQSConfig.INI file for the Oracle BI Server now includes the settings that are described in the following sections. Some of these sections have enhanced documentation from the previous release:
    - “MAX_EXPANDED_SUBQUERY_PREDICATES”
    - “FMW_UPDATE_ROLE_AND_USER_REF_GUIDS”
    - “SUMMARY_STATISTICS_LOGGING”
    - “SUMMARY_ADVISOR_TABLE_NAME”

    New Catalog and Home and Header Privileges
    These privileges determine which users can search the catalog, what functionality displays in the Oracle BI EE global header, who can access the Home Page and Catalog page, and who can see custom links in the global header and Getting Started area of the Home Page.

    Auto-Complete Functionality for Prompts
    This release contains auto-complete functionality for prompts. When enabled by the administrator, auto-complete suggests and highlights matching prompt values as the user types in the prompt selection field. Auto-complete can be excluded or included on dashboards, and users can turn auto-complete off for their accounts.

    Optional Apply and Reset Buttons for Prompts
    You can show or hide a prompt’s apply and reset buttons. If the designer chooses to hide the apply button, then the specified prompt value is immediately applied to the dashboard or analysis.

    Miscellaneous Prompts Enhancements
    The following prompts enhancements were added:
    - The prompt Reset button now provides three reset options: Reset to last applied valuesReset to default values, and Clear All.
    - In the “Dashboard builder”, the dashboard designer can add the Edit and Copy links to the dashboard’s prompts. These links will display at run time, and users
    with the proper privileges can click them to edit the prompt or copy the prompt’s link.
    - The row-based layout prompt option was added to the prompt editor’s “Definition pane”. As a result, you can now specify a row-based or column-based layout for your prompts. 

    Favorites
    This release introduces Favorites, which allows you to bookmark as favorites the catalog objects that you view regularly or want to view again at another time. You can use the “Manage Favorites dialog” to organize your favorites into categories, and you can view your favorites list and open your favorite objects from the global header’s Favorites menu.

    Customizable Global Header and Get Started …. Section of the Home Page
    The order of the links on the global header can now be customized, and links to external locations can be added to the global header. The Get Started… section of the home page can also be customized to meet the informational needs of the users. The Administrator implements these customizations and when users log into Oracle BI EE, they will see these customizations.

    Oracle BI Client Installer Option Added to the Home Page
    A link to the Oracle BI Client Installer has been added to the Download BI Desktop Tools option, which is located in the Getting Started… section of the Home Page.  User’s with the proper privilege can click this option to download and install the Business Intelligence Administration Tool and the Oracle Business Intelligence JobManager.

    Integrated Full-Text Search Capabilities 
    This release provides a fully integrated full-text search. This search is available after the administrator integrates Oracle BI Enterprise Edition with Oracle Secure Enterprise Search. This method of searching allows the user to find objects by searching on their attributes such as author and column name.

    Ability to Set Accessibility Mode in the Sign In Page
    In this release, the “Sign In page” has been enhanced to include the Accessibility Mode box, which allows you to specify whether you want content for Oracle BI EE to be rendered in a browser in a way that facilitates the use of a screen reader.

    Enhancement to Oracle Scorecard and Strategy Management
    This release includes the addition of a contribution wheel diagram to a strategy tree, which allows you to view an objective and its supporting child objectives and KPIs hierarchically in a circular diagram.

    Enhancements to Map Views
    In this release, map views have been enhanced in various ways:
    - You can include non-BI layers on a map view
    - You can use the marquee zoom feature to zoom into a specific area of the map View 

    Enhancements to Selections
    The release includes the following enhancement to selections:
    - The ability to include selected members in hierarchy selections steps that are based on family relationships.
    - The addition of Siblings of and Leaves of options in family relationships.
    - If the content designer adds a selection step that includes a condition with a qualified data reference (QDR), the QDR now displays in the Selection Steps pane.
    - The “All X values where Y = values” condition type was added. This condition type is available for attribute columns and hierarchical columns. The Column field was added to the New Condition Step dialog for this condition type.

    Enhancements to Views
    This release includes the following enhancements to views:
    - The ability to rename views and compound layouts.
    - The Selection Steps view was added. This view when added to an analysis, displays the selection steps in effect for the analysis.

    Enhancements to Tables and Pivot Tables
    In this release, tables and pivot tables have been enhanced to allow you to:
    - Select the measure on which to sort a column in a pivot table.
    - Specify how columns that are added to an analysis from the “Analysis editor: Criteria tab” after displaying the analysis results are handled.
    - Additional interactions on the right-click menu, for example, Include columnShow Running Sum, interactions for selection steps, and so on.
    - The ability to specify which interactions (for example, Drill) are available when you right-click in an analysis or a dashboard at run time. 

    OBIEE FAQ’S

    OBIEE
    OBIEE stands for Oracle Business Intelligence Enterprise Edition. It is a complete suite of enterprise products of BI. This is mainly used for Analysis and reporting solutions. Oracle BI EE Plus bundles Oracles Hyperion’s reporting products and this is mainly for integrating oracles Hyperion financial applications.
    OBIEE Advantages:
    There are many benefits / advantages of using OBIEE tool over other.
     1)Excellent Business Intelligence (BI) functionality built on a unique infrastructure that includes Interactive dashboards, Complex queries, Analysis, quite intelligent deliver and alerting system, financial reporting, Online Analytical processing (OLAP), Presentation, Huge volume reporting in production environment, and integrated with Microsoft. 2) It provides good in depth insight to every one in the organization depending on their role. 3) Unified Business model as it is built on enterprise infrastructure. 4) Integrates very easily with any data source, extraction, transformation, ETL tool, major business application, application server, security, portal, and many other front end tools and also from database side, can integrate with IBM’s DB2, Teradata, sql server, SAP business information warehouse BW, flat files, xml etc.., . 5) Customer have flexible change management system, such as leverage the compliance of SOX acts (Sorbanes oxley). 6) Good performance.

    What is Repository in OBIEE
    Repository is one important term in OBIEE. It basically stores the meta data information. Each meta data repository will store many business models.

    OBIEE LIFECYCLE

    Requirements gathering.Identification of source systems.We need to design The ETL for loading into Data warehousing if the source system is not available.Building a repository.Building the dashboard.Defining the security.For performance, decide on aggregations / catching mechanism.And finally quality( testing / QA)If we have more than 1 fact table and dimensions, then how would you connect them?In this case we creat a Logical table (fact table) in BMM layer and then we connect the other fact tables as logical source. And then to the logical table we conenct the dimensions.What is connection pool? Connection pool is a must for all physical databases. Connection pool contains information regarding the connection to the database.We can have multiple connection pools to avoide waiting and for better performance.

    What is meant by a connection pool? When do we create multiple connetion pools and why?
    Each database connection that is established from the application and the corresponding information regarding the connection and link is stored in the connection pool. Physical tables and databases are many in an application and we will be dealing with quick fetches for every instance of every database. In such a case we create multiple database connection pools. This will increase the interactivity as there are different connection pools for different database accesses.

    Alias Tables
    Alias tables is also a physical table but with the type of Alias. It is basically a reference to the logical table source and it will inherit all the column definitions of the logical table source. An Alias can a be a reference to any of the logical source systems such as stored procedures, physical tables, sql statements etc..Alias tables are very important in designing a physical layer.We use Alias table when we need to use an existing table more than once.If you know sql inner joins, you will understand easily, how we use there same table like sales a, sales b.Also we use alias tables when we need to use different column names, keys, joins etc..To help star or snowflakes structures in the Business model layer.


    1.Explain the Architecture of OBIEE And How what each components do?
    Answer :- OBIEE Consists of Presentation Services(Web),Oracle BI (Analytics Engine) Server
    The client (Answers) constructs sql and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) parses the physical sql to the Datasources and retrieve the data back to the Engine and presents to the presentation Services .
    2.how to get sql from obiee for reports?
    Answer :- There are many ways to get the sql
    a. Modify the request and click Advanced in that you get xml code and also the actual sql.
    b.In the catalog Manager click Tools –>Create Report .In the Create Report Window –> Click Request SQL and save the sql to the physical path in your PC.
    c.Enable Loglevel to 2 in the OBIEE Admin Tool from Mange-> Security and enable the log level to 2 by clicking properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.
    d. by clcking Administration->Manage sessions-> view sql
    3.How will you tune the SQL in Oracle if you find nested loops in the explain plan!
    4. How will you do sort in Reports in OBIEE Answers.
    Answer :- click modify and then click sort (order by icon) on the relevant column in the criteria pane.
    5. How will you do different types of narrative Reports in OBIEE?
    Answer:- By clicking modify request and Narrative View and by giving @1 for the first column result and @2 for the 2nd column and son on and we can also give a heading for No Results by clicking the Narrative view.
    6.How will you create Interactive Dashboards ?
    Answer:- By clicking Administration and Manage dashboards and by adding column selector also by using view selector etc.and also by using prompts.
    7.what is write-back in obiee ?
    Answer:-In Reports of Answer you can give a column as updatebale and then view the reports,this option is called write back.
    8.How will you execute Direct SQL in OBIEE?
    Answer:-By clicking Direct Database Request below the subject area in Answers.
    9.how will you create report from two subject areas
    Answer:- From the Criteria Pane of the Report Created from First Subject Area
    come to the bottom of the page and click combine request. but the options are limited for combining like union etc..
    10. What is the most tough issue you have faced while developing reports?
    11.How will you Port changes for dashboards,reports,rpd from development to production?
    Answer:- for the rpd use the Merge option in Admin Tool and for dashboards and reports use Content Accelerator Framework.
    12.What are the different types of variables in OBIEE? explain
    Answer:-There are two types of variables in obiee.
    a.Repository variable.
    This variable is for the whole repository.
    b.session variable . session variable can be system variable and non system variable. system variable uses NQ_SESSION. —- (system reserved variable). examples of non system variables are user defined filters etc.
    13.How will you enable or disable caching in the system level and table level.
    Answer:-In the NQSConfig.ini file use ENABLE under CACHE Section for System Level
    for tables .If you want to enable the cache at table level , open the repository in offline mode(not the current working repository). this should be different from the current repository and click enable or disable the cache . right click the table and properties and click the cache or deselect the cache. then merge the repository with the current working one.
    14.How will you go about adding additional column to the repository in the presentation layer.
    Answer :- check whether the table is already existing if so add in physical layer ,then BMM and then Presentation layer, then reload server metadata ,then it will be visible to all users.
    15.How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
    Answer:-using session variables for that user.
    16.what is a table alias in obiee? and where and how will you create it.
    Answer:- Table alias can be created by right clicking the table in the physical layer then click alias,
    Table alias is mostly used for creating self joins.
    17.Have you created Hierarchy in obiee. if so where and how?
    Answer:-Yes we can create hierarchy in BMM Layer of obiee in dimensions for the dimension tables. this can be done by right clicking the dimension table and click create dimension and then we should manually define the hierarchy and its levels.
    18.What is Level Based Metrics.How will you create it?
    Answer:-Leval-base matrics means, having a measure pinned at a certain level of the dimension. Monthly Total Sales or Quarterly Sales are the examples.
    To create a level based measure, create a new logical column based on the original measure (like Sales in the example above). Drag and drop the new logical column to the appropriate level in the Dimension hierarchy (in the above example you will drag and drop it to Month in Time Dimension.
    19.what are the different layers of OBIEE Repository?
    Answer:-a.Physical Layer,b.Business Model and Mapping Layer,c.Presentation Layer
    20.What is Authentication? How many types of authentication.
    Answer:-Authentication is the process by which a system verifies, through the use of a user
    a. Operaing system autentication
    b. External table authentication
    c. Database authentication
    d. LDAP authentication
    21. What are the different types of security you have worked in obiee?
    Answer :- Object Level and data level
    22.what is a bridge table ?
    Answer:- If you want to connect two tables where there is no relation ship you can use a thrid bridge table for connecting them which will have common columns in both tables, this is used in BMM Layer.
    23.You come Morning to the office. and all the users are complaining about the obiee reporting system is very slow(dasboards). what is your approach to resolve the issue?
    Answer:- Mainly check NQServer.log and in Admin Tool -> click Session Manager. check if there is any bottleneck and accordingly resolve.
    24.What are the different Log files in OBIEE?
    Answer:-NQServer.log , NQQuery.log,NQSAdminTool.log — mainly.25.Name few Configuration files in obiee.
    25.What are the Key Configuration Files in OBIEE?
    Answer:- NQSConfig.ini,NQSCluster.ini,odbc.ini,instanceconfig.xml
    26.How will change port of obiee answers?
    by changing its port in instanceconfig.xml
    27.What is ClusterServices in obiee ? why its used?
    Answer:-To Scale up the Performance by clustering and distributing the services across multiple Servers ClusterServices are used.
    28.Can you Change the location of the OBIEE Repository?
    Answer:- Not in Standalone OBIEE Install. you can give shared location in NQSCluster.ini if the OBIEE is clustered.
    29.How many BI Services Node can be clustered together?
    Answer :- 16
    30.Can you run multiple rpd’s in a Single OBIEE Instance?
    Answer :- No . you should create another instance in the same server , then its possible.
    31.How will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
    Answer:- Using Security Manger in OBIEE Admin Tool, by creating two user groups and allowing only part of the subject area for one group and other part to the other user group.
    32.What is SCD type 1 and 2.
    Answer:- SCD is slow changing dimensions. in type 1 we replace the changed dimension with old dimension. in type 2 we use surrogate keys and keep both the records(rows). Advantage of SCD2 is we keep history of the old dimensiont.
    33. What is Star Schema and What is SnowFlake Schema
    Answer:- Star is one fact and many dimensions where as Snowflake design is one fact and many dim’s and dim’s can have additonal dim relations.
    34.How to startup obiee in Linux?
    Answer:-
    ./run-sa.sh start #starts obi server
    ./run-saw.sh start #start saw server
    ./run-sch.sh start #start scheduler
    35.What are key differences between obiee 10g and 11g.
    OBIEE11g vs OBIEE 10g  RPD and webcatalog Deployment:
    In obiee11g is different from obiee10g deployment procedure In Obiee11g deployment is  via Weblogic Enterprise Manager option. but in obiee10g just change it instanceconfi.xml and NQSCOnfig.ini file then restart(this all steps are now taking care by weblogic EM)


    36.What are iBots in OBIEE 10g?

    iBots are intelligence agents or Bots. These agents are triggered by a schedule or condition that in turn generates a request to perform analytics on data based upon defined criteria.

    37.)Where do iBots originate from? 
    How do iBots work?

    Oracle BI Delivers is the application to create, modify and manage iBots.

    In order to understand how an iBot works, we should start by first creating a new iBot from scratch.

    Navigate to “Delivers” ……


    …..and click the link to create a new iBot.

    From here, we will tackle each individual tab to get an understanding of what the process is to create an iBot.

    1) Overview tab

    This view is a summary of the current settings for the selected iBot.

    One can navigate to specific settings by clicking on the links in the summary or clicking on the tabs located at the top.

    2) General tab


    This is where the priority of the iBot and how to send the delivery content are set.

    The priority options are low, normal, or high. The priority works with the delivery profile for a user to determine the destination for alerts of different priorities.

    The following Data Visibility options affect the customization of the delivery content:

    Personalized (individual data visibility)

    - uses the data visibility of each recipient to customize iBot delivery content for each recipient. Note that The Run As field if not available.

    Not personalized (use the Run As user’s data visibility): 
    - sends the iBot’s delivery content to the specified recipients. All users receive the same content as if they were the user specified in the Run As field.

    Not personalized (use iBot owner’s data visibility):
    - sends the iBot’s delivery content to the specified recipients using the data visibility of the specified user (Run As box field) who created the iBot. In other words, all recipients will receive the content that’s viewable to the Run As user.


    3) Conditional Request tab


    This page is used to select a request to trigger the iBot. The results of the conditional request determine whether the iBot sends its delivery content and initiates any subsequent actions:

    - If the request does not return any rows, the iBot is not triggered.

    - If the request returns at least one row, the iBot sends its delivery content and initiates any subsequent actions.

    Requests can be chained together to create complex conditional logic.

    4) Schedule tab

    iBots can be executed based on a specified schedule. You can define a starting date and time for the iBot, a recurrence schedule, and an ending date.

    5) Recipients tab

    Use this tab to select the users and groups to receive the delivery content of the iBot.

    One has the ability to select specific individual users and groups to receive the contents of the iBot.
    **You can select multiple users by holding down the SHIFT or CTRL keys and selecting adjacent or nonadjacent users.**

    Also, one can select which users or groups can subscribe to the iBot. This allows users the flexibility to receive and view the contents of the iBot AND customize prompted filter values for columns.

    Keep in mind that in order to publish iBots, the content must be shared.


    6) Delivery Content tab

    Use the Delivery Content tab to specify the type of content to deliver with the iBot, such as a
    dashboard page or a saved request. The delivery format for the content can also be selected, such
    as HTML, PDF, XLS, CSV, or text.

    The contents of the Headline field will appear as the subject of the request.

    The two field text boxes below allows one to attach a message when the iBot is delivered depending on if the iBot is delivered as an attachment or if there are no records returned by the conditional request.

    7) Destinations tab

    The User Destinations and Specific Devices portions of this tab are pretty self explanatory.

    As for System Services…

    Oracle BI Server Cache is used for seeding cache.

    (** To have the cache created for individual users, the Personalized option for data visibility in the General tab must be selected.)

    Disconnected Application Cache is only available to companies that have licensed Disconnected Analytics.

    (** To have the disconnected application cache created for individual users, the Personalized(individual data visibility) option for Data Visibility in the General tab must be selected.)

    (**Nonpersonalized data is not used for Disconnected Analytics users.)
    8) Advanced tab


    Use the Advanced tab to specify one or more actions to execute after the iBot is finished running.

    Actions include the execution of other iBots, custom scripts, custom Java programs or Workflows.
    For further reading on iBots, I would suggest downloading the Oracle Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide to read further about creating iBots. What I provided is just a brief glimpse of iBots.

    (http://download.oracle.com/docs/cd/B40078_02/doc/bi.1013/b31767.pdf)

    OBIEE 10g Architecture

    OBIEE 10G – Architecture

    Oracle Business Intelligence components

    The Oracle Business Intelligence components consist of:
    The Oracle Business Intelligence Presentation Services provides the framework and interface for presentation of Business Intelligence data to web clients. It maintains a Presentation Catalog service on the file system for the customization of this presentation framework. It is a standalone process and integrates with the Oracle Business Intelligence Presentation Services Plug-in from which it receives web client requests. It communicates with the Oracle Business Intelligence Server using ODBC over TCP/IP.
    The Oracle Business Intelligence Server is a stand-alone process that maintains the logical data model which it provides to BI Presentation Services via ODBC. Metadata is maintained for the data model in a local proprietary file called the repository file (rpd). On the back-end, the BI Server connects to customer data stores via data source adaptors.
    The Oracle Business Intelligence Scheduler is an extensible scheduling application for scheduling reports to be delivered to users at specified times. It is the engine behind the Oracle Business Intelligence Delivers feature.
    The Oracle Business Intelligence Publisher generates highly-formatted, pixel-perfect enterprise reports.
    The Oracle Business Intelligence Javahost provides services to BI Presentation Services for Charts, Gauges and PDFs. The services are provided based on request-response model.
    The Oracle Business Intelligence Presentation Services Plug-in is the entry point for web client requests to BI Presentation Services.
    The Oracle BI Presentation Services, Oracle BI Client, and Oracle BI Server components can be installed to run on separate machines.

    Articles Related

    OBIEE Architecture

    Correspondence Between Old Siebel and New Component Names

    Old Name New Name
    Siebel Analytics Server Oracle Business Intelligence Server
    Siebel Analytics Web Server Oracle Business Intelligence Presentation Services
    Siebel Analytics Scheduler Oracle Business Intelligence Scheduler
    Siebel Answers Oracle Business Intelligence Answers
    Siebel Delivers Oracle Business Intelligence Delivers
    Siebel Intelligence Dashboards Oracle Business Intelligence Interactive Dashboards
    Siebel Analytics Web Catalog Oracle Business Intelligence Presentation Catalog
    Siebel Analytics Catalog Manager Oracle Business Intelligence Catalog Manager
    Siebel Analytics Server Administration Tool Oracle Business Intelligence Server Administration Tool
    Siebel Disconnected Analytics or Mobile Analytics Oracle Business Intelligence Disconnected Analytics
    Siebel Open Intelligent Interface Oracle Open Intelligence Interface
    Related component programs: Related component programs:
    Chart image server Chart image server
    Siebel Analytics Client Tools Oracle Business Intelligence Client Tools
    Siebel Analytics ODBC Client Oracle Business Intelligence ODBC Client
    Siebel Briefing Book Reader Oracle Business Intelligence Briefing Book Reader
    Siebel Business Analytics Briefing Books Oracle Business Intelligence Briefing Books
    Siebel Analytics Microsoft Excel add-in Oracle Business Intelligence Microsoft Excel add-in
    XML Publisher Oracle Business Intelligence Publisher