Key Oracle Analytics Cloud Console Options

NOTE: This blog was written for the OAC V105.4 Console Environment

The key to a well maintained Oracle Analytics Cloud (OAC) environment is having an administrator who is knowledgeable of everything that is available to them in the OAC Console. In order to arm yourself with this knowledge, this blog covers a handful of the different options in the console of an OAC Instance, and different customizations that can be applied to an Oracle Managed OAC Environment.

How to get to the OAC Console Page

To get to the OAC Console page, login and select the Navigator button in the top left corner of the screen and then click on the “Console”:

Figure 1 – Illustrates where the “Console” button is in OAC

Figure 2 – What your OAC Console Page should look like

Visualizations and Sharing: Maps Option

The Maps option allows you to bring in new Map Backgrounds or Map Layers to your visualization. You can also link your OAC environment to Google Maps, where you can bring in their different backgrounds to your OAC maps. The Oracle Analytics Library contains custom map layers that can be brought into your environment. Some of these custom layers include U.S. Zip Codes, Canadian Provinces, and Counties in the U.S.

Figure 3 – The Maps Option in OAC

Visualizations and Sharing: Extensions Option

Out of the box, OAC contains a plethora of visualizations that can be used for a number of different analytical representations. However, there are times where specific visualizations may be necessary, and this is where the Extensions tab comes into play. The Oracle Analytics Library contains new visualizations that can be brought into your environment. Some of these visualizations include Calendar Heatmaps, Butterfly Charts, and Gantt Charts. It is simple to download these visualizations from the Analytics Library and upload into your OAC environment.

Figure 4 – Illustrates the Extensions tab with a new Motion Chart Plugin visualization in the OAC environment

Configuration and Administration: Snapshots Option

Another key Console feature is the Snapshots option. A snapshot is how you can store a copy of how the environment is configured at a given time. Snapshots can contain all objects of an environment, or you can customize specific items like the Catalog, Data Model, Application Roles, and Data related objects like Data Flows and Data Sets.

Figure 5 – Illustrates the Snapshots Option

From within the Snapshots screen is also where you control your Data Model if you are using a traditional OBIEE metadata repository (RPD). To replace the Data Model, click the “Page Menu” button in the top right corner and then select “Replace Data Model”. You will be prompted to provide the folder path for your RPD file as well as the RPD password.

Figure 6 – Illustrates how to replace your Data Model when using an OBIEE Metadata Repository

Configuration and Administration: System Settings Option

The last Console tab that will be covered is the System Settings option. Similar to adjustments that would be made to your NQSConfig and InstanceConfig files in an on-premise OBIEE implementation, Oracle Managed OAC allows for adjustments to certain properties within the OAC instance. The administrator has the ability to toggle different view Interactions like Drilling, Including/Excluding Columns, and Moving Columns. There is also the ability to set the default time zone for the environment and, most recently, the ability to setup Usage Tracking in your environment.

Depending on the type of change you make, you will either be required to restart the OBI Presentation Server or the OBI Server. There could be situations where if you are making multiple changes to the system settings, that you would be required to restart both servers.