I have been taking time to define and rename the objects in our main production universe. I haven’t changed anything in the structure, only in the descriptions of objects, and the grouping of objects within classes. Should I be wary of ANYTHING before exporting this overtop of the current production universe? I have not done a save as for this universe, it is the same name and same id. Just trying to take every precaution…
Michele Robertson
Southern California Edison
Analyst
Phone: 909-394-8573
You don’t say which version you’re using, but on my current installation, 3.1 for SunOs, I’ve renamed objects and noticed that references to the old names in queries didn’t pick up the change. It was simple enough to remove and re-add the objects but if you have lots of established queries it’s something to consider.
Steve Aultman
Chevron Information Technology Co. smau@chevron.com
From: Robertson, Michele R [SMTP:ROBERTM1@SCE.COM]
I have been taking time to define and rename the objects in our main production universe. I haven’t changed anything in the structure, only in the descriptions of objects, and the grouping of objects within classes. Should I be wary of ANYTHING before exporting this overtop of the current production universe? I have not done a save as for this universe, it is the
same name and same id. Just trying to take every precaution…
You don’t say which version you’re using, but on my current installation, 3.1 for SunOs, I’ve renamed objects and noticed that references to the old names in queries didn’t pick up the change. It was simple enough to remove and re-add the objects but if you have lots of established queries it’s something to consider.
Steve Aultman
Chevron Information Technology Co. smau@chevron.com
From: Robertson, Michele R [SMTP:ROBERTM1@SCE.COM]
I have been taking time to define and rename the objects in our main production universe. I haven’t changed anything in the structure, only in the descriptions of objects, and the grouping of objects within classes. Should I be wary of ANYTHING before exporting this overtop of the current production universe? I have not done a save as for this universe, it is the
same name and same id. Just trying to take every precaution…
Should I be wary of ANYTHING before exporting this overtop of the current production universe? I have not done a save as for this universe, it is
the
same name and same id. Just trying to take every precaution…
As long as you haven’t deleted objects I have found that all the reports continue to work fine. Changes to names and help text and in fact, to the SELECT and WHERE conditions seems to be recognised as soon as a report is run with data/edit/run. If you do not run reports and export them and users are going to use the old reports and only run them using data/refresh then I’m not sure if the new information will be picked up or not. A universe import would be triggered by you exporting the new universe but I’m not sure if the report would not be regenerated. I think this probably means that changes to WHERE and SELECT that affect the SQL generated would not be picked up but I’m not sure about naming and help text.
I am using version 4.1.3. I wonder if your problem hold true for this version?
From: Aultman, Steven (SMAU)[SMTP:SMAU@CHEVRON.COM]
Sent: Tuesday, September 29, 1998 9:19 AM
You don’t say which version you’re using, but on my current installation, 3.1 for SunOs, I’ve renamed objects and noticed that references to the old names in queries didn’t pick up the change. It was simple enough to remove
and re-add the objects but if you have lots of established queries it’s something to consider.
Steve Aultman
Chevron Information Technology Co. smau@chevron.com
From: Robertson, Michele R [SMTP:ROBERTM1@SCE.COM]
I have been taking time to define and rename the objects in our main production universe. I haven’t changed anything in the structure, only
in
the descriptions of objects, and the grouping of objects within classes. Should I be wary of ANYTHING before exporting this overtop of the
current
production universe? I have not done a save as for this universe, it is the
same name and same id. Just trying to take every precaution…
Renamed (or moved) objects are not a problem in the 4.x product. In the 3.x product objects were identified by name, so if you renamed an object it would no longer be valid in existing queries. In version 4, objects are identified by a hidden ID number which stays the same even if you rename or move the object.
If you delete and add an object, however, all bets are off! It will not have the same ID number… will in fact be treated as a “new” object. So, if you want to change the class an object is in use the drag and drop “move” instead.
In a message dated 98-09-29 13:26:10 EDT, you write:
I am using version 4.1.3. I wonder if your problem hold true for this
version?
From: Aultman, Steven (SMAU)[SMTP:SMAU@CHEVRON.COM]
Sent: Tuesday, September 29, 1998 9:19 AM
You don’t say which version you’re using, but on my current installation, 3.1 for SunOs, I’ve renamed objects and noticed that references to the
old
names in queries didn’t pick up the change. It was simple enough to remove
and re-add the objects but if you have lots of established queries it’s something to consider.
If you delete and add an object, however, all bets are off! It will not
have
the same ID number… will in fact be treated as a “new” object.
So, if you
want to change the class an object is in use the drag and drop
“move” >instead.
I have only used the “drag drop” method when moving objects. However, if I have created new objects (i.e. an object that concatenates first name and last name) and deleted objects that have not been used in any queries, will I encounter problems? If so, can you give me any hints as to what to expect? Thanks
In a message dated 98-09-29 15:06:21 EDT, you write:
I have only used the “drag drop” method when moving objects. However, if I
have created new objects (i.e. an object that concatenates first name and last name) and deleted objects that have not been used in any queries, will I encounter problems? If so, can you give me any hints as to what to expect? Thanks
Nope. If you are absolutely sure that none of the deleted objects are used in any queries, then you should not have any problems. The only issue that can occur, and I think that the latest version of BusObj (4.1.3) does not have this same problem is this:
Query has existing object with ID 20
Universe designer deletes object with ID 20 3. Universe designer creates new object, gets assigned ID 20 4. User opens query and sees unexpected object on the query panel…
I don’t think that Object ID’s should be reused. I have seen this behavior in prior versions (typically in the 4.0.x family) but you should not have this problem in 4.1. Especially since you are sure that none of the deleted objects have been used in queries.