Skip to Content

Continuing with my blog on Security Query BusinessObjects Administration – The less known Security Query and Relationship Query , here is the one for Relationship Queries. Similar to Security queries, Relationship queries can be viewed in Query Results menu of the CMC,however you cannot create Relationship queries there. Relationship queries will be always created from the BusinessObjects logical path (actual Folder path of the object) and the relationship query will  be generated in Query results menu.

In this blog, I am going to generate relationship query for the following type of objects.

  • Report (WebI)
  • Universe
  • Connection
  • User

1. Report Objects Relationship query

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

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

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

2. Universe Relationship query

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

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

3. Connection Relationship query

/wp-content/uploads/2013/09/6_279132.jpg

4. User Relationship query

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

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

Points to Consider

  • You can only execute relationship queries for Relational connection Objects
  • Relationship queries are Session specific and you cannot be preserve it for next login.
  • For user centric relationship queries inherited access levels will not be identified.

Hope this could help you guys to perform Impact/Lineage analysis for the required objects in the repository. Thanks for reading!

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. manesh KS

    Hi Manikandan Elumalai,


    Could you give me details of the level of access required to view this option.


    As few of our users are asking to have this enabled in production, mainly we doesn’t want to give full control rights or admin rights to anyone.


    could you please help us on this.


    Thanks

    Manesh K S

    (0) 

Leave a Reply