Skip to Content
Author's profile photo Manikandan Elumalai

BusinessObjects Administration – The less known Security Query

Dear All,

As part of regular BusinessObjects Administration activities, we always tend to use Security rights validation for set of users/User groups on periodic basis. Security Query is one of the out of box functionality which enables you to get the list of rights associated with the particular principal on top of a specific BI content. Let us see how security query works.

Security Query menu in CMC

/wp-content/uploads/2013/09/1_278617.jpg

Security Query creation

  /wp-content/uploads/2013/09/2_278624.jpg

Security Query wizard

  /wp-content/uploads/2013/09/3_278625.jpg

There are 3 different entries that need to be filled for Security query execution.

    1. Query principal -> The User/Usergroup

/wp-content/uploads/2013/09/4_278626.jpg

   2. Query permission (Optional) – Set of specific rights/all in the list

       All

/wp-content/uploads/2013/09/5_278633.jpg

     Set of rights

/wp-content/uploads/2013/09/6_278634.jpg
   3. Query Context – Folder on which rights need to be investigated.

/wp-content/uploads/2013/09/7_278635.jpg

The Final Security query will be

  /wp-content/uploads/2013/09/8_278639.jpg

Click on OK and the generated security Query results. Selected BI content with in your Query context will be shown as below

  /wp-content/uploads/2013/09/10_278640.jpg

If required you can always export your query results in a flat file and perform your validations

/wp-content/uploads/2013/09/11_278642.jpg

Security Query execution history

/wp-content/uploads/2013/09/12_278643.jpg

Exporting Security query to .csv format

/wp-content/uploads/2013/09/13_278644.jpg

Finally the exported Security query results in a flat file.

  /wp-content/uploads/2013/09/14_278645.jpg

Hope the blog is interesting!! Thanks for reading. In my next blog am going to talk about Relationship Queries. Stay tuned.

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Interesting blog!!!

      Author's profile photo Former Member
      Former Member

      Hi,

      Is there is a way to get this query execution automated by schedule with excel format.

      Actually we have certain applications which needs to be done auditing on every two weeks.

      So Auditor wants the information in excel report for every two weeks.

      And format is like

      User Name, Member of (group Name), Group security, Folder Name , Folder security.

      I know we can get user name, group name etc with either Query builder or with some Macros. But i dont find any option to fetch relevant security information in the same report.

      As of now we are doing this manually which is really time consuming one. If you have any good idea or experience please share with me.

      We are using BO4.0 SP5.

      Author's profile photo Manikandan Elumalai
      Manikandan Elumalai
      Blog Post Author

      Hi Satheesh, Have you got any chance to check this utility.

      http://www.forumtopics.com/busobj/viewtopic.php?t=170766&start=0&postdays=0&postorder=asc

      Try to deploy this as a program object and schedule this as on when it is required. Now you should be able to achieve what you are looking for.

      Author's profile photo Former Member
      Former Member

      Hi ,

      Is this information still not available in BO auditing universe ? We want to get user list in a webi report who have access to dashboards , reports and seems like the only way is through CMC - Query results?

      Regards,

      Rahul

      Author's profile photo Rajith Nair
      Rajith Nair

      Hi Manikandan Elumalai,

      I am trying to use "Query Results" menu in CMC console. We have deployed all BO web applications on JBOSS. We are able to access all menu's present in CMC console page with out any issues except "Query Results" menu.When ever I click on Query Results menu I am ending up with the below issue displayed on the CMC console page:

      JBWEB000065: HTTP Status 500 - javax.servlet.ServletException: java.lang.NoClassDefFoundError: org/apache/xml/serializer/TreeWalker


      JBWEB000309: type JBWEB000067: Status report

      JBWEB000068: message javax.servlet.ServletException: java.lang.NoClassDefFoundError: org/apache/xml/serializer/TreeWalker

      JBWEB000069: description JBWEB000145: The server encountered an internal error that prevented it from fulfilling this request.


      JBoss Web/7.5.7.Final-redhat-1

      We are using JBOSS EAP6.4 and using jboss 7 configuration file for generating war files.

      Do you know any idea about this issue?

      Thanks

      Uday