Class & Object documentation

building semantic layer
1

Abhijit ,

    >I need to prepare a word document containing class & objects in the
    >universe, help text & SQL statement associated with them. I know

these
>inofrmation are stored in back-end tables.

Why not use BusinessObjects ?!

Use the ManagerO universe supplied on the installation CD to create the
report you need then save as RTF etc to get into Word. Simple !

Regards

Jonathan

Project Leader
Management and Commercial Systems
Global Medical, Regulatory and Product Strategy (GMRPS) IS

Listserv Archives (BOB member since 2002-06-25)

2

I have tried using the Managero universe, and have created a report with the
class name, object name, and the Select Clause, but when I replace the
Select Clause object with Object Description from the Object Details
Definition sub-class I get a cartesian results and it generates the
following sql:

FROM
UNV_UNIVERSE,
UNV_CLASS,
UNV_OBJECT,
UNV_OBJECT_DATA object_help1,
UNV_OBJECT_DATA object_help2
WHERE
( UNV_CLASS.UNIVERSE_ID(+)=UNV_UNIVERSE.UNIVERSE_ID )
AND ( UNV_OBJECT.UNIVERSE_ID=UNV_CLASS.UNIVERSE_ID )
AND ( UNV_OBJECT.CLASS_ID=UNV_CLASS.CLASS_ID )
AND ( object_help2.UNIVERSE_ID(+)=object_help1.UNIVERSE_ID )
AND ( object_help2.OBJECT_ID(+)=object_help1.OBJECT_ID )
AND ( object_help1.OBJ_DATATYPE(+)=‘H’ )
AND ( object_help2.OBJ_DATATYPE(+)=‘H’ )
AND ( object_help1.OBJ_SLICE(+)=1 )
AND ( object_help2.OBJ_SLICE(+)=2 )
AND (
UNV_UNIVERSE.UNI_LONGNAME = @variable(‘Choose a Universe’)
)
GROUP BY
UNV_UNIVERSE.UNI_LONGNAME,
UNV_CLASS.CLS_NAME,
UNV_OBJECT.OBJ_NAME,
object_help1.OBJ_DATAVALUE || object_help2.OBJ_DATAVALUE

Are you familiar with this universe and the object_help1 and object_help2
tables?? I am not sure why there is no join between these two tables and
UNV_OBJECT, but I would think you would need this to bring back the
descriptions along with the object names.

Your assistance would be greatly appreciated.

Thanks.

Gail McGuire
Sr. Applications Analyst
CVS Corporation
Pharmacy Data Warehouse
401-765-1500 x2236

Why not use BusinessObjects ?!
Use the ManagerO universe supplied on the installation CD to create the
report you need then save as RTF etc to get into Word. Simple !
Regards
Jonathan
Project Leader
Management and Commercial Systems
Global Medical, Regulatory and Product Strategy (GMRPS) IS

Date: Tue, 9 Mar 1999 16:13:23 -0000

Abhijit ,
>I need to prepare a word document containing class &
objects in the
>universe, help text & SQL statement associated with them. I
know
these
>inofrmation are stored in back-end tables.

Listserv Archives (BOB member since 2002-06-25)

3

In a message dated 99-03-10 08:36:02 EST, you write:

Are you familiar with this universe and the object_help1 and object_help2
tables?? I am not sure why there is no join between these two tables and
UNV_OBJECT, but I would think you would need this to bring back the
descriptions along with the object names.

Object_help1 and object_help2 are aliases for the UNV_OBJECT_DATA table. That
table contains four different types of records: Selection, Where, Help, and
Format. (Format was new in 4.1) To specify which record type you want, you
have to specify the datatype (record type), as in:

AND ( object_help1.OBJ_DATATYPE(+)=‘H’ )
AND ( object_help2.OBJ_DATATYPE(+)=‘H’ )

To make sure that you don’t get the same row twice, you have to specify which
“slice” of help text (or other record types) you are looking for. As in:

AND ( object_help1.OBJ_SLICE(+)=1 )
AND ( object_help2.OBJ_SLICE(+)=2 )

One of the problems with the ManagerO universe is that the designer elected to
hard code some limits. In this case, only the first two “slices” of help text
are going to be displayed. This is, to be fair, probably adequate for most
universes. Some times I tend to be a little long winded. :slight_smile:

The reason you are getting a cartesian in the SQL being generated is that you
are missing the join between UNV_OBJECT and object_help1 / object_help2.
Looking at the where clause:

( UNV_CLASS.UNIVERSE_ID(+)=UNV_UNIVERSE.UNIVERSE_ID )
AND ( UNV_OBJECT.UNIVERSE_ID=UNV_CLASS.UNIVERSE_ID )
AND ( UNV_OBJECT.CLASS_ID=UNV_CLASS.CLASS_ID )
AND ( object_help2.UNIVERSE_ID(+)=object_help1.UNIVERSE_ID )
AND ( object_help2.OBJECT_ID(+)=object_help1.OBJECT_ID )

There is a join
from UNV_UNIVERSE to UNV_CLASS
from UNV_CLASS to UNV_OBJECT

but not from
UNV_OBJECT to object_help1
UNV_OBJECT to object_help2

Therefore the cartesian. The join should, if memory serves, be done on
UNIVERSE_ID and OBJECT_ID. Check the design of your ManagerO universe to be
sure that those joins are present.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

PS - Business Objects “old timers” can probably remember why this universe is
called ManagerO…

Listserv Archives (BOB member since 2002-06-25)