1. I have created a custom object "Associated Releases" and have enabled it in the data warehouse.
2. Created a new OBS and associated it to the newly created custom object "Associated Releases".
3. I have created instances for the custom object "Associated Releases" and also selected the associated OBS.
4. Now I need a query that would fetch all the instances if the custom object associated with a specific OBS unit.
Thanks in advance.
Not a data warehouse table, but the current relationship is held in the PRJ_OBS_ASSOCIATIONS table. Search for that on the community and you will find several examples.