BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Caveats when exporting universe?


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 29, 1998 10:37 am 
Post subject: Caveats when exporting universe?



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


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 29, 1998 11:19 am 
Post subject: Caveats when exporting universe?



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...

>Michele Robertson
>Southern California Edison


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 29, 1998 11:27 am 
Post subject: Caveats when exporting universe?



>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...

>Michele Robertson
>Southern California Edison


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 29, 1998 12:12 pm 
Post subject: Caveats when exporting universe?



>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.

Louise Priest
Fraser Williams Pharma Systems
lpriest@pharma.fraser-williams.com


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 29, 1998 12:25 pm 
Post subject: Caveats when exporting universe?



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...

>>Michele Robertson
>>Southern California Edison

>Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
>For old 3.1 info: http://www.upenn.edu/computing/da/bo/busob-faq.html
>Search: Mail to listserv@listserv.aol.com, 'search a_phrase in BUSOB-L'
>Unsubscribe: Mail to listserv@listserv.aol.com, 'unsubscribe BUSOB-L'



_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 29, 1998 12:55 pm 
Post subject: Caveats when exporting universe?



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.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

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.


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 29, 1998 2:05 pm 
Post subject: Caveats when exporting universe?



>Dave Rathbun wrote:
>>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


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 29, 1998 2:12 pm 
Post subject: Caveats when exporting universe?



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 <grin> 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:

1. Query has existing object with ID 20
2. 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.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0284 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0247)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo