BusinessObjects Board

How to update all objects properties in a Universe at atime?

sdk development
#1

Hi ,

I want to select the check box Export with Universe for List of Values of all objects in a universe, it has arount 1500 objects. Can some one please help me with this.

Thanks,
Sreeni.

princesreenu (BOB member since 2006-11-29)

#2

The following is a way to set the property using the Universe Designer SDK.
The code only shows how to update one of the objects.
You will need to add some code to iterate through all the objects.

    Dim boDesApp As Designer.Application
    Set boDesApp = New Designer.Application
    
    boDesApp.Logon "username", "password", "CMS", "secEnterprise"
    
    Dim boDesUni As Designer.Universe
    Set boDesUni = boDesApp.Universes.Open("universe name")
    
    Dim boDesObj As Designer.Object
    Set boDesObj = boDesUni.Classes(1).Objects(1)
    boDesObj.ExportLovWithUniverse = true

    boDesUni.Save
    boDesUni.Close
    
    boDesApp.Quit

darcstorm :philippines: (BOB member since 2008-07-22)

#3

This sample is used to disable all LOV’s, and could be tweaked to turn on the export property.

That said, I honestly can’t imagine why you would want to do this. Are ALL of your LOV’s customized? Or do the values NEVER change? The only reason to export an LOV is if it has been customized, or if you want it exported already populated.

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

#4

Hi Thanks for reply.

when the users try to select the values for the prompts in a report they need to refresh the list of values every time and it is taking very long to get the list, the users need the list of values stored so that they can select with out refreshing.

Thanks,
Sreeni.

princesreenu (BOB member since 2006-11-29)

#5

But setting the LOV’s in the universe to export is not going to accomplish what you are after. You would have to go through each one, refresh it yourself, and export the ENTIRE UNIVERSE every time a value changes!

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