OBIEE Online Training

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

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 :
  1. In the Administration Tool, select Tools, then select Options to display the Options dialog.
  2. 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>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Pivot>
<Table>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<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

Tuesday, September 6, 2011

Clear/Remove OBIEE/SQL Server Services from Services.msc

Hi,
    
  deleting obiee11g services in windows services.msc by using below comment

c:/>sc delete "service name" that's all.


Second method,

You have to also delete the services registry entry using regedit
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services

FYI..Ref:

http://www.howtogeek.com/howto/windows-vista/how-to-delete-a-windows-service-in-vista-or-xp/

Thanks

Deva

Monday, September 5, 2011

logo and title in one line

Hi,

          In an Answres report, you can set logo and tittle in the same line please check the below line

fmap: image path

e.x:

fmap:{imagename.jpg}


Thanks

Deva