OBIEE Online Training

Tuesday, December 21, 2010

Configuring IBOTS

1.   The first step is to configure a schema that would hold all our scheduler tables. If you do not have a schema create or use an existing one. In my case i have a schema called S_NQ_SCHED wherein i would create all my scheduler tables.

OBIEE making a clear button

Found this piece of javascript in the new 10.3.4.0 version Sales example:



It clears all the user prompts edits and sets them back to their defaults.

{div class="XUIPromptEntry minibuttonOn"}{ href="#" onclick="return PersonalizationEditor.removeDefaultSelection(false)"}Clear{/a}{/div}

OBIEE - DSN Details

Here you will find those, OracleBI\xmlp\XMLP\Admin\DataSource\jdbcdefaults.xml
<?xml version = '1.0' encoding = 'UTF-8'?>
<jdbcDefaultValues>
<defaultvalue name="ORACLE"
description="Oracle 9i/10g/11g"
driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@[host]:[port]:[sid]" />
<defaultvalue name="ORACLE_OLD"
description="Oracle 8/8i"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@[host]:[port]:[sid]" />

OBIEE location of Images

please paste our Images to this path
==========================
C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\b_mozilla_4\bg_banner.jpeg
C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\b_mozilla_4\rtl\bg_banner.jpeg
C:\OracleBI\web\app\res\s_oracle10\b_mozilla_4\bg_banner.jpeg
C:\OracleBI\web\app\res\s_oracle10\b_mozilla_4\rtl\bg_banner.jpeg
C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\siebelbug.GIF
C:\OracleBI\web\app\res\siebelbug.GIF
C:\OracleBI\web\app\res\sk_oracle10\b_mozilla_4\bglogon.jpeg

XMLP Server Config File in OBIEE

<xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp">
   <property name="SUPERUSER_PASSWORD" value="9DA818F68E4267635CF12C4D7F8D735D5604B2C0BF22"/>
   <property name="SUPERUSER_USERNAME" value="Administrator"/>
   <property name="GUEST_FOLDER" value="false"/>
   <property name="SAW_SERVER" value="HEX-A0226CB62C8"/>
   <property name="SAW_USERNAME" value="Administrator"/>
   <property name="DISCO_PROTOCOL" value="http"/>
   <property name="SAW_VERSION" value="v4"/>
   <property name="ENABLE_SUPERUSER" value="true"/>
   <property name="BI_SERVER_SECURITY_ADMIN_PASSWORD_ENC" value="C880479C6E3F5AB991C643C0117DBEB9"/>
   <property name="BI_SERVER_SECURITY_ADMIN_USERNAME" value="Administrator"/>
   <property name="DISCO_PORT" value="9704"/>
   <property name="DEBUG_LEVEL" value="exception"/>
   <property name="BI_SERVER_SECURITY_URL" value="jdbc:oraclebi://HEX-A0226CB62C8:9704/"/>
   <property name="SAW_SESSION_TIMEOUT" value="90"/>
   <property name="BI_SERVER_SECURITY_DRIVER" value="oracle.bi.jdbc.AnaJdbcDriver"/>
   <property name="SAW_PROTOCOL" value="http"/>
   <property name="SAW_PORT" value="9704"/>
   <property name="DISCO_URL_SUFFIX" value="analytics/saw.dll"/>
   <property name="SAW_URL_SUFFIX" value="analytics/saw.dll"/>
   <property name="SECURITY_MODEL" value="XDO"/>
   <property name="DISCO_SERVER" value="HEX-A0226CB62C8"/>
   <property name="SAW_PASSWORD_ENC" value="C880479C6E3F5AB991C643C0117DBEB9"/>
</xmlpConfig>

OBIEE - filter header alignment Horizontal to Parallel

filter header alignment changes
=======
<style type = "text/css">
td.GFPFilter br {display : none}
</style>

Hardware and Software System Requirement for OBIEE 11g

