BusinessObjects Board

Universe join

building semantic layer
#1

hi all,

I need to change a join between two tables table1 and table2(alias table).

the existing join is

dbo.table1.field1=table2.field2

the new join looks like below

dbo.table1.FIELD_1 = table2.field2

whereas table1.field1 and table1.FIELD_1 are of same data type. the number of rows returned by these two fields are different.

I want to do impact analysis by changing the table join.
Is there any easy way to check which are the objects created using these tables

can anyone tell me the list of thing that need to be analysed as a part of this…

daffodils (BOB member since 2007-08-09)

#2

So you actually want to document the universe and find which reports are pointing to the objects in the universe
Then have a look into BOB downloads there are utilities for the same
Like List objects in a report

.

haider :es: (BOB member since 2005-07-18)