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

Posted on 2006-03-30
Last Modified: 2008-02-01
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!
Question by:ruavol2

    Author Comment

    Would I use ODBC or whatever we have the DB built 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?
    LVL 16

    Accepted Solution

    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.

    Author Comment

    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 tab at a time.

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now