OBIEE11g: September 2011

Friday, September 23, 2011

OBIEE 11g Installation and Configuration Steps

Oracle Business Intelligence11g System Requirement

This section contains important information for the system on which you are installing Oracle Business Intelligence11g and the database (MS SQL Server) containing the schemas.requirements: requirements:

Hardware

Disk Space: 20GB or more

Physical Memory: 4GB or more

Available Memory: 1GB or more

Temp Space: 950MB or more

Swap Space: 3GB or more

CPU & Processor: dual-core Intel 32/64 Bit, 2.10GHz or greater

Monitor Display : requires 1024 x 768 minimum resolution
Software Operating System: Windows Xp/Vista/Server 2003/ above with SP2 or higher version
Microsoft Internet Explorer 8.0 above
Microsoft .Net Framework 4.5 SP2 or above version
Static IP Address Required (i.e.: DHCP to access network install Look Back Adopter)
JDK 1.6 or above version
MS SQL Server 2005/2008 Enterprise Edition 32/64 bit
OBIEE 11g (11.1.1.3.0) Version
RCU 11.1.1.3.0 (Repository Creation Utility ) database schema creation

Note By default, TCP/IP properties are configured to use DHCP.

　
　OBIEE 11g Download Link:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls

Note: Make sure database repository must be created before installation of the components with the Repository Creation Utility (RCU) tool

Database Requirement
Below are the recommended disk space requirements for the database containing the Oracle Business Intelligence Scheduler database tables
500MB Microsoft SQL Server databases for standalone and Business Intelligence applications and deployments
OBIEE 11g and Weblogic Disk Space Requirement
The following list identifies memory requirements for various components.
Use the list as a guideline for determining the memory requirements specific to your
deployment:
WebLogic Administration Server: 750 MB
WebLogic Managed Server running Oracle Directory Integration Platform and
Oracle Directory Services Manager: 720 MB
WebLogic Managed Server running Oracle Identity Federation: 650 MB
Oracle Internet Directory: 75 MB
Oracle Virtual Directory: 105 MB
Oracle Enterprise Manager (EM) Agent: 25 MB
Oracle Process Manager and Notification Server (OPMN): 5 MB
Oracle Identity Management requires 2,200 MB of disk space if you are only installing the software (you select the Install Software - Do Not Configure installation type). If you configure the software, an additional 150 MB of space are required if all components are selected for configuration.

RCU Supported Platforms:
RCU is available only on 32-bit x86 Linux and 32-bit Microsoft Windows operating system platforms. You can run RCU from these machines to connect to any certified versions of Oracle, IBM DB2, or Microsoft SQL Server database in order to create the schemas required by Fusion Middleware components. The database server can be running on any platform that is supported by its respective database.
RCU Schema Creation through MSSQL Server Script :
Note: don’t create short cut database/table creation because you can’t able to succeeded on Metadata configuration in your RCU DB Schema

USE [master]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
GO SQL_Latin1_General_CP1_CI_ASEXEC
GO dbo.sp_dbcmptlevel @dbname=N’OracleBI’, @new_cmptlevel=90IF (1 = FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’))begin
EXEC [OracleBI].[dbo].[sp_fulltext_database] @action = ‘disable’endGOALTER
GO DATABASE [OracleBI] SET ANSI_NULL_DEFAULT OFF ALTER
GO DATABASE [OracleBI] SET ANSI_NULLS OFF ALTER
GO DATABASE [OracleBI] SET ANSI_PADDING OFF ALTER
GO DATABASE [OracleBI] SET ANSI_WARNINGS OFF ALTER
GO DATABASE [OracleBI] SET ARITHABORT OFF ALTER
GO DATABASE [OracleBI] SET AUTO_CLOSE OFF ALTER
GO DATABASE [OracleBI] SET AUTO_CREATE_STATISTICS ON ALTER
GO DATABASE [OracleBI] SET AUTO_SHRINK OFF ALTER
GO
ALTER
GO DATABASE [OracleBI] SET CURSOR_CLOSE_ON_COMMIT OFF ALTER
GO DATABASE [OracleBI] SET CURSOR_DEFAULT GLOBAL ALTER
GO DATABASE [OracleBI] SET CONCAT_NULL_YIELDS_NULL OFF ALTER
GO DATABASE [OracleBI] SET NUMERIC_ROUNDABORT OFF ALTER
GO DATABASE [OracleBI] SET QUOTED_IDENTIFIER OFF ALTER
GO DATABASE [OracleBI] SET RECURSIVE_TRIGGERS OFF ALTER
GO DATABASE [OracleBI] SET DISABLE_BROKER ALTER
GO DATABASE [OracleBI] SET AUTO_UPDATE_STATISTICS_ASYNC OFF ALTER
GO DATABASE [OracleBI] SET DATE_CORRELATION_OPTIMIZATION OFF ALTER
GO DATABASE [OracleBI] SET TRUSTWORTHY OFF ALTER
GO DATABASE [OracleBI] SET ALLOW_SNAPSHOT_ISOLATION OFF ALTER
GO DATABASE [OracleBI] SET PARAMETERIZATION SIMPLE ALTER
GO DATABASE [OracleBI] SET READ_WRITE ALTER
GO DATABASE [OracleBI] SET RECOVERY FULL ALTER
GO DATABASE [OracleBI] SET MULTI_USER ALTER
GO DATABASE [OracleBI] SET PAGE_VERIFY CHECKSUM ALTER
GO DATABASE [OracleBI] SET DB_CHAINING OFF ALTER

GO
DECLARE
SELECT @collate sysname @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)ENDGO

Go to path like this C:\Deva\ofm_rcu_win32_11.1.1.3.3_disk1_1of1\rcuHome\BIN
\RCU.MS-DOS Batch File type

II) Unzip the RCU zip file into some directory and run the rcu.bat under BIN directory. Make sure your database is up before running the RCU; this will install the BI and Metadata schema. database [OracleBI] SET READ_COMMITTED_SNAPSHOT ON DATABASE [OracleBI] SET AUTO_UPDATE_STATISTICS ON
GO

Wednesday, September 21, 2011

Unable To Create Session Variable Using Obiee 11.1.1.5 Admin Tool issue

Hi,

An interesting thing happen, when I was trying to choose a connection pool for creating a Session variable Init Block , connection pool Select button was disabled. This functionality worked in 11.1.1.3. Just to avoid any doubt I restarted admin tool, followed by machine restart, but end result didn’t change. After looking around, I remembered that in one of the metalink they talked about “Allow First Connection for init block”. I tried that option and it work . Below are the details ::

Issue :

Select button is disabled when trying to choose a connection pool for creating a Session variable Init Block

Solution:

Check “Allow First Connection for init block” to true

For setting “Allow First Connection for init block” follow below steps :

In the Administration Tool, select Tools, then select Options to display the Options dialog.

On the General tab, select ”Allow First Connection for init block. (this option is not a best practice and might cause performance issues.)

THanks

DEva

Unable To Export All Rows from a Request to csv, pdf Or Excel In Obiee 11g

Hi,

To implement the solution, please do:

1. Change instanceconfig.xml file in <biee11g_install>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 as following
<Views>
<Pivot>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>

<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Pivot>
<Table>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Table>

</Table>
</Views>

3. Note the new elements added are the following to both <Pivot> and <Table>, the Pivot part controls Pivot view, and Table part controls Table View, my testing was done with Table View.
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

4. Restart Presentation Server from EM, then run your request, do pdf export to verify.

Note:

When a table or pivot table includes a large number of rows, a set of buttons can be displayed under the view. You can use the following buttons to page through the rows in the view:

•First 25 Rows — Displays the first 25 rows of data for the view. The number that is used for the First, Previous, and Next buttons is specified by the Rows per Page field in the "Table Properties dialog: Style tab".

•Previous 25 Rows — Displays the previous 25 rows of data for the view.

•Next 25 Rows — Displays the next 25 rows of data for the view.

•Display maximum (500) rows per page — Allows you to display as many as the maximum number of rows per page at one time temporarily. The default is 500. The administrator can specify a different maximum value that is displayed on the tooltip for the button using the MaxVisibleRows element in the configuration file.

THanks

DEva

