BusinessObjects Board

using BO repository tables via SQL

general discussion
#1

Hello !

I would like to create SQL queries running into the business objects universe database. The goal is to make links between reports and universe objects, in order to be able to get a list of all te reports using a specific object.

Is it possible ? :confused:

Thank you very much, and well,
have a nice Christmas time !

MGO

MGO :belgium: (BOB member since 2005-05-26)

#2

Hi,

please have a look into these parts of BOB download section:


I hope you will find it helpful.

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

Hello Marek !

it was almost perfect ! :smiley:

thanks to the macro, i have created a new table which can be used to link
the document tables to the universe tables into the repository.

It is now possible to find a list of reports using a precise database column, and so to do some impact analysis on database changes !

thank you for the links !

MGO

MGO :belgium: (BOB member since 2005-05-26)

#4

You are welcome 8)

Though, you should not thank me but author of the macro -> Dave Rathbun :wink:

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)