ORACLE comments as help text available

building semantic layer
1

Column comments as help text inside BO: Updating the definitions once the universe has been created. Options are cut and paste from the oracle table into the objects, create a
script
(possibly based on a trigger) to update the repository. Note1 : Using the table browser to bring new tables into the universe
does
not read the strategy file, therefore, the associated Oracle comments
will
not be brought into the universe.

Thanks for your detailled information.
Since we have created our universes already, I probably have to populate the
BO repository table(s) with the comment information of the ORACLE database with a script.I was looking through the BO repository tables but couldn’t find the table
where the comment/description would be stored. Do you know which table(s) are applicable?Another question: how do you bring in new tables in a universe if you don’t
use the table browser (“note1”)?

Best regards,

Andrea Halbherr
Novartis Crop Protection
Switzerland

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

2

(Andrea Halbherr) schrieb:

Column comments as help text inside BO: Updating the definitions once the universe has been created. Options are cut and paste from the oracle table into the objects, create a
script
(possibly based on a trigger) to update the repository. Note1 : Using the table browser to bring new tables into the universe
does
not read the strategy file, therefore, the associated Oracle comments
will
not be brought into the universe.

This is not completely true, because using an “external strategy” (see designer manual) will read column comments… when using “insert candidate objects” instead of the “insert table” menue.

Walter

Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna, Austria Tel. +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at

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