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.
Figure 7 – Illustrates restarting both the OBI Presentation Server and the OBI Server
There are many other options available to administer an OAC environment that were not covered in this blog. Please go to The Performance Architects Learning Center which is our free community and forum that provides on-demand business education related to the analytics/business intelligence and enterprise performance management arenas. There you can watch our Best Practices of Managing Your Oracle Analytics Cloud (OAC) Instance Webinar for a more in-depth review of the administration options available to you in OAC. If you have any further questions, please email us here.