X

An Oracle blog about BI Publisher

Controlling Bells and Whistles

I'm still head down. nose to the grindstone, working on various projects that take me away from the blog or at least away from the big articles. If I were away, you would not be reading this today. When I do raise my head and get outside Im beginning to think that Spring might actually be on the way. Im only having to wear two layers of clothing now and hardly need my wooly hat to keep the balding bonce warm. The snow is slowly receding from our yard and the male deer appear to be sharpening their antlers on our trees in anticipation ... at last.



Today, another nugget and a plea - let's start with the plea. Please please please take a look at the documentation first if you get stuck - not so easy for non-English speakers/readers I know but the rest of you have no excuse. It is good stuff in my opinion, yes there are bits missing and yes its a little scattered but there are answers in dem der pages. Check out the documentation library pages here,



http://www.oracle.com/technology/documentation/bi_pub.html



We do put a lot of effort into the doc, Leslie, our writer is snowed under trying to provide a core guide for the other BIP flavors to pick up plus the EBS and Standalone/BIEE BIP user guides - we need writers! Sorry, thats not a job offer.



OK, rant over! There was a question on the forum asking how to control all the buttons and tools in the standalone release, allowing or preventing users from having access. Such as, Excel Analyzer, Scheduling, etc. We secure all of that by using BIP roles that you assign to your users.



























Role Privileges

no roles assigned

View (online reports only)

BI Publisher Excel Analyzer

View
History
Grants access to the Excel Analyzer

BI Publisher Online Analyzer

View
History
Grants access to the Analyzer

BI Publisher Scheduler

View
Schedule
History

BI Publisher Template Designer

View
History
Enables log on from Template Builder

BI Publisher Developer

View
History
Edit
Configure
Folder and Report Tasks
Enables log on from the Template Builder

BI Publisher Administrator

View
Edit
Schedule
History
Configure
Folder and Report Tasks
Excel Analyzer
Online Analyzer
Admin tab and all administration tasks
Enables log on from the Template Builder



Not an exhaustive list of all the functions but you ought to be able to find a combination that will satisfy your need to control what users can and can not do in the system. These are seeded roles in the system and you can assign them to your users quite easily - just read the manual to find out how ;0)

Join the discussion

Comments ( 1 )
  • David McGraw Thursday, December 24, 2009
    We need to programactically schedule reports using the BI publisher scheduler. Can we write a PLSQL application to perform this function?
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.