Oracle BI 11gR1 Client Tools Installation

One of the major pain points with OBIEE 11g was the installation. As a developer, one has to install the whole suite to be able to work with the systems. Even if a company has development environment setup in a data center, all the developers had to install  the whole suite on their local machine to be able to do any modeling.
As we know the install is not trivial, and takes up a lot of disk and process space.
OBIEE 11g Client Tools

Recently Oracle released the "Client Tools" Only installation package which will allow developers to install the following components:

The install is pretty simple and only asks a couple of things - the install directory and the place you want your shortcut icons to reside.

When complete, you can run the "RPD Administrator tool" and a "Job Manager" on your local machine without having the whole OBIEE deployed.

There is no 64bit support for this package.

Sachin
JainSys

OBIEE - 11g Inbuilt Mapping and Spatial capability - Setup BI Presentation Part III

I was finally able to fix the issue by creating a container managed datasource in weblogic and then use it in mapviewer

http://download.oracle.com/docs/cd/E12840_01/wls/docs103/ConsoleHelp/taskhelp/jdbc/jdbc_datasources/CreateDataSources.html

http://download.oracle.com/docs/cd/E14571_01/web.1111/e10145/vis_admin.htm#sthref973


Sachin
JainSys

20 things about the web and web browsers!

Another unique gem on "Internet"

20 Things I learned about the browser and the web!

Sachin
JainSys

Checklist to secure your computer and GMAIL accounts

While browsing, I stumbled across this nice article by Google support!

Gmail Security Checklist

Whether you just regained access to Gmail, or you want to make sure your account is secure, take a minute to complete our Gmail security checklist to make sure your mail security measures are up to date.

Some related books:

Sachin

JainSys

OBIEE - 11g Inbuilt Mapping and Spatial capability - Setup BI Presentation Part II

Sachin
JainSys Inc.

Continued from : OBIEE - 11g Inbuilt Mapping and Spatial capability - Setup BI Presentation server

I had to reboot the server to take care of some upgrades. When I restarted the server and fired up the BI services, my reports with the "map view" stopped working.
On further analysis I found that the MapViewerhas lost the configuration changes that were made to it including the DataSource configuration, and my system is no longer working.

When I try to recreate the Datasource I am getting an error:


Data source cannot be created : MAPVIEWER-00011: Error creating a map data source.


I am following up on this with Oracle Support and will update this post when I am able to restore the MapViewer settings.


In the mean while, please go through these documents:


Overview of MapViewer

Configuring Advanced Options for Mapping and Spatial Information

Oracle Spatial Developer's Guide.

OBIEE - Configuring Mapping and Spatial Information

Fix for the error.

Thanks!


Sachin
JainSys Inc.

OBIEE - 11g Inbuilt Mapping and Spatial capability - Setup BI Presentation server

Continued from -> OBIEE - 11g Inbuilt Mapping and Spatial capability - Setup MapView

After you have configured and tested the MapViewer, log into the BI Server and go to the Administration.

Click on the "Manage Map Data"

Click on the New Icon on the Layers Tab, and select all the Layers in the list box. Repeat for "Background Maps" and "Images" tables.



Continued...

Sachin
Architect - Oracle Engineered Systems
Exalytics/Exalogic/Exadata
BuzzClan LLC

BuzzClan is a business consulting company collaborating to provide Oracle software advisory services & implementation services. BuzzClan LLC is committed to providing substantive business value on each and every client engagement. We do this through a combination of industry-specific business expertise, technical skills, proven project management methods and our “onsite - off site - offshore” delivery model. We strive to work in partnership with our customers to build high-performance teams and create business solutions that will last.

OBIEE - 11g Inbuilt Mapping and Spatial capability - Setup MapView

Continuation from last post:
OBIEE - 11g Inbuilt Mapping and Spatial capability - Setup OBIEE

The next step is to setup the MapView component.

Download the sample mapping data from this link MVDemo, and follow the instruction in the included pdf file. This will create a sample spatial data which can be used to jump start the map implementation in reports.

Once the data dump is imported fire up the MapViewer configuration. Go to the EM and navigate to
Application Deployments > mapviewer(11.1.1)(bi_cluster) and click on the link under Web Modules.

It will take a few and the MapViewer configuration screen will come up.

Click on the Management tab on the right, and login if prompted (the userid/password will be the same as that of the weblogic admin).

Copy the configuration file, and paste on any text editor. Search for " <map_data_source name="
you will see a block like this:
<map_data_source name="mvdemo"
jdbc_host="your db host name"
jdbc_sid="your db sid"
jdbc_port="your db port"
jdbc_user="mvdemo"
jdbc_password="!mvdemo"
jdbc_mode="thin"
number_of_mappers="3"
allow_jdbc_theme_based_foi="false"
plsql_package=”web_user_info”
/>

replace the jdbc values as per your db setup. Leave the plsql_pacage value intact. for details, refer to the step II in the pdf that came along the demo files.

paste this back into the configuration file, and remove the comments, if any around this block. Click "Save & Restart". Once the server comes back, test the mapviewer by going to this link, and clicking "Submit" You should see a map.

http:/<your Server>:9704/mapviewer/demo/secure-mapping.html

Further reading: Oracle documentation - Introduction to MapViewer

Next - Step III Setup BI Presentation server



Sachin
Architect - Oracle Engineered Systems
Exalytics/Exalogic/Exadata
BuzzClan LLC

BuzzClan is a business consulting company collaborating to provide Oracle software advisory services & implementation services. BuzzClan LLC is committed to providing substantive business value on each and every client engagement. We do this through a combination of industry-specific business expertise, technical skills, proven project management methods and our “onsite - off site - offshore” delivery model. We strive to work in partnership with our customers to build high-performance teams and create business solutions that will last.