OBIEE 12.2.1.0.161018 is available

OBIEE 12.2.1.0 bundle patch was released a week ago, as described by
Business Analytics - Proactive Support here. 

The patch 24695761 download is here.

This is the readme.

This is a critical patch update.

With it 12.2.1.1 client should be used (download is here).

This is the list of bugs resolved:

21094127    ADD FUSE CUSTOM.CSS APP STYLES TO ALTA
21127173    BI DEINSTALL THROWS EXCEPTIONS WHILE LAUNCHING DEINSTALLER IN COMMAND LINE
21158035    12C VA MASHUP DATASET INSPECT DIALOG TO INCLUDE PERMISSIONS TAB
21419316    QA:HGRID CAUSE&EFFECT AND STV WITH MANY COLS DON'T DISPLAY PROPERLY AS          WATCHLIST
21438772    Fix for Bug 21438772
21527677    12C:BI: INSTRUCTION FOR ENTERING THE DOMAIN NAME NEEDS TO BE CHANGED
21529377    MDS XML INVALIDDATATYPEVALUEEXCEPTION, MESSAGE:ID 'MERROR' IS NOT UNIQUE
21658348    UNABLE TO FIND MAPPING.XML IN ALL UTIL LOGS IN ADMINTOOL CLIENT
21766161    Fix for Bug 21766161
21766173    Fix for Bug 21766173

OBIEE 12.2.1.2.0 is available

The latest release of OBI, 12.2.1.2.0 is available at oracle.com here.

It's available as usual for Windows, Linux, Solaris on Sparc, Solaris on x86, IBM AIX and HP UX Itanium.

The documentation is here. 

This is the get started link.

In the great blog of Oracle Underground BI & Dataviz (http://oracledataviz.blogspot.com), the post "Upgrade OBIEE in your SampleApp V607 to 12.2.1.2" gives us everything:

1. How to upgrade, the Oracle way (there is an alternative at RittmaMead here).
2. What is OK to delete at the old home, to save space (actually, I didn't try that yet).
3. How to configure 2 new features:
    a. Lightweight SSO that uses VA sign on
    b. .dva import/export.

Regarding the Lightweight SSO, a quick reminder to myself:
If I had the OBI 12.2.1.1.0 installed at C:/oracle/Middleware/Oracle_Home, and the OBI 12.2.1.2.0 is now at C:/oracle/Middleware/Oracle_Home12212.
wlst script is at C:\oracle\Middleware\Oracle_Home12212\oracle_common\common\bin. Run wlst. There run the script to run is: enableBISingleSignOn('C:/oracle/Middleware/Oracle_Home/user_projects/domains/bi','/bi-security-login/logout?redirect=/va').

After the restart, when I login this is the screen (The VA one):

If you are Arabic/Hebrew UI user, this has impact.

If not happy with the SSO the following disables it:
disableBISingleSignOn('C:/oracle/Middleware/Oracle_Home/user_projects/domains/bi')

Creating COUNT(DISTINCT "Orders"."Order Number" by "Products"."Product Type") in RPD

I wanted to create  COUNT(DISTINCT "Orders"."Order Number" by "Products"."Product Type") as a column in the repository, based on the default Sample Sales.

In the Sample Sales there is already a column that return COUNT(DISTINCT "Orders"."Order Number"). It's Name is # of orders and it is defined as "Count Distinct" aggregation on the Order_number key:

Basically the COUNT(DISTINCT "Orders"."Order Number" by "Products"."Product Type") is equivalent to Sum("# of Orders" by "Products"."Product Type"). For example:

I will use this logic in the RPD:

I duplicated the # of Orders column. In our case the aggregation by Products dimension should be sum, while by other dimension "Count Distinct", so turn on the "Based on dimensions" option and set it (use the Plus sign to add Logical Dimensions and select the formula from the pull down menu):

 

Now the last part is to set the levels, at the column  to be by Product Type for products and Total for all the rest:

 I didn't bother with column name so it's "# of Orders 1".

This is the result:

 

Patch 160719 of OBI is available for 11.1.1.7, 11.1.1.9 and 12.2.1.0

Patches 11.1.1.7.160719, 11.1.1.9.160719, 12.2.1.0.160719 are available at Oracle support site.

The only one not on the list is 12.2.1.1.0

Please note this is Critical Patch Update.

see more at Business Analytics - Proactive Support blog:

• 11.1.1.7.160719 Patch 23703041
• 11.1.1.9.160719 Patch 23703078
• 12.2.1.0.160719 Patch 23299662