BusinessObjects Board

Add joins to universe / joins to contexts using Macro

sdk development
#1

Hi

I tried the Macro written by Dwayne Hoffpauir ( https://bobj-board.org/t/24722) and also i went through the Related Post ( https://bobj-board.org/t/24693) but I am finding it not working properly.

I just opened the Excel sheet & selected the Macro ( GetLists) , but before this I included the 2 libraries :

Business Objects 11.5 object library
Business Objects 11.5 Deisgner object library

And after running the Macro , it is displaying error :

[b]Compile Error:

User Defined type not Defined. [/b]

can anyone let me know how to solve this error ?

Thanks Aniket

aniketp :uk: (BOB member since 2007-10-05)

#2

The original utility was probably written for v5.x, and some syntax has changed with XI. I’m going from memory here, but change .LogonAs to .LogonDialog.

By the way, you only need to reference the Designer library.

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

#3

Ya I tried changing LogonAs to LogonDialog , then also it is giving the same error. I don’t know what is wrong.

This change i made previously also , somewhere I red that instead of LogonAs , one has to use LogonDialog , so I did the change , but after that also it’s not working.

Thanks
Aniket

aniketp :uk: (BOB member since 2007-10-05)

#4

… and this happens on what line of code?

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