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
2. Universe Relationship query
3. Connection Relationship query
4. User Relationship query
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!
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
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
Try to give access to "Query Results" at root folder level and see how it works.
Hi Mani,
There is no such right for this. Could you please specify where we can find this.
Regards
Masood
is there a way to make relship query for multiple objects at once? eg. for all the reports in a folder ...
No we cannot...
thanks for posting this