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!
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Fletcher BurdineTableau 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?
0
wykabryanCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Fletcher BurdineTableau 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!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.