Monthly Archives: July 2016

New OBIEE 12c Feature: Dashboard Subpages

July 20, 2016

Author: Doug Ross, Performance Architects

Oracle released Version 12.1.1.1.0 of the Oracle Business Intelligence Enterprise Edition (OBIEE) platform in late June 2016. While the majority of new features are focused on the “Data Visualization” component, there is one new feature for traditional OBIEE environments that may be of interest, called “dashboard subpages.” These can be very beneficial to implementations requiring dashboards with many pages. Now those pages can be grouped logically using subpages under individual higher-level dashboards.

The process of creating a dashboard subpage is very straightforward.  For this example, a dashboard will be created with two dashboards tabs – one for revenue-related analyses and the other for quantity-related analyses.

We’ll begin by creating a new “Product Analysis” dashboard:

doug1

doug2

Initially, we will not add any content to the dashboard:

doug3

Next, we will add a second dashboard page named “Quantity” and rename the first dashboard page to be “Revenue”:

doug4doug5

Now, we’ll take advantage of the new OBIEE 12c dashboard subpage feature to add three subpages to the Revenue dashboard. The “Add Subpage” option is available under the “Add Dashboard Page” icon on the “Edit Dashboard” screen:

doug6

The dialog box is similar to the “Add Dashboard Page” box with a required “Subpage Name” and an optional description:

doug7

The new subpage is added to the current dashboard page and displays as a separate tab on that page.   For this example, we’ll add two more subpages to the Revenue dashboard and then add content from the web catalog to each subpage:

doug8

doug9

doug10

doug11

doug12

Next, we’ll add another subpage to the “Quantity Dashboard Page” and add content to that page:

doug13

 

 

 

 

The finished dashboard now has two separate pages, each with multiple subpages:

doug14

 

Working with subpages is consistent with the previous dashboard page capabilities with all the similar options to delete, rename, move, or set other properties:

doug15

From a web catalog perspective, the subpages are stored as objects within the same folder as the dashboard pages and there is no visible indication that an object is a subpage:

doug16

In summary, the new dashboard subpage feature of OBIEE 12.1.1.1.0 is an easy way to provide better control of, and organization to, your dashboard content.


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Considerations for Migrating On-Premise Oracle BI Enterprise Edition (OBIEE) to Oracle BI Cloud Service (BICS)

July 13, 2016

Author: John McGale, Performance Architects

As of the date when this was written, the only items that can be migrated from Oracle Business Intelligence Enterprise Edition (OBIEE) on-premise to Oracle Business Intelligence Cloud Service (BICS) are the OBIEE RPD and the underlying relational data.  This is a one-way move because the RPD cannot be moved back to on-premise OBIEE from BICS.  Reports created against the on-premise RPD cannot be migrated to the BICS environment, and will instead need to be recreated in BICS.  There are plans to add this functionality in the future (hopefully very soon).

johnm1
The OBIEE to BICS RPD migration summary process

Once an RPD is published to BICS, the BICS Data Modeler tool cannot be used.  The RPD is essentially a ‘read only’ model in BICS.  If model changes are required, these should be made with the local copy of the RPD in the OBIEE BI Administration tool, and then uploaded again in the BICS “Service Console.” This assumes you have a more sophisticated enterprise development shop in-house maintaining an on-premise RPD for an OBIEE instance.

We recommend that you create a snapshot of your BICS system before attempting this migration.  If it is necessary to revert to using the BICS Data Modeler tool, restore a snapshot of the system that you created previous to the on-premise RPD migration.

If you are required to house data in multiple schemas in BICS, you must additionally subscribe to a full Database as a Service (DBaaS) instance of the Oracle database. In future releases of BICS it should be possible to use the DB Schema Service that comes with BICS, but this is not currently supported. You will need to use Version 11.1.1.6 or later of the OBIEE BI Administration tool on-premise to create the RPD. The RPD must pass the consistency check within the BI Administration tool.

Another consideration is the need for continuous data refresh from an on-premise environment.  Loading on-premise relational sources and files to the cloud can now be achieved with a brand-new tool called Oracle BICS Data Sync.  Oracle BICS Data Sync is a separate tool that you download and install locally.

johnm2
The Data Synch Utility (on-premise tool)

This is a wizard-driven utility that enables you to upload on-premise relational sources or CSV files to Oracle Database Cloud and keep the data in synch by performing incremental data loads or rolling deletes.  You can perform “insert-only” or “append” strategies and merge data from multiple sources.  You can replace, append, and update data in tables by scheduling data loads and using the “Load Strategy” option in this utility.


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.