Does anyone know if there is a place to get BO repository metadata? We’re finding a need to query the repository and are making lots of guesses as to its table structure, joins, etc. Any suggestions would be welcome.
Thanks!
Erik
Erik Wilkinson
Business Analyst - Datawarehouse Group
Bass Hotels & Resorts
Erik.Wilkinson@basshotels.com
Listserv Archives (BOB member since 2002-06-25)
Well…the Repository Metadata is not supported by Business Objects. However, if you know the connect string for your BO repository database.(and password of course)…you can go in there and query the objects existing. Some of the usual tables that exists are listed below. However, one won’t get any documentation on these schema objects. However, I am sure there are many gurus in this list who have dug into those tables and know the inter relationship. So go into these tables and fire in your specific query. Some of the objects are such that you can make a intelligent guess on what data they hold. Hope this helps.
Thanks,
Vinay.
DS_PENDING_JOB
DS_USER_LIST
OBJ_M_ACTOR
OBJ_M_ACTORDOC
OBJ_M_ACTORLINK
OBJ_M_CONNECTDATA
OBJ_M_CONNECTION
OBJ_M_DOCCST
OBJ_M_DOCUMENTS
OBJ_M_GENPAR
OBJ_M_MAGICID
OBJ_M_REPOSITORY
OBJ_M_RESERVATION
OBJ_M_RESLINK
OBJ_M_TIMESTAMP
OBJ_M_UNIVCST
OBJ_M_UNIVDBCST
OBJ_M_UNIVERSES
OBJ_M_UNIVSLC
OBJ_X_DOCUMENTS
UNV_AUDIT
UNV_CLASS
UNV_CLASS_DATA
UNV_CONTEXT
UNV_CONTEXT_DATA
UNV_CTX_JOIN
UNV_DIMENSION
UNV_DIM_OBJ
etc.
Does anyone know if there is a place to get BO repository metadata? We’re finding a need to query the repository and are making lots of guesses as to its table structure, joins, etc. Any suggestions would be welcome.
Thanks!
Erik
Listserv Archives (BOB member since 2002-06-25)
Erik, look at the information contained in this folder of your installation CD.
F:\Freeware\repostry
Start with F:\Freeware\repostry\rpindex.htm (F: is the drive letter of my CD.)
Good luck.
Jean-Francois Cayron
InfoSol Inc.
http://www.infosol-inc.com
Listserv Archives (BOB member since 2002-06-25)
Erik,
There is a universe which comes with BO called Managero.unv which is the repository universe. You should be able to use this.
Chris
Listserv Archives (BOB member since 2002-06-25)
Only if you use Oracle and do not need to see the version 5 changes…
Listserv Archives (BOB member since 2002-06-25)