Skip to Content
Author's profile photo Manikandan Elumalai

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!

Assigned tags

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

      Hi.

      Thx for posting!

      May I ask if you can tell me how to export the results from the relationship query? Export to CSV is disabled?

      BR,

      Michael

      Author's profile photo manesh KS
      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

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

      Try to give access to "Query Results" at root folder level and see how it works.

      Author's profile photo Masood Aftab
      Masood Aftab

      Hi Mani,

      There is no such right for this. Could you please specify where we can find this.

      Regards

      Masood

      Author's profile photo Marian Hatala
      Marian Hatala

      is there a way to make relship query for multiple objects at once? eg. for all the reports in a folder ...

      Author's profile photo Masood Aftab
      Masood Aftab

      No we cannot...

      Author's profile photo Keith Fisher
      Keith Fisher

      thanks for posting this