RSS

Tag Archives: Default permissions

How to bypass Presentation Server Cache in OBIEE 11G

During our development if we wanted to check the report level UI changes, sometimes we will not see the changes immidiately. This is due to Presentation Server Cache. Eventhough we disable the BI Server cache, It doesnt make any effect on presentation Server objects.

So in that situations we need to disable Presentation server cache permanently across OBI Application, To do this add the following parameters in instaceconfig.xml. (Make sure that you have taken a backup copy of instanceconfig.xml)

<ServerInstance>
———

<Cursors>
<ForceRefresh>true</ForceRefresh>
</Cursors>

——–

</ServerInstance>

Now restart the OBI Presentation server service and test the results.

Note: Keep in mind that this parameters cause Presentation Server to always bypass its cache. To be used only for testing – may have serious performance implications.

Keep smiling 🙂

Thanks,
Shiva

 
4 Comments

Posted by on July 17, 2012 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , , , , , , , , , ,

OBIEE 11G default System Permissions in Policystore

In OBIEE 11G the application access and privileges has been ruled by the Application Roles. The OBIEE 11G application has predefined system policies (permissions) which are assigned to application Roles we define in Policy store.

By default we have out of box App roles (BIAdministrator, BIAuthor and BIConsumer) created in EM. But in real world we (may) need to create new roles with different permissions.

Here is the list of available OBI system permissions. We need to choose one/combination of them for new Roles.

Permission Name

Description

oracle.bi.publisher.administerServer

Enables the Administration link to access the Administration page and grants permission to set any of the system settings.

oracle.bi.publisher.developDataModel

Grants permission to create or edit data models.

oracle.bi.publisher.developReport

Grants permission to create or edit reports, style templates, and sub templates. This permission also enables connection to the BI Publisher server from the Template Builder.

oracle.bi.publisher.runReportOnline

Grants permission to open (execute) reports and view the generated document in the report viewer.

oracle.bi.publisher.scheduleReport

Grants permission to create or edit jobs and also to manage and browse jobs.

oracle.bi.publisher.accessReportOutput

Grants permission to browse and manage job history and output.

oracle.bi.publisher.accessExcelReportAnalyzer

Grants permission to download the Analyzer for Excel and to download data from a report to Excel using the Analyzer for Excel. Note that to enable a user to upload an Analyzer for Excel template back to the report definition, the permission oracle.bi.publisher.developReport must also be granted.

oracle.bi.publisher.accessOnlineReportAnalyzer

Grants permission to launch the Analyzer and manipulate the data. Note that to save an Analyzer template to a report definition, the permission oracle.bi.publisher.developReport must also be granted.

oracle.bi.server.impersonateUsers

This description is not available.

oracle.bi.server.manageRepositories

Grants permission to open, view, and edit repository files using the Administration Tool or the Oracle BI Metadata Web Service.

oracle.bi.server.queryUserPopulation

Internal use only.

oracle.bi.scheduler.manageJobs

Grants permission to use Job Manager to manage scheduled Delivers jobs.

For eg: if you want to create a new role for OBI RPD administration only. Then you need to create a new Application Role in EM with the permission oracle.bi.server.manageRepositories

Hope this post helps you to create a better App Roles with proper permissions.

Thanks,

Shiva

 
4 Comments

Posted by on May 3, 2012 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , ,