Audit Tables (Problem with data in CMS_InfoObjects5 table in BUSOBJDEV db)

[Former Member]

We are trying to write reports of the built in business objects audit tables however, there is some sort of hex coding on fields like SI_CUID in the CMS_InfoObjects5 table in the BusObjDev database. Is there some way of decoding this information to make it useful. We had several reports that worked off this database when we were running business objects 10, but the hex numbers replaced text in this field and several others when moved to business objects XI. Any information would be helpful. Thanks

Ex.

SI_CUID = 0x41566D4A6971644F766F52426F55317651435A79644645

[Former Member]

Hi Jefrey powell

Could you please tell me how you resolved this kind of issue. even me facing the same problem on how to decode the hex values .

Appreciate your help

Thanks & Regards

Sunil

[Former Member]

This task was removed from our priority list, so it wasn't permitted to pursue this.  It looks like several of the other comments could prove useful.

Sorry for the inconvenience.

[former_member183781]

Since I know the product teams sometimes review these boards.

WISHLIST request for an ODBC or other data-source driver in Crystal Reports that could write reports directly against the QueryBuilder tool for the CMS database.

Writing reports against the AUDITOR Universe isn't very helpful, since the AUDITOR <Document Name> function is specific to WebI documents.

In fact, a wholesale update of the AUDITOR Universe and pre-canned WebI and Crystal Reports (that handled all the Object types/actions) would be nice.

[Former Member]

Mark,

You may be interested in trialing this:

http://analytics8.com/system-profiler

[Former Member]

Just dug up this link too - you may find this interesting....

/people/ted.ueda/blog/2009/02/23/web-intelligence-xi-3x--reporting-off-the-businessobjects-enterprise-cms-via-data-access-ddk

[Former Member]

The bulk of the information in these tables is in binary format, and needs to be decoded before you are able to extract for reporting. You have a few options: Query Builder for occasional ad-hoc queries (although the data will be html on-screen and not suitable for reporting, SDK scripting to extract the data from InfoStore, or a 3rd party solution for this (System Profiler is one available for free trial - extracts BOXI metadata and loads to DB for reporting).

Hope this helps...