RSS

Generating a Permission Report for Presentation Layer Objects in OBIEE 11G RPD

02 May

In earlier versions of OBIEE we dont have an option to audit teh security permissions applied at RPD level. In OBIEE 11.1.1.6.0, We can generate a permission report for individual presentation layer objects to see a summary of how permissions have been applied for that object. This great feature helps developers to review the security permissions assigned to objects during our development.

To do this,

1. Open the OBIEE 11G RPD (offline/online) in Administration Tool

2. Select the ALL/required presentation objects form your Presentation Layer and right-click.

3. On the context menu select “Permission Report”

3. The Permission Report dialog displays the name and a description of the selected presentation object, along with a list of users/application roles and their permissions. CLick the Save button to save the permissions in CSV format.

4. Once you saved to a CSV format, you can use that report for the quick auditing of security management.

A sample permission report example is:

Thanks to oracle for saving developers time 🙂

-Shiva

Advertisements
 
9 Comments

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

 

Tags: , , ,

9 responses to “Generating a Permission Report for Presentation Layer Objects in OBIEE 11G RPD

  1. byallumadhu

    May 3, 2012 at 6:16 am

    hi all, i have one more scenario like i have concate the columns timestamp column and text column when i concat those columns then it shows in the different like

    modified_date User concat(modified_date,user)
    04/16/2012 02:23:44 kiran 16/Apr/2012kiran

    i dont want this, that should be like
    modified_date User concat(modified_date,user)
    04/16/2012 02:23:44 kiran 04/16/2012 02:23:44kiran

     
  2. Madhu B

    May 3, 2012 at 6:20 am

    hi all, i have one more scenario like i have concate the columns timestamp column and text column when i concat those columns then it shows in the different like

    modified_date User concat(modified_date,user)
    04/16/2012 02:23:44 kiran 16/Apr/2012kiran

    i dont want this, that should be like
    modified_date User concat(modified_date,user)
    04/16/2012 02:23:44 kiran 04/16/2012 02:23:44kiran

    please help me

     
    • Rakesh

      May 4, 2012 at 7:14 pm

      Do the Concatination at the report level using presentation variables.
      create a pv_modified_date presentation variable using the modified_date column.
      In the Report crtieria–>column formula–>
      ‘@{pv_modified_date}{05/03/2012 12:00:00 AM}’ || USER()

      You should get the result as you expected.
      Goodluck.

       
  3. Madhu B

    May 3, 2012 at 6:38 am

    hi all,
    i have created a prompt on ‘month_name’ but it is displayin in alphabetical order that i dont want, i want to display it like
    january
    february
    march
    april
    may
    june
    july
    August
    September
    october
    november
    december

     
    • Rakesh

      May 4, 2012 at 6:45 pm

      If you are using OBIEE 11g then,Edit prompt –>Choice list values–>Specify column values–>select one by one
      january
      february
      march
      april
      may
      june
      july
      August
      September
      october
      november
      december

       
  4. Madhu B

    May 3, 2012 at 6:40 am

    hi all my scenario is ,

    i have to calculate the average for the measure column,
    after calculating the average if the value is less than average then it should be displayed in red colour, if the values is more than average then it should be displayed in green colour and the average should be displayed in yellow colour

    ename sal
    kiran 5000
    rama 8000
    laya 7000
    hari 3000
    chery 7000

    ename sal
    rama 8000
    laya 7000
    chery 7000
    avg for all 6000
    kiran 5000
    hari 3000

    Please Help me it is very urgent Pleaseeeeeeee

     
    • Rakesh

      May 4, 2012 at 7:02 pm

      In the Column Criteria,goto column properties(i.e measure –>column properties)—>conditional formatting–>add condition–>avg(measure) is less than avg–>ok–>select red colour….n vice versa.

       
  5. Vaibhav

    August 3, 2012 at 7:22 am

    hi Shiva, is there a way to generate a user level report to see which user is assigned to what role?

     
  6. Swati

    August 3, 2012 at 12:48 pm

    Hi Shiva,

    Was wondering how do we achieve this in 10g?

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: