מסלול Business Analytics & Big Data בשבוע אורקל 2015

שבוע אורקל יתקיים השנה בשבוע המתחיל ב15 לנובמבר. ביומיים של השבוע שלאחר מכן, (22,23 לנובמבר) יתקיימו גם ימי After Event Workshops.

טובית ואני ננהל את מסלול הBusiness Analytics  & Big Data. ניתן לראות את ההרצאות כאן:

 http://www.oracleweek.com/learning-track/business-analytics/.

השקענו גם בסרטון חינוכי באורך דקה ו21 שניות, המתאר את המסלול ומפרט את ההרצאות. ניתן לראות אותו כאן.

אישית, אני מעביר את Introduction to Data Science Concepts and Tools ומתארח אצל דני במערכות BI בעידן ה- Big Data - טכנולוגיות, מתודולוגיות, כלים ומגמות.

OBIEE 12c - File locations and meanings

The file locations in OBIEE12c are very different from previous versions. I'll update this page when I find something I consider interesting.

First few naming conventions:

I installed OBIEE and Weblogic under d:\MWHOME12.

ORACLE_HOME would be the installation Directory. (In my case d:\MWHOME12\).

BI_DOMAIN, sometimes called DOMAIN_HOME is ORACLE_HOME/user_projects/domains/bi (in my case it is  D:\MWHOME12\user_projects\domains\bi).

 SDD (Singelton Data Directory) is DOMAIN_HOME/bidata (for one host installation). (In my case it is   D:\MWHOME12\user_projects\domains\bi\bidata).




The catalog is located by default at  SDD/service_instances/ssi/metadata/content/catalog
(In my case it is D:\MWHOME12\user_projects\domains\bi\bidata\service_instances\ssi\metadata\content\catalog).

The Repository is (sort of) in SDD/service_instances\ssi\metadata\datamodel\customizations (In my case it is D:\MWHOME12\user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations).

The entire handling of Repository and Catalog is different in 12c and is handled via BAR files. More about it later.


Configuration files are located under BI_DOMAIN/config/fmwconfig/biconfig
(In my case D:\MWHOME12\user_projects\domains\bi\config\fmwconfig\biconfig)
Each in it's folder. For example:

• instaceconfig.xml is in BI_DOMAIN/config/fmwconfig/biconfig/OBIPS  
• NQSConfig.ini          in BI_DOMAIN/config/fmwconfig/biconfig/OBIS

LOGS: Are in BI_DOMAIN/servers, each in his folder. For example sawlog.log is under BI_DOMAIN/servers/obips1/logs. All the logs are located in the same place, including Adminserver logs.

Not only the logs are here. You will found tmp, cache and other folders as well.

Most executable scripts are located in BI_DOMAIN/bitools/bin (D:\MWHOME12\user_projects\domains\bi\bitools\bin, in my case).


The start and stop scripts are here and also the script that collects diagnostic for Oracle Support (diagnostic_dump.cmd  for Windows and diagnostic_dump.sh for Linux).

WebLogic Scripting tool (wlst.cmd / wlst.sh) is located in Oracle_Home/oracle_common/common/bin (D:\MWHOME12\oracle_common\common\bin in my case.)



Update:
Found this at Oracle support: OBIEE 12c: Quick Reference For Architecture, Lifecycle Management and File Locations (Doc ID 2067527.1)

OBIEE 12c - Copy - Paste data from Analysis

We had a short discussion about the option to Copy / Paste of data from analysis to anywhere else.

In OBIEE 12c this option exists. There is a difference in it's behavior.

When working with Tables/Pivots in Fixed headers with scrolling content we are limited by OBIEE.

 I could only mark cells from one column and never mark Axis values in Pivot tables.

But the better abilities exist when switching to Content paging.

Now we can mark the Pivot/Table from outside the frame an select multiple values from multiple columns:

This works even in Pivots (bigger picture):

 

 

OBIEE - Installing OBIEE 12c on my Windows box

I wanted to install the new OBIEE 12.2.1 on my Windows 7 box. Since I want to test the process of migration of OBIEE 11 to 12, I installed it side by side with my existing 11.1.1.9 installation.

If you want to see Linux installation description, you can see Andrew's post here. My installation seems to be smoother then his, despite the fact that Windows 7 doesn't seem to be supported according to the certification matrix (12.2.1 one).