1.0 Oracle Business Intelligence Requirements
This section contains important information for the system on which you are installing Oracle Business Intelligence and the database containing the schemas.
1.1 Installation System Requirements

Write Back

Write Back
Steps:
1)      Go to Repository à Physical Layerà table (which table u r going to give write back option) please uncheck cacheable option and save the changes.


2)      Go to Presentation layer -à Manage PrivilegeàGo to scroll down windows-à add Users/Administrator (who are all needs write back option) as mange write Back add Administrator. Finally click finish.

3)      Add XML File to this path  C:\OracleBI\web\msgdb\customMessages\WriteBack.xml  and


C:\OracleBIData\web\msgdb\WriteBack .xml   path.
File Name: WriteBack.xml
<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
<WebMessage name="WriteBack">
<XML>
<writeBack connectionPool="Connection Pool">
<update>UPDATE db_summary SET comments='@{c1}' WHERE location='@{c2}'</update>
<insert>INSERT INTO db_summary {comments} VALUES '@{c1}' </insert>

</writeBack>
</XML>
</WebMessage>
<WebMessage name="WriteBackNew">
<XML>
<writeBack connectionPool="Connection Pool">
<update>UPDATE report_comments SET comments='@{c1}' WHERE username='@{c0}'</update>
<insert>INSERT INTO report_comments {comments} VALUES ('@{c1}') </insert>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>

Note: It’s all are case sensitive and red lined letters are give as above. After that restart all the OBIEE Server (Java Host, OC4J, BI Server etc.)
Note1: As Button Text in Presentation Layer :system="WriteBack"  and
As Template Name in Presentation Layer : <WebMessage name="WriteBackNew">
 4)      Choose value Interaction Type as Writ Back and field size like give screen



5)      Look at the given screen and enable the writeback option and give the Write Back Button name as per the WritBack.xml file.
6)      Finally I will get like this kind of screen ,write u r  comments on this text field and click WriteBack Button it will save in the Data base back end operation.

In DB result will be,




OBIEE 11g - RCU Schema Creation through SQL Cripts

USE [master]
GO
CREATE DATABASE [OracleBI] ON PRIMARY
(NAME = N'OracleBI', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\OracleBI.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'OracleBI_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\OracleBI_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'OracleBI', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [OracleBI].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [OracleBI] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [OracleBI] SET ANSI_NULLS OFF
GO
ALTER DATABASE [OracleBI] SET ANSI_PADDING OFF
GO
ALTER DATABASE [OracleBI] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [OracleBI] SET ARITHABORT OFF
GO
ALTER DATABASE [OracleBI] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [OracleBI] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [OracleBI] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [OracleBI] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [OracleBI] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [OracleBI] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [OracleBI] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [OracleBI] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [OracleBI] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [OracleBI] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [OracleBI] SET DISABLE_BROKER
GO
ALTER DATABASE [OracleBI] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [OracleBI] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [OracleBI] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [OracleBI] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [OracleBI] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [OracleBI] SET READ_WRITE
GO
ALTER DATABASE [OracleBI] SET RECOVERY FULL
GO
ALTER DATABASE [OracleBI] SET MULTI_USER
GO
ALTER DATABASE [OracleBI] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [OracleBI] SET DB_CHAINING OFF
GO
ALTER database [OracleBI] SET READ_COMMITTED_SNAPSHOT ON
GO
DECLARE @collate sysname
SELECT @collate = convert(sysname, serverproperty('COLLATION'))
IF ( charindex(N'_CI', @collate) > 0 )
BEGIN
select @collate = replace(@collate, N'_CI', N'_CS')
exec ('ALTER database OracleBI COLLATE ' + @collate)
END
GO



Sunday, December 5, 2010

OBIEE 11g 1st day

Hi,
        Required Software for OBIEE 11g installation,

1) JDK 1.5 above version
2) RCU ( Repository Creation Utility)
3) OBIEE 11g version
4) .Net frame work 2.0 above version
5) IE 6.0 above version
6) PDF installar and MS Office 2007 version

Rds,
Deva