Mapping Report Columns to Universe Obj to Relational Source

[system]

Does anyone know if there is a non-manual (i.e., programmatic) method for mapping Report columns to Universe Objects to Relational Tables / Columns. As the user puts it:

“we are trying to create a map from a column heading displayed on a report back to its source database column without losing details about its field and aliases defined in the BOBJ Universe”

I thought this may be possible through querying the Repository, but nothing looks obvious. Any insight appreciated.

Thanks in advance,
Steve

---

sg1 (BOB member since 2003-05-19)

[system]

@sg1

Does anyone know if there is a non-manual (i.e., programmatic) method for mapping Report columns to Universe Objects to Relational Tables / Columns. As the user puts it:

“we are trying to create a map from a column heading displayed on a report back to its source database column without losing details about its field and aliases defined in the BOBJ Universe”

I thought this may be possible through querying the Repository, but nothing looks obvious. Any insight appreciated.

Thanks in advance,
Steve

Hi Steve and Welcome to Bob .

Try a search on managero. It is a repository universe you can use for report documentation.

---

Cindy Clayton (BOB member since 2002-06-11)

[system]

Also, given that you likely not interested in Oracle, you certainly could convert that universe to Teradata.

---

Steve Krandel (BOB member since 2002-06-25)

[system]

I’ve got a similar requirement:

mapping Report columns to Universe Objects to Relational Tables / Columns

but don’t have ManagerO. I’ve been looking around in the repository, but haven’t found the right table(s) yet. Does anyone know which tables contain this metadata? Thanks.

---

charlie (BOB member since 2002-08-20)

[system]

Hi Charlie,
I also have a similar requirement. I have used successfully the tip Nick Suciu submitted for using the tables OBJ_M_DOCUMENTS and OBJ_M_DOCATVAR to report universe to report to data provider. However, I am unable to move from report to object or data provider to object. I am using the MANAGERO universe. Can anyone help?
By the way, I began by searching on MANAGERO and have tried metadata and did not find the answer!!!
Thanks in advance,
Sue

---

SCOURSEY (BOB member since 2003-06-12)

[system]

There’s nothing in the repository that shows you the report objects in use. You can get data provider to document, but that’s about it. In order to do the type of analysis that you are both asking for requires that you open each report and scan through it object by object, mapping back to the universe meta-data that is contained in the repository.

There are some code samples (VBA) in BOB’s Downloads are that you can take a look at. Also any number of topics in the SDK forum discussing various approaches.

120×120 10.4 KB

I’ve used Dave’s code to identify the list of objects used in a report (and if I could figure out how to link to the download, I would place that link here). I know almost nothing about VBA so it’s a miracle that I got Dave’s code to work for me. My question is “How would I modify the code to obtain the object’s SQL as well?” I am mainly interested in the Select but some of our objects have Wheres also (and I guess the conditions have Wheres instead of Selects!). TIA KSG …

120×120 10.4 KB

I have a directory with over 600 reports in it. One of our objects is changing significantly and we need to identify which reports contain that object. Does anyone know if this can be done without opening each report? crife (BOB member since 2002-08-28)

120×120 10.4 KB

Is it possible to run some VBA code to return the document variables by report tab. ie tab1 uses Variable1, variable2 and tab2 uses Variable3 and Variable4 Nov (BOB member since 2003-10-15)

Also in the Supervisor forum:

120×120 10.4 KB

I am preparing for a potential universe re-design, and I was wondering if there’s a way to query the repository and find out which universe objects are being used on my reports (I’ve found tables that tell me the reports, queries in the reports, and universe objects, but I’m looking for a table to join it all together). I need to know which objects I need to keep my reports working while I trash the unused ones. Thanks, Meredith Meredith (BOB member since 2004-01-26)

120×120 10.4 KB

X-cc: Doug Hansen dhansen@softwareworks-inc.com Hello All, I am trying to write a report that can be used for determining the impact of making a change to an object in a universe. I would like to be able to go against the repository and see all documents that have data providers that use that object so I know which reports need to be tested. I am not finding the details I need. The OBJ_M_DOCATVAR table lists the data providers for a document and tells you which universe it uses. I did a "SEL…

120×120 10.4 KB

Is there a way to query the repository tables to find the name of the objects that are being used in Reports. If there is a way what tables need to be joined together to do this? Listserv Archives (BOB member since 2002-06-25)

Happy reading! 8)

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

Charlie and Sue – and, if you still want to find the ManagerO (for Oracle) universe, it’s not part of the repository by default. It is on the installation CD – I think it was in the freeware subdirectory.

(We’re on Sybase, so we don’t use it…)

---

Anita Craig (BOB member since 2002-06-17)

[system]

Dave and Anita,
Thanks for the quick and detailed responses. Two of the six references should address our remaining needs; all were very informative. We have been using Managero for Oracle for the last couple weeks to support the deployment of database change process and universe management including quality assurance. Some parts of the Managero universe are very easy to use; others are very poor. The report output has been very helpful; the additions provided through referenced material should provide a solid framework for universe management!!!
Thanks, Sue

---

SCOURSEY (BOB member since 2003-06-12)

[system]

Thanks - my excellent BO Systems Administrator gave me access to managerO - it’s really cool! I can get at what I need for now.

---

charlie (BOB member since 2002-08-20)