BusinessObjects Board

Amending Various Objects

I have create 100+ object that need to change only slightly. I.e

I have a class called ST complete
and each object is like this …

max(decode(SITE_TASKS.WOT_TOS_TAS_CODE,‘01010’,SITE_TASKS.WOT_COMPLETE,NULL))

I now need to copy the 100+ objects and change WOT_COMPLETE TO WOT_PLANNED

Is there a way of doing this by mass or do I have to go through each 100+ record individually and amend manually :nonod: .

help me BOB fans u r my only hope :’’’-(

Cheers
Sherpa


Sherpa :uk: (BOB member since 2003-12-02)

Would a database synonym work?

Create a synonym with the old universe object reference that points to your new database object. Assumes you are getting rid of your old object.

But personally I would change all the objects one by one.


Miguel Varela (BOB member since 2002-08-15)

If you are in v6 you can try using the “replace” feature under the Edit Menu in Designer


tp_4321 (BOB member since 2003-09-21)

Another option is the Designer SDK. This utility updates names / descriptions, but could be modified to do the same for the Select statement.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)