BusinessObjects Board

Any way to edit an existing universe?

sdk development
#1

Hi,

In our BO setup, we need to do some periodic maitenance activities for some of the existing universes. This is kind of creating new classes, updating some objects and deleting some classes/objects.
So we were thinking of using the VBA to automate this. Is this possible using a VBA?
If yes, any pointers about how to do this?
If No, any other way to do this?

Your opinions will be highly appreciated. :!:

Thanks,
smartvnr

smartvnr :india: (BOB member since 2003-09-24)

#2

Yes, this is possible using VBA

refer sample code from BOB
https://bobj-board.org/t/24722

Shahubar Sadiq :india: (BOB member since 2003-02-28)

#3

Hi Shahubar,

Thanks for your response. Is there any way to copy-paste existing objects/classes etc?

  • smartvnr

smartvnr :india: (BOB member since 2003-09-24)

#4

There is no copy paste in SDK,
Read the classes and objects through loop or specific object then Add those objects with different names

Shahubar Sadiq :india: (BOB member since 2003-02-28)

#5

Hi,
I am trying to export the universe using VBA…

'exporting the universes...
    universes.Export("Universe", "Company", my_unv.Name, 0)

But this statement is throwing following error:-

Any pointers… ?

  • smartvnr

smartvnr :india: (BOB member since 2003-09-24)

#6

It’s a VBA syntax issue. Add the Call keyword in front, or remove the parentheses. Either of the following should work:

Call universes.Export("Universe", "Company", my_unv.Name, 0)
universes.Export "Universe", "Company", my_unv.Name, 0

A discussion on the applicable VBA syntax, and options can be found here.

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

#7

Thanks,
that worked! :mrgreen:

  • smartvnr

smartvnr :india: (BOB member since 2003-09-24)

#8

You’re quite welcome …

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