Tuesday, July 26, 2016

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:

 




Wednesday, July 20, 2016

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:

Saturday, June 25, 2016

Oracle Business Intelligence 12.2.1.1.0 is available

The latest release of OBI 12c - Oracle Business Intelligence 12.2.1.1.0 is available at OTN


Please note there is a new Oracle Business Intelligence Developer Client Tool for download as well.

The 12.2.1.1.0 documentation is here.

The upgrade is described as in-place in the upgrade guide, but is different from what we have seen in 11g:
Upgrading to Oracle Business Intelligence from 12.2.1.0 to 12.2.1.1 is an in-place upgrade performed by Upgrade Assistant. You install the 12.2.1.1 product distribution in a new Oracle home and then use the Upgrade Assistant to upgrade the 12.2.1.0 schemas and domain configuration. You also use the Reconfiguration Wizard to reconfigure the 12.2.1.0 domain.


New Features:


The publisher new features are described in this OTN document and this blog include:
  • Integration using RESTful APIs
  • Delivering documents to Oracle Document Cloud Service
  • Using Web Center Content as a Data Source
  • Attach PDF to your Invoices
  • Deliver E-mail Body in HTML format along with Report as attachment
  • Manage Custom Fonts as self service feature
  • Manage PGP Keys for FTP Delivery Encryption
  • Manage large size reports better. Using Dynamic Memory Guard
  • Enabling Encryption for File Data Security on Cloud
  • Better Integration with 11g migration tools

New Features for Oracle Data Visualization Users seems to close the gaps with DVD (Desktop Data Visualization) latest enhancements:
  • Using Oracle Applications as source (existing Analysis seems to be the common case).
  • Using direct databases link as source
  • Size of data files to upload to 50MB
  • Modify uploaded data sources - including editing columns, and creating new ones for use in projects
  • Use new and enhanced visualization types - Visualize data using donut charts and see data series trends using a trend line. You can also link to URLs and insights in tiles, images, and text boxes, and use Chrome for Windows or Android to dictate descriptions.
  • Customize your color schemes
  • Move filter panels in projects
  • Data wrangling — update data sources after upload
  • Share reports with others on a read-only basis
  • New ways to present data visualizations: Donut charts, Tile views, Free Text boxes
  • Change data blending

New Features for Analysis and Dashboard Users:
  • Ability to sort graph, heat matrix, pivot table, table, treemap, and trellis views by using a context menu (right-click).
  • A new view type named heat matrix. Heat matrices are two-dimensional representations of data in which values are characterized by a gradient of colors.
  • Adding data from an uploaded external source to an analysis.  
  • Scale for % (x 100) component in the Column Properties dialog: Specify whether to multiply data by a 100 to display it as a percentage when setting the properties of a column.
  • Style and customize KPI Watchlists and every watchlist that appears in a scorecard. You can set custom styles for each watchlist and rename and change the order and visibility of the watchlist columns.
  • Advanced page properties to specify incoming navigation parameters you want to set on the current dashboard page. This enables you to control how parameters associated with the navigation actions are applied .
Few more new features:
  • In RPD, Data Driven Fragment Selection in Logical Table Sources (default, disabled )
  • For security, Catalog groups are not supported anymore and you must use application roles.
  • New Service ("AnalysisExportViews Service") and new Structures, new Methods and updates to Oracle BI Server XML Procedures are described in Integrators guide here.
  • Datasources

    AT Release Notes we can see that: Additional ODBC data sources are supported for Oracle BI EE 12.2.1.1.0. The data sources using ODBC DataDirect 7.1.5 include Amazon Redshift, Oracle Service Cloud, and Teradata.
    Interesting to note that in certification matrix here, in the database tab, for BI Product, we see few new entries:  Apache Spark SQL, Google BigQuery, MongoDB, PostgreSQL. Few new versions support; MySQL 5.7.*, MS SQL Server and MS Analytic Services  (2014), Teradata (15.0 and 15.1), Hive 0.10+.
    Under OBIEE Apps & other Datasources we see Saleforce (Spring 16+ version), Amazon Redshift (1.0.1036+), Impala 1.3+.
     

Thursday, May 19, 2016

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.