Monday, April 23, 2018

obiee is available

OBIEE was released this weekend. 
The download page is here.

The installation includes:

The unexpected component is the patches for the weblogic server that should be installed before installing the BI. Oracle advises to install them when upgrading from previous 12c.

The JDK and Weblogic components seem to be the same as for

At the moment the BI Client seems to be rather big download file. When I opened it I discovered another copy of the BI server software, beyond the expected client software.  So if you are installing OBIEE Windows server...

The new features are mainly major upgrade of the Data Visualization component, described here.

Data Visualization new features:

 Publisher new features:

 Specifying the Barcode Types in RTF Templates.You can use the qrcode or PDF417 functions to specify the barcode type in the RTF templates. See 2D Barcode Functions.
  • Creating Accessible PDF Documents.You can create structured accessible PDF documents that include the document title and PDF tags. See Generating Accessible PDF Output.
  • Skipping Pages and Page Numbers in Reports.You can create a RTF template to skip pages and page numbers in the first page, even pages, or odd pages in reports. See Skipping Pages and Page Numbers.
  • Enable Diagnostic Logs for Online Reports.You can enable diagnostic logs for online reports. See Enabling Diagnostics for Online Reports.
  • Purge Scheduled Job History Data.You can purge the history of old scheduled jobs. See Purging Job History.
  • Set Memory Guard Property for Bursting Data Size.You can set the server.BURSTING_REPORT_MAX_DATA_SIZE memory guard property to limit the size of bursting data. See Memory Guard Properties.
  • Generate Command-Line Utilities.You can run the GenerateBIPUtility script to generate the utilities for configuring memory guard properties (BIPCONFIGSERVICE.ZIP) and for managing catalog (BIPCATALOGUTIL.ZIP). See Using Command-Line Utilities.

 OBIEE new features:

  • This release includes the Manage Themes functionality, which allows the entire interface, dashboard styles, or both to be customized with a logo, colors, link appearance, and button shape. See Modifying the User Interface With Themes.

Tuesday, March 13, 2018

OBIEE 12c using database authentication provider - addendum

In older versions of OBIEE, DB based authentication were very popular using Initialization Blocks.
Oracle does not support this sort of authentication lately.
If you insist on Database as Authentication Provider, you can check chapter 3 of BI security Guide, "Configuring a Database as the Authentication Provider". Or the second half of this RittmanMead blog here.

2 things to remember:

1. When running the libovdadapterconfig script at the end, set the dataSourceJNDIName value as the JNDI Name and not the "regular" Name. Next, give the weblogic password, when requested for AdminServer password.

2. In case you made a mistake while running the libovdadapterconfig script, running it again informs you the adapter was already created. The guideline to fixing it is at the bottom of note 2226809.1 at Oracle Support:

Note: If for any reason the adapter would need to be recreated, follow steps detailed in the Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition -> Correcting Database Adapter Errors by Deleting and Recreating the Adapter
Note: If the delete adapter command is run as per the documentation, it gives the impression that the adapter was not deleted by returning this message:

'Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root MBean.' with no further message.

For example:

Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
wls:/offline> connect ('weblogic','Welcome1','t3://hostname.domain:9500')
Connecting to t3://hostname.domain:9500 with userid weblogic ...
Successfully connected to Admin Server "AdminServer" that belongs to domain "bi".
Warning: An insecure protocol was used to connect to the server.
To ensure on-the-wire security, the SSL port or Admin port should be used instead.
wls:/bi/serverConfig/> deleteAdapter(adapterName='MySQLGroupProvider')
Location changed to domainRuntime tree. This is a read-only tree
with DomainMBean as the root MBean.
For more help, use help('domainRuntime')
wls:/bi/domainRuntime/> exit()

However, the adapter is effectively deleted and can be confirmed in the Weblogic Administration Console.

In my case the server is localhost:

Tuesday, February 6, 2018

Oracle Analytics Cloud 18.1.3 Patch is Available

Oracle Analytics Cloud (OAC) 18.1.3 Patch is available. You can see the list of new features in the "What's New document" here.

To summarize:

A full feature Delivers for OAC similar to  OBIEE. This seems to be the final component that covers the full OBIEE functionality in OAC.Interesting that documentation describes this as OAC Enterprise and Data Lake edition option. I'm not sure what the Data Lake part can do with Delivers.
Better integration with Synopsis as one more mobile option. 
Some improvements in Service management.
For Essbase users we have direct Cube Designer install and MDX ability to run on Essbase server and have the metadata and data output results exported to saved structures on Essbase (alternative to client).

This is the list from Oracle Documentation:

Reports and Dashboards

Use agents to deliver content Create agents that deliver your analyses, dashboards, and briefing books to specific recipients and to subscribers. See Enabling Content Delivery Through Agents and Automating Business Processes Using Agents.
Set up devices and individual delivery profiles Configure one or more devices where you want alerts and content from Oracle Analytics Cloud to be delivered. Set up personal delivery profiles to suit your different needs. See Configuring Your Devices and Delivery Profile.
Manage your deliveries in one place You can manage all your deliveries from the Console, that is, email deliveries and deliveries generated by agents.
Synopsis mobile app Create and share instant analytics from data on your mobile devices. See What can I do with Oracle Analytics Cloud Synopsis?

 Service management

Configure a public storage container during service creation Share data visualizations through a public storage container. Specify the container you want to use when you set up your service. See Creating a Service.
Update the password for cloud storage
Update the credentials Oracle Analytics Cloud uses to access Oracle Cloud Infrastructure Object Storage Classic. See Managing Credentials.
Connect to EssNet over HTTP
Connect from any software using Essbase Real Time Client (RTC) over HTTP protocol without needing to open ports or perform other configuration or communication. See Connecting to EssNet over HTTP.
Update the database passwords for Essbase services
Use a script to update the database administrator password for an Essbase service. See Updating Essbase Database Credentials.


Install Cube Designer from the Scenarios page You can download the Cube Designer installer directly from the Scenarios page in addition to the traditional installation from within Smart View. See Installing the Smart View Cube Designer Extension in Using Oracle Analytics Cloud - Essbase.
Export MDX query output to the service
You can run MDX queries and have their metadata and data output results exported to saved structures on Essbase. This is an alternative to viewing the query output on a client. For syntax used to export an MDX query, see MDX Export Specification in Technical Reference for Oracle Analytics Cloud - Essbase.

Tuesday, January 16, 2018

Using Oracle Data Visualization for analyzing matriculation examination results in Israel - Hebrew

I used Oracle Data Visualization to do some analysis of Israeli matriculation examination results. Sorry it's all Hebrew.
The post was published here: