ilOUG Tech Days May 30 - May 31

ilOUG tech days will take place on 30-31 May.

ilOUG Tech Days קרבים והולכים ויתקיימו ב30-31 למאי.

 
 

This is the link to registration (at the bottom).

זהו הקישור להרשמה (בתחתית הדף).

וזו התוכנית (עם רמז קל):

This is the agenda (with the slightest hint):

I hope to hear Mark Rittman, Christian Berg, Hans Viehmann...
Pity I have to decide between Oren Nakdimon and Mark Rittman on the first day.

Oracle DVD - Data Visualization Desktop with Analysis as source

With Oracle Data Visualization Desktop we can have 3 types of sources:

File (XLSX Excel), Oracle Applications and Database.

While the Database has an interesting list of options (see the community link here for "how-to" examples):

I will talk about the "Oracle applications" data source that enables us to have OBI Analysis as data source.

When selecting this option we are hinted about the URL structure:

 I filled my OBI 12 server URL, user and Password. Gave the Connection a name:

Next I could select an Analysis (only Analysis, not dashboards...). Did you notice we can also use logic SQL?

Decide what columns are Attributes and Measures and the type of Aggregation for the measures (stayed with the defaults).

 

And create a Project with it's columns.

I wanted data from 2 Analysis, so I selected another one: 

Pressed Add Data source at the bottom:

Created New Data Source:

I could connect to other data sources, but I picked the "From Applications" and selected another Analysis. 

Since in both analysis I had "Per Name Year" column the system suggested them as a matching columns:

We always can change our mind later, by selecting "Source Diagram":

And Changing the definition:

Now I can create VA Project from both Analysis.

Please note that in the Canvas setting we can Refresh Data and Data Sources:

One more little test I did, was to connect to OBI 11.1.1.9 as data source. It worked fine.

Oracle Data Visualization Desktop 12c is available

The first release of Oracle Data Visualization Desktop 12c is available at http://www.oracle.com/technetwork/middleware/oracle-data-visualization/index.html.

A nice post about it at Rittman Mead site here, by Matthew Walding.

And Oracle Blog (by Mike Hallett) here (with some pricing information).

A YouTube link is here.

Link to community here.

Docs are here. 

And a nice picture from the article by Hardik Chheda (Thinking of an Electric Vehicle as your next car?):

Few interesting possible data sources:

After the very trivial installation you might want to go to Start Menu and run "Install Advanced Analytics" (you need internet connection for that).

OBI - Installing Patch 12.2.1.0.160419 Windows

I downloaded the patch and mostly followed the readme (here).

There is slight inconsistency between the Conflict Resolution part (section 2.2) and (section 5). Nothing grand, but my version is slightly different.

My OBI installation is at D:\MWHOME12 where the MWHOME12 is already the Oracle_Home (The usual installation might be Oracle/Middleware/Oracle_Home).

Step1: Stop OBI:

At <ORACLE_HOME>\user_projects\domains\<domain_name>\bitools\bin run stop.cmd

in my case D:\MWHOME12\user_projects\domains\bi\bitools\bin\  &  stop.cmd

Step2: Uznip the patch file under Oracle_Home:

In my case folder 22734181 created in D:\MWHOME12

Step3: Set environment variables at command prompt:

Open Command prompt 

cd Oracle\Middleware\Oracle_Home

set ORACLE_HOME=C:\Oracle\Middleware\Oracle_Home

set PATH=%ORACLE_HOME%\bin;%PATH%

set JAVA_HOME=%ORACLE_HOME%\oracle_common\jdk  

set PATH=%JAVA_HOME%\bin;%PATH%

set PATH=%ORACLE_HOME%\OPatch;%PATH%

Please note the JAVA_HOME line is not like the readme

In my case:

 

cd D:\MWHOME12

set ORACLE_HOME=D:\MWHOME12

set PATH=%ORACLE_HOME%\bin;%PATH%

set JAVA_HOME=%ORACLE_HOME%\oracle_common\jdk  

set PATH=%JAVA_HOME%\bin;%PATH%

set PATH=%ORACLE_HOME%\OPatch;%PATH%

On UNIX: If you are using a command shell derived from the C shell, then set the environment variables by entering the following:

setenv ORACLE_HOME $PWD

setenv PATH $ORACLE_HOME/bin:$PATH

setenv JAVA_HOME $ORACLE_HOME/oracle_common/jdk

setenv PATH $JAVA_HOME/bin:$PATH

setenv PATH $ORACLE_HOME/OPatch:$PATH

 Step4: Run Conflict resolution

opatch prereq CheckConflictAgainstOHWithDetail -ph .\22734181  (changed readme)

Assuming it passed:

 

Step5: Install patch

cd 22734181

opatch apply 

answered both questions yes (after you stopped the server)

Step6: Start the server:

At <ORACLE_HOME>\user_projects\domains\<domain_name>\bitools\bin run start.cmd

in my case D:\MWHOME12\user_projects\domains\bi\bitools\bin\  &  start.cmd

Few things to note:

1. The patch does not cover the admin tool. All the known problems there, remain (see section 10 in the readme).

2.  The version number of OBI does not seem to change after the patch.