The installation is of 4 steps:

1. JDK installation (if needed)
2. Weblogic Server installation
3. BI Installation 
4. Configuration

I downloaded JDK 8, Weblogic server and 2 BI files from here. After unzipping them I had the following:

I installed the JDK. It's better not to accept the default of installing in "Program Files\Java" folder because of the space in the name. I installed it in c:\Java.

Next I opened a Command Prompt as Administrator. Moved to the above folder (where the files are located) and run the Weblogic installation:
c:\Java\jdk1.8.0_65\bin\java.exe -jar fmw_12.2.1.0.0_infrastructure.jar
Accepted the defaults and pointed it to a new MWHOME I created (D:\MWHOME12, in my case).

Next I run the BI installation in the same folder:
 setup_bi_platform-12.2.1.0.0_win64.exe
And selected the same MWHOME for BI installation (D:\MWHOME12, in my case). 
Here are the next screens:

Now I can run the configuration part.
I used the same Command Prompt Window, and run config.cmd from MWHOME\bi\bin

I left the default, including Essbase (note the RTD installation is gone).

passed the prerequests:

Didn't change the location, but selected the domain user and password:

Allowed the wizard to created the RCU schema (note the options are: Oracle DB, Oracle RAC DB and MS SQL server). there is no standalone RCU anymore.

and updated the DB connection details (note, no need to add "as SYSDBA" for Oracle sys user)  :

******************************************

To be on the safe side, you might prefer to run the RCU separately. The RCU utility is located, in my case at MWHOME\oracle_common\bin.
The new version of RCU allows us to create a script to be used later by DBA, as well.

After you finish the with the RCU, the screen is a bit different:

******************************************

Next left the defaults:

The options here are new and interesting:

 Saved the response file (PLEASE do it at some point, it's not fun to look for the ports and URLs later).

Now the process is running.

While the configuration passed well, the BI Startup at the bottom stayed for few very long minutes on 0%. Then jumped to 100% and finished. Made me check the log few times, during the period.

Now is the last screen. If you didn't save the URLs before. Do it now:

The OBIEE didn't start on it's own.
It is working:

I don't know if this should be so or it's because I have a previous entry of "Oracle Business Intelligence" in the "All Programs" menu, but nothing was added there.

To stop and start the BI server I can run start.cmd and stop.cmd from MWHOME\user_projects\domains\bi\bitools\bin\ (D:\MWHOME12\user_projects\domains\bi\bitools\bin\start.cmd in my case).

After the installation my default ports are 9502 for BI and 9504 for EM.
For Administration Tool installation, the port 9516 is used in the ODBC settings, in my case.

One first discovery I had after the installation. Since OBIEE 12 is pure HTML, we can copy/paste data from analysis, in all browsers I tested:

0

One more similar post: http://ssssupport.blogspot.co.il/2015/10/installing-oracle-obiee-12c-in-windows.html. Leela Madhav preferred to set up RCU separately.
And another by  Srinivas Malyala: OBIEE12c installation on windows7 machine






To the best of my knowledge the RCU should be installed on UTF8 type DB. Deliver BI try to work around it in OBIEE 12 RCU Avoid Hardstop Pre Reqs for AL32UTF8 Database Char Set.


If you are installing RCU on Multi-Tenant Oracle DB, please read before installation:

OBIEE 12c FAQ: Does OBIEE 12c (12.2.1) Support A Multi-Tenant Oracle Database For The RCU Schemas? (Doc ID 2077802.1)

If your installation was successful but OBIEE failed to start please read OBIEE 12c: Oracle Business Intelligence has stopped working by Guillaume Slee (
hyperion-epm-bi.blogspot.com) and his great advise of reducing the PATH to eliminate possible contradictions.


Migration:
 After the installation, the natural step is to upgrade your existing OBIEE 11 to 12. It should be done from 11.1.1.7 latest patches or 11.1.1.9 and described in the post  Migrating from Oracle BI 11g to 12c by Shahed Munir.
And at allthingsorcl.blogspot.com here by @KeitaFK.
The Oracle migration guide is here.

Note the following from Oracle Support: OBIEE 12c Pre-Upgrade Alert: Before Upgrading To 12c, Ensure your 11g Catalog Is Upgraded To the Correct Version (Doc ID 2068965.1)