Skip to Content

BusinessObjects Administration – Relationship Queries

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!

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