Monday, January 10, 2022

Granting Service Administrator privilege to OAC instance

 When working with Oracle Analytics Cloud (OAC) certain users need the super user privileges. The Service Administrator. The user that created the instance gets it by default. The standard setup of inside OAC (Console->Users and Roles->Application Roles->BI Service Administrator) is not enough.

One of the major problems is connecting to Data Modeler Client and getting an Error while all parameters seems fine.

 Most of what we need can be found in the A-Team blog, Provisioning Oracle Analytics Cloud Natively in Oracle Cloud Infrastructure. I will summarize the relevant parts.

When creating OAC instances, if the user is not OCI (Oracle Cloud Infrastructure) Admin, the user should be assigned to a group and the group should get a privilege to manage analytics-instances in the relevant compartment  see here for more about privileges.

allow group <IAM Group> to manage analytics-instances in compartment <Compartment>


Next we should get to the IDCS screen. Find the relevant Oracle Cloud Service and assign the User, Group or Application Role to the ServiceAdministrator Application Role.

This the detailed description of the above paragraph:

From Burger menu on the left select Identity & Security and Federation:

There click on the Identity Provider


And press the Oracle Identity Cloud Service Console link:

There select the burger menu and Oracle Cloud Services:

You might have one or many services there. Find the ANALYTICSINST that is relevant to you and click on it.

Now find the Application Roles tab. There click on the menu (on the right) for Service Administrator and assign User, Group or Application Role to it.

Once you select an option, a search screen with all possible values appears.

Select who you want to add to Service Administrator Application Role.

If you are interested in the relationship between "Application Roles Available in Oracle Cloud Infrastructure Console" and "Permissions in Oracle Analytics Cloud", you can find it here:

 Basic table from documentation:

Application Roles Available in Oracle Cloud Infrastructure ConsolePermissions in Oracle Analytics Cloud


Member of BI Service Administrator, BI Data Model Author, and BI Data Load Author. Allows users to administer Oracle Analytics Cloud and delegate privileges to others.

The user who creates the service is automatically assigned this application role.


Member of BI Content Author and DV Content Author.

Allows users to create and share content.


Member of BI Consumer and DV Consumer.

Allows users to view and explore content.


Not used in Oracle Analytics Cloud.


Not used in Oracle Analytics Cloud.

Detailed table from Analytics perspective: 

Predefined Application
Role in Oracle Identity
Cloud Service

Default Members


Predefined Application Roles in Oracle
Analytics Cloud


Administrator who created the

Allows users to administer Oracle Analytics Cloud and
delegate privileges to others using the Console.

BI Service Administrator


BI Service Administrator

Allows users to manage data models in Oracle
Analytics Cloud using Data Modeler

BI Data Model Author


BI Service Administrator

Allows users to load data.

BI Data Load Author


BI Service Administrator

Allows users to create visualization projects, load data
for data visualizations, and explore data

DV Content Author


BI Service Administrator

DV Content Author

Allows users to create analyses and dashboards in
Oracle Analytics Cloud and share them with others.

BI Content Author


DV Content Author

Allows users to explore data visualizations.

DV Consumer


DV Content Author
BI Content Author

BI Data Load Author

Allows users to view and run reports in Oracle
Analytics Cloud (projects, analyses, dashboards).
Use this application role to control who has access to
the service.

BI Consumer





Not used

Custom link to DV (Self Service) from Classic OAC / OAS menu

 In the header of Classic Analytics in OAC/OAS customers often look for a link to the Self Service Analytics (often referred as DV). 

From this

To this

We can easily achieve it. Using the Console in OAC/OAS.

In OAC Self Service interface select the Console Menu:

There select System Settings


There update the Custom Links XML

The simple version is:

<?xml version="1.0" encoding="utf-8"?>
<customLinks xmlns="">
    <link id="1" name="DV" description="Self Service" src="https://YOUR_SERVER_NAME/ui/dv/" target="blank" >
            <location name="header" insertBefore="catalog"/>

Replace the YOUR_SERVER_NAME to the one relevant to you.

The XML can be enhanced with icons (for example iconSmall="common/info_ena.png" after the target="blank" parameter) or set for specific privileges (adding <privilege> block)... or placed in different locations (change the insertBefore value)... Other links can be added with additional link blocks with unique ids...

After the settings update, Restart the server is required.


Monday, December 20, 2021

Data Visualization - A language of colors. Guest Post


A Guest post by Baby Sirota.  He agreed to share some of his experience and knowledge in Data Visualization. Baby is BI Solutions Manager in One1 Technologies’ Oracle & NetSuite Division.


When speaking of DV, we can divide the process into two arenas:

1.      Backscene- basically, the infrastructure, consisting of every part that’s related to retrieving, aggregating and categorizing data.

2.      On stage – the visual elements that, using colors, size and shapes, translate rows of raw data into ACTIONABLE KNOWLEDGE.

And while you cannot possibly display data without preparing it (properly!!!) first, I’d like to demonstrate when and how COLORS can infuse our Visuals with meaning.

.      Segmentation- Assigning a designated palette to every segment helps distinguish it within a given Dashboard. 


Ex: Coloring by Customer segment – the human brain connects the data by the colors, and automatically assigns the details to each group.

When stacking and/or creating a 100% viz, segmentation by color is extra useful in translating data into knowledge. Each segment in a category has its relative part in the whole, and using color to display it gives an instinctual understanding – which is bigger? When? For how long and for what type of customer?

Advanced level: enrich your color segmentation with shapes & sizes-

Add measures to Size and Shape panes, see how in just a glance you can tell that for Customer segment ‘Consumer’, Office Supplies is the best seller – and most profitable – category.


         Significance – Color as indication to amount / quantity. Assign a color to a specific measure and see its distribution over a given segment. 

     Ex: polygon map

The measure ‘Sales’ is determining the color for each state. The darker the blue, the higher sales amount. It’s so obvious where most of our sales are.



Ex 2: When measure has both positive & negative values-



       This is when we use a two-color palette; it allows us to differentiate between the negative and positive values, and immediately compares where is our strongest and weakest profit ratio. 


Advanced Level: Use size for one measure, and color for another-

Here we used ‘Sales’ for the size and rank of the bars, but the color is by ‘Profit Ratio’.

The result is a fuller understanding of our customers status: the customer with the highest sales has a negative (Gasp!!!) profit ratio.

Such is the power of colors in Viz: it proves that it’s not always about the size 😊.

As you can see – and you CAN, because we’re all about the visuals – infusing our Vizes with colors heighten their significance and turn decision making into a more intuitive, immediate, and knowledgeable process.

For more information, you can contact Baby:



Mobile : 972-544385410