Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

Is it possible to build a report off of the CMS DB in Business Objects Enterprise?

Can I build a report off of the CMS DB in Business Objects Enterprise? I would like to be able to produce a report that would give me the basic "at a glance view" of all the settings in a BOE scheduled report. The items I would like to pull into a CR would be Schedule, Destinations, Notification, Format and Database Settings? Also the Report Name the user that scheduled it etc.
Is this possible............................someone told me you could not get to it becuase the data was encrypted.

Please Help! Thank you!
  • 2
1 Solution
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
Would I use ODBC or whatever we have the DB built on....ie SQL or Oracle?

Do I need to use the SDK in order to do this?

Is there any documentation on how to do this anywhere?
Yes the CMS tables within BOE are encrypted.  There should be an application that came with Enterprise called Query Builder.  I have used it, it does not provide the information that you are looking for.  What version of CRE are you using?

If you are using 11, there is an option to turn on BOEAudit database.  This database capture, what reports are scheduled, the run times, who has view/scheduled what report,ect... This might shed more light on it.
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
We are using 11 and the audit is a help it does not give us everything. What a shame you think BO would make that a freebee' so that its consumers could look at the data at a glance to get what is currently set up. I see that BO has a few tools that show instances and schedules. What I was thinking was more like a big form type format where you could see the items that were scheduled where and who they were scheduled to when would the be scheduled without having to look up all the individual settings up.....one tab at a time.

I need a report(s) BIO all at once. Boy Business Objects missed an opportunity there!

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now