Monday, September 19, 2011

Displaying External Documents on an OBIEE Dashboard

Hi,

OBIEE11g - setting external Document file(word,excel,pdf,txt..etc) 100% suiteblae
https://forums.oracle.com/forums/thread.jspa?threadID=2303372&tstart=0
for intro and overview...
http://total-bi.com/2011/02/external-files-obiee-dashboard/

link or imges dashboard object and Try like this

1) 1st upload it u r pdf files in catalog like below one
refer my screen short

http://imageshack.us/photo/my-images/28/step1updloadexteranlfil.jpg/

2) use dashboard objects --> link or image -->

refer my screen short
http://imageshack.us/photo/my-images/593/step2updloadexteranlfil.jpg/

URL Plath like this

http://1.1.1.1:9704/analytics/saw.dll?downloadFile&path=%2FShared%2FDOC%2Fobiee.pdf

100% it should work.

OBIEE10g verion below one ok, but lot of impact this version

Placing the image file in /l_en folder dint work for me too however you can place them inside the following paths and restart the services.

For more information:

https://forums.oracle.com/forums/thread.jspa?messageID=9878467&#9878467

FYI,
if you are using obiee10g version please look at the below path

Drive:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res
Drive:\OracleBI\web\res

Restart all services including oc4j

Thanks

Deva

Wednesday, September 14, 2011

OBIEE 11g (11.1.1.5.0) Software Only Installation on Windows Server 2008/2003/XP 64 bit SP1 &SP2

Hi,
for obiee11g download link (RCU , RPD admin client tool)

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html

fow weblogic download,

http://www.oracle.com/technetwork/middleware/ias/downloads/wls-main-097127.html

Hi All,

Kindly check your System IP (if its' Dynamic IP install lookback adaptor),windows hosts file (make sure IP correct )
Hardware Requirement:
1. Disk Space: 50GB or more
2. Available Memory: 4GB or more
3. Temp Space: 1GBor more
4. Swap Space: 3GB or more
5. CPU: dual-core Pentium, 1.5GHz or greater
Software Requirement:
1. OS: Windows Xp /win 7/win2008 sp2 above version 64 bit
2. Microsoft .Net Frame Work 3.5 SP2 above (not required it's only required Oc4j case)
3. OBIEE 11g latest Version(11.1.1.5.0) 64bit
4. RCU(Repository Creation Utility 11.1.1.5) 32 bit (before u need to execute RCU creation script)
5. MS SQL Server 2008 Enterprise Edition or Oracle 11g 64bit
6. jdk1.6.0_26 and above version 64 bit
Better to go with software only install
weblogic10.3.5.0 generic version win 64bit
and follow the doc step by step

Before going to install maksure certification matrix.
http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls

http://obieeelegant.blogspot.com/2010/12/hardware-and-software-system.html

Software download :
Refer the below link:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html
In the same link bottom you can find
RCU installer setup. (there is no 64bit rcu so u have use the same both)

For the web logic server download
wls1035_generic.jar

First you have extract it and run it in CMD propmt,

check it your disk space and select your drive and click next,

going forward click yes.

click it yes

Click it Yes, and next...

Select Typical option,

select your JDK installaed home path ...and click next,

click next ...keep it as it is,

Now, Weblogic server 10.3.5.0.installation done...sucessfully...

Next start your OBIEE11g with Software only install option...

skip it,

select "Software Only Install" and click next,

click next,

click next ...keep it as it is,

Uncheck mail things, click next

Click YES and Next,,

Next....

Click Next...

OBIEE11g - Software Only Install is over now ...then click finish it configurre OBIEE ..look at below steps...

after install software install option i will get like below kindl of path ...kinly look at ..below screen and double click config.cmd

Next...

give the OBIEE RCU domain and OBIEE username and Password

click next ...keep it as it is,

let say i have set it SQL server RCU connection string and MDS , BI Domain info look at below screen make it like this,

click next ...keep it as it is,

uncheck it and click next

obiee11g defaul RPD: password is Admin123 ,if you want to reset it , open RPD in offline mode and go to file menu then ..there is a option called Change/Reset password..change it and deployee it in EM.

Thanks

Deva