Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How do I List Report Data Sources

I have recently migrated from CE 9 to BOS XIR3.0 and i need to know which datas sources the reports i migrated are using (I thought i was using only one but it looks like there may be some more).

In CE 9 i could use the report datase source tool. Is there something similar in XI R3.0? I tried looking at the CMS Database but couldn't find any tables/fields that looked like they had the required info.

Thanks in advance Duncan

Former Member
replied

The Connection page only show those used by a Semantic Layer - Universes or Business Views.

For Crystal Reports connection not using a Semantic Layer, you can user the Query Builder (http://<hostname>:<port>/AdminTools) and run a query of the form:

Select TOP 1000 SI_ID, SI_NAME, SI_PROCESSINFO.SI_LOGON_INFO from CI_INFOOBJECTS Where SI_KIND='CrystalReport' and SI_INSTANCE=0 

to get a listing of the connection infos for reports.

Sincerely,

Ted Ueda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question