ELFFAR ANALYTICS
  • Home
  • Services
  • Contact Us
  • About Us
  • Blog

Elffar Analytics Blog

Oracle Analytics Server - Data Visualisation Access Issue

3/3/2020

0 Comments

 
Picture
Daniele Levis Pelusi
Oracle Analytics Server 5.5.0 was recently released and I've been testing out the OAS installation process. This short blog post just goes through some issues that I encountered during this process related to access to Data Visualisation.

I did an out-of-place upgrade which went remarkably smoothly and imported a BAR file from a 12.2.1.4 OBIEE instance into the new OAS instance. The problem I had was to do with access to Data Visualisation.

When I tried to access the Data Visualisation page (server:port/dv/ui), I got an insufficient permissions error:
Picture
After some digging around, it transpires that there were some WebLogic Application policies that weren't assigned to any Application Roles. Oracle Support pointed me in the direction of this Support Document - Oracle Support Document 2644363.1. The 12.2.1.4 BAR file import wrote over some of the default WebLogic application permissions.The actio.admin permission needs to be granted to the BI Service Administrator application role. This is all done in em (WebLogic Enterprise Manager).
Picture
To compartmentalise the Data Visualisation security, I'd highly recommend creating 2 Application Roles:
  1. DV User
  2. DV Administrator
These roles will have the appropriate Application Policies and Resource Types assigned. These roles can then be assigned as required to the appropriate users.For example, the DV Administrator role can be assigned to a WebLogic administrator or to the BI Service Administrator role.

I was about to publish this blog and the Oracle Support folk just put together a new Support Document based on this issue with overwritten WebLogic application policies after an import of a 12.2.1.4 BAR file into an OAS instance..Hope this saves someone a bit of time.
0 Comments

    Author

    I'm an Oracle Ace Associate, Oracle Cloud Platform Enterprise Analytics 2019 Certified Associate and a certified OBIEE 11g implementation specialist.

    Archives

    March 2020
    February 2020
    December 2019
    August 2019
    June 2019
    February 2019
    January 2019
    December 2018
    August 2018
    May 2018
    December 2017
    November 2016
    December 2015
    November 2015
    October 2015

    Categories

    All
    OAC
    OAS
    OBIEE
    OBIEE 12c

    RSS Feed

Powered by Create your own unique website with customizable templates.
  • Home
  • Services
  • Contact Us
  • About Us
  • Blog