Now , i see the problem. Our intelligent designers mised out the where clause. Moreover, joining those two objects into one object is also not possible.
Now, I would like to get some more information as well.
I am really confused as to what is meant bu Business Objects Repository.
We have a sSecurity domain which lies on one server and a document Domainand Universe domain which lie on other.
Now which one should I consider as my BO Repository?
Now What confuses me here is, as you said, a repository is a combination Security Domain, Document Domain, Universe Domain.
Now if my, Scurity Dman, Universe Domain and Document Domain le on 3 different servers, say a,b,c respectively. Then on which server can i say has my BO Repository? Is it a, b or c?
Just to add to Andreas …
The whole point of a distributed repository is that you can distribute your docs and universes across different servers/schemas…
The general practice is to have 1 repository – which would include 1 security domain and multiple universe/document domains which would pertain to the Dev, QA and Prod environment… instead of having 3 different repositories – one for each of these environments…
Yes!! Information about the document and universe domain are held in the security domain… There exists a pdf about the tables in a repository and what each table consist of!! That would be a starting point!!