I have a question regarding universe and object id’s. I tried to Search but it doesn’t seem to be working…Here is the question, when I create a universe and it’s objects as part of one repository I believe that a universe id will propogate relative to this repository and each object has it’s own id within the universe. When I complete a ‘Save As’ and ‘For All Users’ this releases the universe id from the repository that it is a part of. When I export this newly saved universe to another repository a new universe id is created and assigned by the new repository. Do new objects id’s get created as well or will the object id’s be the same from one repository to another for identical universes?
Hi,
As I understand you are migrating universe from one repository to another. As we export the universe to another repository new record is created in the BO repository and new id is assigned to it and with respect to this new id other things like classes, objects, joins etc are also stored with new id.
I’m not totally convinced that the universe’s components such as joins, objects, contexts etc would all get different id’s from one repository to another. Wouldn’t the universes components be proprietary to the universe itself rather than the repository?? I do understand that the universe would indeed get a different new/different id as the universe would become a part of the new/different repository.
OK, so here is the scenario. If I have a report that references a universe in the repository, it uses the object id’s from the universe to know what objects are in the query panel of the dataprovider. If I create a modification to that universe in another repository either modifying an object(s) or adding an object(s) and then complete the ‘Save As’ 'and enable ‘For All Users’ to release the present repository security id and migrate it to the repository where the report is I need to overwrite the original universe or delete the universe from the domain and then export the newly modified universe to the repository to be used as the new reference. What would happen exactly? Since so far all my reports still work after this process what happens? Do the object names become referenced for the generation of the query panel of result objects or the object id’s? I’m not sure??
The reason that this is working is because Business Objects will first ‘look’ for the object name not the id. So if you migrate the universe and the reports everything will be in sync. There are several discussions around this, if you get a chance you could search - maybe use migrate universe or migrate report.
One thing to note - if you want to rename an object I would recommend NOT deleting it and then adding back a new object. Any existing reports will not be able to ‘find’ the object because the name changed and the object id changed. To change an object name use the rename option that way reports are still able to ‘find’ the object.
While working with BO i found that the report actually works on SQL. This SQL is created when we initially create the report.
When we try to edit the report it goes to BO repository It locates the universe name that is stored in the report at the time of creation and display that universe. You can try it your self, just delete the current universe and then export the another universe with same universe name and same file name and try to edit the old report you will find the new universe in the edit part
I’ll do a search to get more info on this topic as I thought the only time that object names were used to verify which objects were to be in the query panel of the dp was if you were changing the target universe through the data manager (cube). Other than that I thought that the report used id’s that is why I deduced that the universe kept the same object id’s across all repositories. Presently we do not delete any objects only modify or create new objects.
(BOB member since 2003-05-28)
(BOB member since 2004-02-27)