Thursday 4 April 2013

Wednesday 3 April 2013

Best of OBIEE 11.1.1.7–Smart View

 

This post is one of a series of brief posts on some of the “best of” features as judged by my humble self on the latest OBIEE release.

To start with, something that I have been hanging out for a long time: being able to directly create reports in Excel using the Oracle BI subject areas you have painstakingly built. In the past, the Oracle BI excel plugin only allowed you to import existing reports, but not access the Oracle BI semantic layer (Oracle BI Server) directly. Smart View solves this!

Good Youtube video on this:

http://www.youtube.com/watch?v=y2WSmnb—88

 

Smart View on Oracle BI

You can now create views directly from Excel onto the Oracle BI semantic layer using the Smart View plugin. The plugin can be downloaded from Home->Desktop Tools->Smart View link on the left hand side.

image

After you have installed Smart View, create a Private Connection to OBIEE from within Excel. Make sure to append /jbips to your usual OBIEE URL.

Eg. http://10.245.2.180:9704/analytics/jbips

image

SNAGHTML5e736e6

image

Aside from the the ability to import OBIEE analysis that have already been built into Excel, you can also create new ones in Excel proper through Oracle BI EE->View Designer.

image

Displayed as a Pivot Table in Excel, with all of Excel’s pivoting capabilities:

image

This can be then published back to the OBIEE presentation catalog with the Publish View link.

image

And saved as regular OBIEE analysis.

image

And viewed as such:

image

Great little plugin it seems!

Monday 1 April 2013

How to Install Endeca Information Discovery 3.0 on Windows 7 x64

 

Oracle recommends the following installation order:
1. Oracle Endeca Server. For instructions on installing Oracle Endeca Server, including system
requirements, see the Oracle Endeca Server Installation Guide.
2. Oracle Endeca Information Discovery Integrator. For instructions on installing Oracle Endeca Information
Discovery Integrator, including system requirements, see the Integrator Installation Guide.
3. Studio (see About the Studio Installation Process on page 13). After installing, to verify the installation, log
in to Studio. Use a created Endeca data domain to provide the data source.
4. Provisioning Service (See Installing the Provisioning Service on page 54).
5. Integrator Server. For instructions about installing Integrator Server, see the Integrator Installation Guide.
6. Integrator Acquisition System. For instructions about installing IAS, see the Integrator Acquisition System
Installation Guide.

Endeca Server Installation

As per installation guide

http://docs.oracle.com/cd/E37502_01/server.751/es_install/toc.htm

 

  • Download all installation files, Jrockit, WLS 10.3.6, and ADF components
  • Install Oracle Java Jrockit JDK
  • Install Weblogic Server 10.3.6 to new FMW folder (was not prompted for Windows service install)
  • Install Oracle ADF Runtime to recently installed WLS 10.3.6
  • Install Endeca Server to recently installed WLS 10.3.6 (do not use secure mode SSL)
  • Create Weblogic domain for Endeca Server (endeca_domain) (used Development Mode as opposed to instructions’ Production Mode)
  • Skipped SSL keys generation
  • Verify installation by starting Admin Server (on default port 7001)

image


EndecaServer7.5.1_1\endeca-cmd>endeca-cmd create-dd testme

EndecaServer7.5.1_1\endeca-cmd>endeca-cmd get-dd-health testme

Data domain: testme
Leader Node Health:
        Hostname: DANOBRIE-NZ
        Port:7001
        Protocol:HTTP
        Is available
Follower Nodes Health:
Detail:[]

  • Changed WLS listen port to port 8001 (WLS Console->Environment-Servers->Admin Server)

Total Time excluding downloads = 30 minutes

 

 

 

 

 

 

 

 

 

Download Endeca 3.0 Files from edelivery

Endeca Server

From ServerInstallGuide.pdf

Requires:

Weblogic Server 10.3.6 (wls1036_generic.jar from OTN)

Java version 6 of Oracle JRockit JDK

On my platform: Win 7 x64, Steps 11 & 12 did not materialize – ie. no need to create a Windows Service.